Google Spreadsheet API
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.