How to create an automatically updating Google spreadsheet

Tired of finding, copying and pasting data into spreadsheets? With just a few lines of code, you can set up a self-updating spreadsheet in Google Docs that fetches and stores data for you, as this Facebook example shows.

By Sharon Machlis, Computeworld |  IT Management, Google, google docs

Write a function to store data

To store data, we need to find the first empty column. Do this by setting a variable name for the active spreadsheet, getting the data range in that existing sheet with the getDataRange() command and then creating variables to hold the number of columns and number of rows. You can see the start of a storeLikes() function at left.

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

Answers - Powered by ITworld

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

Ask a Question
randomness