in Learnings

You don’t need od6 when working with Google Sheets JSON

When figuring out how to extract Google Sheets data as JSON, the top result on Google explains that you can access the JSON like this:

https://spreadsheets.google.com/feeds/list/SPREADSHEET-ID/od6/public/basic?alt=json

In this URL od6 represents the first sheet in the book/spreadsheet. Someone said that other sheets are represented by od8, od10 and so on, but that didn’t work with me. So dug around the comments on different posts and here’s the answer: simply use numbers instead of od6.

So the URL for your first sheet becomes:

https://spreadsheets.google.com/feeds/list/SPREADSHEET-ID/1/public/basic?alt=json

and the second sheet will be:

https://spreadsheets.google.com/feeds/list/SPREADSHEET-ID/2/public/basic?alt=json

And so on.

Write a Comment

Comment

9 + 1 =

CommentLuv badge