Exporting your API JSON data in a CSV file via a Google Spreadsheet

If you are an API developer working from time to time with data analysts, you might have already received a request along the lines of: “hey, would it be possible to export all of the data exposed in our API as a spreadsheet, so I could run some analysis on it” ?

Depending on how much time you had to work on this request, you could have done:

  1. a quick & dirty database export (which you would have then somehow converted to a csv file)
  2. a proper script to parse the JSON…