Skip to content

Instantly share code, notes, and snippets.

@wdzajicek

wdzajicek/Google Sheets JSON URL

Created January 9, 2019 17:31
Download ZIP

Revisions

  1. wdzajicek created this gist Jan 9, 2019.
    22 changes: 22 additions & 0 deletions Google Sheets JSON URL
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,22 @@
    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