Google Docs Spreadsheet to JSON
google-sheets, google-sheets-api, javascript, json
Solution
The `src` attribute in your `script` tag is an invalid link (and you can see this for yourself by viewing your link directly in a browser).
The `feed/key/worksheet` section of the URL has the right `key` but the wrong `feed` and `worksheet`.
In the URL, replace "`feed`" with either "`cells`" (separate value for each cell) or "`list`" (separate value for each row).
At the same time, replace "`worksheet`" with "`od6`" (indicating the leftmost, or default, sheet - see this blog post for accessing other sheets).
If you view this new URL directly in a browser, you can see that it returns a meaningful value.
Your final script tag might look like this:
<script src="https://spreadsheets.google.com/feeds/list/1SKI5773_68HiSve1fsz7fr4gotjFWHB7KBuVsOlLz6I/od6/public/values?alt=json-in-script&callback=importGSS"></script>
For more info, you can see an example on the Google Developers site
Problem
I've seen numerous articles on this but they seem outdated, for instance none of the Google Docs Spreadsheet urls has key parameter. I read this as well: JSON data from google spreadsheet Then I read this to access data https://developers.google.com/gdata/samples/spreadsheet_sample My spreadsheet exists at: https://docs.google.com/spreadsheets/d/1SKI5773_68HiSve1fsz7fr4gotjFWHB7KBuVsOlLz6I/edit#gid=0 I've tried using this code, I think I have a problem with the key or syntax, please guide to fix. ``` <script src="http://spreadsheets.google.com/feeds/feed/1SKI5773_68HiSve1fsz7fr4gotjFWHB7KBuVsOlLz6I/worksheet/public/basic?alt=json-in-script&callback=importGSS"></script> <script type="text/javascript"> function importGSS(json) { console.log('finished'); } </script> ```