Google Sheets
API to read, write, and format Google Sheets data
- Authentication
- OAuth
- HTTPS
- Yes
- CORS
- Unknown
- Category
- Development
- Data source
- public-apis + marcelscruz
- Documentation / URL
- https://developers.google.com/sheets/api/reference/rest
Overview
Google Sheets provides spreadsheet APIs — OAuth/API-key based (anonymous calls are refused 403, verified).
Quick Start
Values (needs auth):
curl "https://sheets.googleapis.com/v4/spreadsheets/1/values/A1" \
-H "Authorization: Bearer YOUR_TOKEN"{ "error": { "code": 403, "message": "Method doesn't allow unregistered callers... use API Key or OAuth" } }Authentication
- Google Cloud project → API key or OAuth 2.0 credentials.
- Send as
Authorization: Bearer(anonymous → 403, verified).
Rate Limits & Notes
- Free with limits (check the docs).
- Spreadsheets.
FAQ
Is Google Sheets free? Yes — free with auth.
Why 403? Anonymous calls are refused (verified) — use API key/OAuth.
What’s the auth style? OAuth 2.0 / API key.
More in Development
| API | Auth | HTTPS | CORS | |
|---|---|---|---|---|
| 24 Pull Requests Project to promote open source collaboration during December | No auth | Yes | Yes | ↗ |
| Abacus Free and simple counting service. You can use it to track page hits and specific events | No auth | Yes | Unknown | ↗ |
| Agent Gateway 34+ AI agent infrastructure services including memory, wallets, and scheduling | API Key | Yes | Unknown | ↗ |
| AgentDeals Search and compare developer free tiers, startup credits, and pricing changes | No auth | Yes | Unknown | ↗ |
| Agify.io Estimates the age from a first name | No auth | Yes | Yes | ↗ |