Google Sheets Backend

Turn Google Sheets into a REST API

Transform your Google Sheets into a powerful backend with just a few clicks.

Getting Started

1. Share Your Sheet

Share your Google Sheet with our service account email

google-sheets-backend@personal-310102.iam.gserviceaccount.com
2. Make API Calls

Start making REST API calls to your Google Sheet data.

API Documentation

GET Data
curl -X GET "https://google-sheets-backend.canine.sh/sheet/{your-sheet-id}/{your-sheet-name}"
Response:
{
  "data": [
    {"id": 1, "name": "John", "age": "30"},
    {"id": 2, "name": "Jane", "age": "25"}
  ]
}
Create New Row
curl -X POST "https://google-sheets-backend.canine.sh/sheet/{your-sheet-id}/{your-sheet-name}" \
-H "Content-Type: application/json" \
-d '{"name": "Bob", "age": "35"}'
Response:
{
  "id": 3,
  "name": "Bob",
  "age": "35"
}
Update Row
curl -X PUT "https://google-sheets-backend.canine.sh/sheet/{your-sheet-id}/{your-sheet-name}/1" \
-H "Content-Type: application/json" \
-d '{"name": "Johnny", "age": "31"}'
Response:
{
  "id": 1,
  "name": "Johnny",
  "age": "31"
}
Delete Row
curl -X DELETE "https://google-sheets-backend.canine.sh/sheet/{your-sheet-id}/{your-sheet-name}/1"
Response:
{
  "id": 1,
  "name": "Johnny",
  "age": "31"
}