by Christian P. Sarason
I was inspired by a talk that I saw at the May 2018 CUGOS meeting, where Sam Matthews gave a quick talk about using the Google Sheets API to save geojson data to a spreadsheet. I thought it was a cool concept and I love Sam’s admonition to practicality, “spreadsheets are always my default interface for data entry”. Basically, everyone knows how to use at spreadsheet, so while things like InfluxDB are super powerful and fun to play with, when developing a prototype to share out in the world, all of a sudden you need to manage user accounts, security, blah, blah, blah. I can do all that, but really just want a place where multiple users can share some prototype data and collaborate while we focus on the UX of the page instead of the IT nitty gritty.
Enter the Google Sheet API! It is pretty easy to get started, and has the benefit that you can have stuff password protected, with user management controlled by sharing the sheet with your colleagues. This was a perfect fit for the OrcaMap prototype I have been working on for the good folks at OrcaSound.
This prototype was designed to be a quick and easy way to log orca locations. (the locations are all bogus — there are not orca swimming around Harbor Island’s shipping terminal!). The data is somewhat sensitive, so we want to limit access as well as provide for a verification step (to keep bad data from entering the map). The best part? Google kindly provides a very straightforward Sheets API Quick Start guide, and it is very close to plug/chug.