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.

About Shashank Mehta:

Heading product for RazorpayX, building the future of business banking. Early bird (#7) at @Razorpay. Forever hoarse throat thanks to ManUtd.

Follow me on twitter. I don't tweet a lot though. Bummer, right?