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.