Skip to content

Google Sheets JSON Access

Reading a public Google Sheet as JSON over HTTP, without an API key.

1 min read

The Sheet should be public and Anyone with link can view. Example:

https://docs.google.com/spreadsheets/d/{spreadsheetId}/edit?usp=sharing

If you dont want to create a key you can use this URL format (which downloads a json.txt file of the format):

Or configure a key as per the Official docs.

  1. Go to Google Console and create a project (or use an existing one)
  2. Goto Credenetials page and create a API Key
  3. Include Sheets API from library

You can now get json using URL Format:

With the V4 pattern, the spreadsheet needs to be shared as File > Share > Share with others > anyone with the link can view.

https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{sheetName}?alt=json&key={theKey}

Related articles

1 min read

gRPC

What gRPC is, why choose it over REST, and its four API types.

  • APIs & Integration
  • Architecture & Process
2 min read

Strava

Uploading GPS tracks to Strava from the command line using the Strava API.

  • APIs & Integration
2 min read

JSON Web Tokens - jwt

How JSON Web Token authentication works, step by step.

  • Security
  • APIs & Integration

Type to search the whole site.