Google Spreadsheet API

From IntereditionWiki

Revision as of 15:51, 17 July 2012 by Dougreside (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Name of tool: Google Spreadsheet API

What is it for: Writing to and reading from Google spreadsheets

What I'm using it for: Storage of small amounts of non-critical metadata in an environment that is easily editable by non-technical users

Use-case narrative: I needed to build a site very quickly to allow users to complete a form and store their data in a database. This data would then be used to populate a visualization. As the data came in it was reviewed and sorted by a colleague without computer programming experience. This colleague wanted to manage this data in something like an Excel spreadsheet. Google Spreadsheets was ideal, but I needed a way to get the data in and out programmatically. Google Forms would not work as an input method as I needed the form to exist on a page with other elements and I didn't want to forward them away from the page after submitting the form.