3 Answers
3

After playing around with the API (and banging my head against the monitor), I found out that in order to retrieve data in JSON format from a public spreadsheet you actually have to go through a second process called "Publish to the web" in the Spreadsheets GUI.

What's the reason for this? I haven't found out yet, but judging by the error messages I was getting, I will call it "A BUG".

On a side note, thanks to the people that took the time to reply/edit my question