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

Use your function in a spreadsheet cell

googlespreadsheetimg8.jpg

In cell C2, use your custom facebookLikes function on your URL in cell B2 with this formula:

=facebookLikes(B2)

and you should see the number of likes appear after you hit Enter.

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