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

Schedule your function to auto-run

googlespreadsheetimg13.jpg

Last piece: Schedule your new store-the-data function to run. Click on the clock icon and choose "Add a new trigger." You'll be able to set your function to run whenever the spreadsheet is opened manually (choose "From spreadsheet" as the trigger event) or on an automated schedule (select "Time-driven" as the event) -- hourly, daily or weekly. 

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