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

Add your first formula

googlespreadsheetimg3_0.jpg

Spreadsheet formulas can do more than math calculations; they can also extract data from an API such as Facebook's. Since you may want to track more than one page -- not only yours but competitors' -- we'll set it up to be easily scalable.

In the first column, list the Facebook accounts you want to track. In the second column, create a formula to find number of likes from the API using this format:

https://graph.facebook.com/accountID (replace that with the account ID or name)

To do so, your column B formula needs to add the URL root  "https://graph.facebook.com/" to the account name from column A, like so:

=CONCAT("https://graph.facebook.com/",A2)

and so on for the other rows.

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