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

Create a Google spreadsheet

Head to Google Drive and create a blank spreadsheet (if you don't yet have a Google account, you can sign up there). Title the sheet anything you want, and you're ready to begin. (The default will be "Untitled spreadsheet," but you can click on that to change it to something that will better identify it in your list of documents.)