Google Sheets
API to read, write, and format Google Sheets data
- Authentication
- OAuth
- HTTPS
- Yes
- CORS
- Unknown
- Category
- Development
- 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 | ↗ |
| Agify.io Estimates the age from a first name | No auth | Yes | Yes | ↗ |
| Amazonscraperapi Amazon product, search & batch scraping API with residential proxies (1000 free) | API Key | Yes | No | ↗ |
| AmberOne Turn any website into a build-ready Android, iOS, PWA or Electron app project | API Key | Yes | No | ↗ |
| API Grátis Multiples services and public APIs | No auth | Yes | Unknown | ↗ |