Quickly turn Google Sheets into a public, CDN-backed JSON endpoint.
(service account email)
GET /sheetId/sheetName.json— Returns the sheet data as JSON (example)
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.