All posts
Blog

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