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.

By Sharon Machlis, Computeworld |  IT Management, Google, google docs

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)

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

Answers - Powered by ITworld

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

Ask a Question
randomness