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.

Computeworld –

Let your spreadsheet do the work

googlespreadsheetimg1_0.jpg

Tracking basic data in a spreadsheet is pretty simple -- it's remembering to update your data each day, week or month that can be a problem. But why update manually when you can take advantage of some simple automation tools?

Here's a step-by-step guide to creating an automatically updating Google spreadsheet to track data. We'll use "number of Facebook followers" in this example, but the code can be easily updated to fetch and store other data as well.

[13 killer Chrome apps to replace your desktop software and 10 great Google tools you need in your business workflow]

1 2 3 4 5 6 7 8 9 10 11 12 13 14 Page
From CIO: 8 Free Online Courses to Grow Your Tech Skills
Join the discussion
Be the first to comment on this article. Our Commenting Policies