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:

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:

and the second sheet will be:

And so on.

Write a Comment


27 − = 23

CommentLuv badge

  1. You sir, are the best. Just spent a bunch of hours trying to figure this one out, even went and got API credentials, because this was literally driving me nuts.