Lightweight JSON API on top of Google Sheets

Turn Google Sheets into a secure, low-latency JSON API.

JSONSheets gives you clean REST endpoints for reading, appending, updating and deleting rows — without touching Apps Script or managing a separate database.

View API Docs Get started in minutes

Low latency: No Apps Script cold starts. A thin Node layer talks directly to the Sheets API.
Safe by default: Validated payloads and rate-limiting so you can safely expose endpoints.
Sheets-first: Spreadsheets stay your source of truth. JSONSheets just adds a clean interface.

live democurl

GET  /api/sheets/{spreadsheetId}/{tabName}
POST /api/sheets/{spreadsheetId}/{tabName}
PUT  /api/sheets/{spreadsheetId}/{tabName}
DELETE /api/sheets/{spreadsheetId}/{tabName}

curl https://api.jsonsheets.nishilvisawadia.com/api/sheets/XXX/Users

# → [
#   { "Name": "Alice", "Email": "a@example.com" },
#   { "Name": "Bob",   "Email": "bob@example.com" }
# ]

Built for fast, safe, small backends

Reliable & predictable

Stateless Node service with a health endpoint and structured JSON errors. Easy to monitor and deploy on any small host.

Security-first

Input validation and rate-limiting out of the box. You decide which spreadsheets and tabs to expose.

Low latency

Avoid Apps Script cold starts. JSONSheets is a thin proxy over the official Sheets API, tuned for quick responses.

JSONSheets vs Google Apps Script

Aspect	JSONSheets	Google Apps Script
Latency	Consistent responses, no script container cold starts.	Can feel slow due to script startup time and quotas.
Deployment	Standard Node service. Works on Vercel, Railway, Render, VPS or containers.	Tied to the Apps Script editor and Google's script runtime.
API design	Clean REST endpoints that always return JSON.	Requires custom web app boilerplate to behave like an API.
Complexity	One responsibility: treat sheets as JSON tables.	Full scripting environment; easy to overcomplicate.