Fetching Google Spreadsheet in JSON

Recently I was working on using data from a Google Drive spreadsheet in a Hubot script. I needed to fetch the sheet in JSON format in order to easily parse it using coffeescript. But it turned out that Google doesn’t provide an easy way of getting this done. Here’s the indirect method:

Since this option doesn’t exist in the dropdown it may not be supported by Google in the future. Safer solution would be to output to csv and convert it to json.

Some boring lines about the writer:

Interested in products and UX. Knows a bit of PHP, JS, Node. Prefers JS. HN addict. Watches football, plays squash. ManUtd & Spain \m/. Tinkers with arduino sometimes.

Will code for food, MacBook, fast internet, noise cancelling headphones, a comfortable chair and desk. Pretty basic needs. Truly.

Follow him on twitter. He doesn't tweet a lot. Bummer, right?