Google Spreadsheet API

From IntereditionWiki

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.

Dependencies

  • Google account
  • Connector for your server side language of choice (I used Ruby, Sinatra, and the Google API Ruby client) [1]

What I did