Productivity & Dataspreadsheetgoogleautomationdata
Google Sheets API
The Google Sheets API reads and writes spreadsheet data programmatically – useful for reporting, lightweight databases and content pipelines.
- Provider
- Pricing
- Free with Google Cloud quotas; see Google Cloud pricing
- Authentication
- OAuth 2.0 or service account
- API key
- Required
Get started
Start building with Google
Create an account, get your API key and start integrating Google Sheets API.
Technical details
- Endpoint
https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}- Authentication
- OAuth 2.0 or service account
- Rate limit
- Per-project quotas in Google Cloud
- SDKs
- PythonJavaScriptJava
- Documentation
- Open official docs
Details
- Features
- Read and write cell rangesBatch updatesFormatting and chartsOAuth 2.0 access control
- Use case
- Reporting dashboards, content calendars and lightweight data stores