sheet.spacet.me

Quickly turn Google Sheets into a public, CDN-backed JSON endpoint.

Usage

Make the sheet accessible to this service by doing any of these:
- Share the sheet with (service account email)
- Make the sheet viewable by anyone with the link.
Use the API (see below).

Google Sheet URL:

Sheet name:

Endpoint URL:

Code generator

Data fetching method:

Post-processing:

→

Code:

Did you know? The above templates are defined in this config spreadsheet.

The endpoint is CORS-enabled and is backed by two layers of CDN caching (Cloudflare and Vercel Edge Network), so client-side applications can fetch data directly from this service without worrying about Google Sheets API rate limit. Due to our caching strategy, the sheet contents may be delayed by about 1 minute (subject to change).
I made this API mainly for my own convenience. While you are welcome to use it, there is no support nor uptime guarantee. But this project is open source, and you can run your own instance. Source code is on GitHub.

API built by @dtinth.