Turn a Google Sheet into a REST API in 30 seconds with GKit
A step-by-step guide to turning any Google Sheet into a full CRUD REST API using GKit SheetsAPI — no backend, no Apps Script, no plan limits.
From spreadsheet to API in three clicks
Spreadsheets are the world's most popular database. GKit SheetsAPI makes them act like one — exposing any Google Sheet as a REST API your app can read and write, instantly.
Here's the entire flow.
1. Connect your Google account
Visit GKit and sign in with Google. GKit requests only the Sheets scope it needs. Your tokens are encrypted at rest.
2. Paste your sheet URL
Drop in a Google Sheets URL. GKit reads the first row of each tab as your JSON field names — so a sheet with name, email, plan columns becomes objects with exactly those keys.
3. Call your endpoints
You immediately get standard REST endpoints:
# Read all rows
curl https://sheetsapi.gkit.mreshank.com/api/spreadsheets/{userKey}/Contacts
# Create a row
curl -X POST https://sheetsapi.gkit.mreshank.com/api/spreadsheets/{userKey}/Contacts \
-H "Content-Type: application/json" \
-d '{"name":"Ada","email":"ada@example.com","plan":"pro"}'CRUD just works. CORS is enabled, so you can call it straight from the browser.
Why not Apps Script?
You could write Apps Script by hand — but you'd own the auth, the deployment, the rate limiting, the CORS headers, and the maintenance. GKit SheetsAPI handles all of that and stays free while in beta.
Where to go next
- Read the SheetsAPI quickstart
- See how it compares to SheetDB
- Explore use cases like form backends and no-code apps