Skip to content

Instantly share code, notes, and snippets.

@wdzajicek

wdzajicek/Google Sheets JSON URL

Created January 9, 2019 17:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wdzajicek/adb05f2b35e82078b979bd3977cee4ed to your computer and use it in GitHub Desktop.
Save wdzajicek/adb05f2b35e82078b979bd3977cee4ed to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Google Sheets JSON URL
Spreadsheet must be "Published" to view the JSON feed:
Go to "File" > "Publish to web..." to publish
https://spreadsheets.google.com/feeds/list/<SPREADSHEETID#>/od6/public/basic?alt=json
Where <SPREADSHEETID#> is the unique spreadsheet ID like: 1zBMYYFRJLLgUu9XKR8voz37o5Nz1dMVAdfy3cj3W_PI
Example:
This link goes to the first sheet in the workbook with the above ID
https://spreadsheets.google.com/feeds/list/1zBMYYFRJLLgUu9XKR8voz37o5Nz1dMVAdfy3cj3W_PI/od6/public/basic?alt=json
Substitute "od6" for the sheet's # to get a specific sheet in a multi-sheet workbook:
https://spreadsheets.google.com/feeds/list/<SPREADSHEETID#>/<SPREADSHEET#>/public/basic?alt=json
Where <SPREADSHEET#> is the number corresponing to the individual sheets of a workbook
Example
First sheet:
https://spreadsheets.google.com/feeds/list/1zBMYYFRJLLgUu9XKR8voz37o5Nz1dMVAdfy3cj3W_PI/1/public/basic?alt=json
Second sheet:
https://spreadsheets.google.com/feeds/list/1zBMYYFRJLLgUu9XKR8voz37o5Nz1dMVAdfy3cj3W_PI/2/public/basic?alt=json
Third sheet:
https://spreadsheets.google.com/feeds/list/1zBMYYFRJLLgUu9XKR8voz37o5Nz1dMVAdfy3cj3W_PI/2/public/basic?alt=json
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment