Deploy a single Apps Script and turn any Google Sheet into a powerful, queryable REST API. Full CRUD, filtering, sorting, and schema management — no servers, no setup fees.
Features
SheetsDB gives you the power of SQL-like operations on top of Google Sheets — without the complexity.
Filter with WHERE clauses, sort ascending or descending, paginate with LIMIT and OFFSET, and select only the columns you need.
Create and drop tables, add or remove columns, rename tables and columns, and change column types — all via API calls.
Your data lives in Google Sheets. Inspect it directly, share it with your team, and edit rows manually whenever you need to.
API
One POST request. One JSON response. That's it.
// Query users older than 18, sorted by age descending const res = await fetch('https://script.google.com/macros/s/.../exec', { method: 'POST', body: JSON.stringify({ operation: 'select', table: 'users', where: 'age>18', sort: '-age', limit: 50 }) }) const data = await res.json() // → [{ name: "Alice", age: 32 }, { name: "Bob", age: 25 }, ...]
Get Started
No servers, no billing, no DevOps. Just Google Sheets and one script.
Open Apps Script from your Google Sheet, paste the script, and hit Deploy. You get a URL in seconds.
Configure a password in the script properties. Every API call includes this key — only you can access your data.
Send POST requests from your app, your CLI, or anywhere. Create tables, insert rows, run queries — your sheet is now a database.
Open source. No quotas. No vendor lock-in. Your data stays in your Google Sheets, and you stay in control.