Get JSON feed from published Google sheet

Question

I have thorougly researched this, found many answers on this site, but just can't get it to work. I must be missing something.

I have the following public sheet: https://docs.google.com/spreadsheets/d/11CwVCfIiJHlC-PhaT_hD8aB1q77VwecCgOuwzyuwZkY/edit?usp=sharing I paste in my key https://spreadsheets.google.com/feeds/list/11CwVCfIiJHlC-PhaT_hD8aB1q77VwecCgOuwzyuwZkY/od6/public/values?alt=json

Get an error that the document is not published.

Answer 1

As agershun already pointed out, you need to publish the document. Follow these steps:

1) File menu > Publish to the web...

2) Click the Start Publishing button

3) Load your URL and you'll see it in JSON

Note: Here is my working example, the URL formed exactly like yours, except this one is published: https://spreadsheets.google.com/feeds/list/1qym45VIwM4ruaWDkqndaOBzgOMAhOsjZ7rL76wJrTkY/od6/public/values?alt=json

If after you've done all this and you receive the error Invalid query parameter value for grid_id. then refer to this post for a solution: Retrieve Google Spreadsheet Worksheet JSON