Product overview

JSONSheets is a lightweight API layer that makes Google Sheets behave like a small JSON database. It wraps the official Google Sheets API and exposes four main operations: read, append, update, and delete rows.

Core ideas

• Use Sheets as a simple backend for prototypes and tools.
• Keep your data in your own Google account.
• Avoid Apps Script complexity while still using the same spreadsheet.

Endpoints

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

Each tab in your spreadsheet becomes a logical table. The first row is treated as headers and mapped to JSON keys automatically.