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.