📑 GSheet Rest API

Effortless REST API for your Google Sheet. Instantly turn your Google Sheet into a powerful API.

• Home: gsheet-rest-api.vercel.app
• API Doc: gsheet-rest-api.vercel.app/docs
• Example App: gsheet-rest-api.vercel.app/example

Setup access

• Enable Google Sheets API + Google Drive API in your Cloud Console
• Create new service account
• Add new keys in your service account
  • Download the JSON file, and put it in the .env.local. Read this article
• Grant your service account access to the speadsheet
  • Share the spreadsheet
  • Add people with email from your service account
  • Click "Copy link" button to get the spreadsheetid (e.g: If the link is https://docs.google.com/spreadsheets/d/1-Qi5_aizQiNTMRBuqboory9Ba7lyonxCjDCogASdVdg/edit?usp=sharing then the ID is 1-Qi5_aizQiNTMRBuqboory9Ba7lyonxCjDCogASdVdg)

Development

• Install dependencies

bun install

• Run project

bun run dev

Deploy on Vercel

Add environment variable GOOGLE_CREDENTIALS with your JSON from service account key.

Limitations and Quota

Following Google Sheets API documentation. This version of the Google Sheets API has a limit of 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user. Limits for reads and writes are tracked separately. There is no daily usage limit.

Be mindful about this limitation, if you want to use this api as a backend for your frontend!

Credits

• melalj/gsheet-api
• openais-io/sheepdb

---

ⓒ since 2025, By Irfan Maulana