Just built SheetsCMS.com over a few hours of coding. Incredibly simple, but it works. Check it out and let me know if you’d like to deploy it on your own server.
Month: January 2016
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.