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 5 of 14

Use the script editor


... and choose Spreadsheet under "Create script for" header. You'll get a page of code that includes a couple of default functions: readRows() and onOpen().

Create a new blank function, calling it anything you wish. Here I'll call it facebookLikes with a single argument, the URL:

function facebookLikes(url) {


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