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.

Page 10 of 14

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.

| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Page 10
ITWorld DealPost: The best in tech deals and discounts.
Shop Tech Products at Amazon