Google Spreadsheets retrieving JSON feed Google Spreadsheets retrieving JSON feed json json

Google Spreadsheets retrieving JSON feed


The format you should use is this :

https://spreadsheets.google.com/feeds/cells/SHEET-IDENTIFIER/SHEET_INDEX/public/basic?alt=json-in-script&callback=JSON_CALLBACK

You can find SHEET_INDEX by looking at the end of the URL while editing the sheet.

...SHEET-IDENTIFIER/edit#gid=SHEET_INDEX

Make sure the spreadsheet is published (not only shared).
File/Pulish to the web...


I tried Vlad's answer and it didn't work; the editing url had gid=0, but in order to get the feed I wanted I had to put in 1 as the sheet index.