Javascript snippet to download a multi-sheets-Google-Spreadsheet in JSON

Would you like to download your multi-sheets-Google-spreadsheet in a simple format like this?

Follow these steps:

1. Publish your Google spreadsheet first. Click on Publish to the web…

2. Click the Publish button…

3. Copy the ID…

You can now copy the Spreadsheet from the address bar

4. Paste the ID into this code…

5. Save also this snippet…

6. Run

$ node downloadTest.js

et voilà, the script will output a simplified version of your spreadsheet in JSON.

Note that the Spreadsheet that I use for the example is made of 3 sheets. The snippet will automatically generate 4 JSON requests.

This is the spreadsheet that I used in the example

Test Google Spreadsheet for Javascript

“Stair of the Turks” in Sicily — Italy