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

Write a spreadsheet function


Now that you've got your properly formatted data-request URL, it's time to go fetch the data by writing a spreadsheet function. In Google Spreadsheet, you do that inside the sheet's associated script page.

Select Tools --> Script editor ... (continued on next slide)

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