← Connectors
Google Sheets
Own API only · OAuth · No webhooks
17tools · 13 write
Agents can call 17 tools for Google Sheets: 4 that read and 13 that write. They are Google Sheets's own API operations. Writes wait for a person to approve them.
Bring your own OAuth app. Register an OAuth client in Google Sheets's developer console and add its client ID and secret to the connector under Configuration. Setup steps
17 operations from the vendor's own spec, checked nightly by the API registry; last changed 31 Oct 2026. Source ↗
17 of 17 operations
| Operation | Method | Path | Kind |
|---|---|---|---|
| sheets.spreadsheets.get | GET | /v4/spreadsheets/{spreadsheetId} | read |
| sheets.spreadsheets.create | POST | /v4/spreadsheets | write |
| sheets.spreadsheets.batchUpdate | POST | /v4/spreadsheets/{spreadsheetId}:batchUpdate | write |
| sheets.spreadsheets.getByDataFilter | POST | /v4/spreadsheets/{spreadsheetId}:getByDataFilter | write |
| sheets.spreadsheets.sheets.copyTo | POST | /v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo | write |
| sheets.spreadsheets.developerMetadata.search | POST | /v4/spreadsheets/{spreadsheetId}/developerMetadata:search | write |
| sheets.spreadsheets.developerMetadata.get | GET | /v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId} | read |
| sheets.spreadsheets.values.batchUpdateByDataFilter | POST | /v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter | write |
| sheets.spreadsheets.values.batchUpdate | POST | /v4/spreadsheets/{spreadsheetId}/values:batchUpdate | write |
| sheets.spreadsheets.values.get | GET | /v4/spreadsheets/{spreadsheetId}/values/{range} | read |
| sheets.spreadsheets.values.clear | POST | /v4/spreadsheets/{spreadsheetId}/values/{range}:clear | write |
| sheets.spreadsheets.values.batchClearByDataFilter | POST | /v4/spreadsheets/{spreadsheetId}/values:batchClearByDataFilter | write |
| sheets.spreadsheets.values.batchGetByDataFilter | POST | /v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter | write |
| sheets.spreadsheets.values.append | POST | /v4/spreadsheets/{spreadsheetId}/values/{range}:append | write |
| sheets.spreadsheets.values.batchGet | GET | /v4/spreadsheets/{spreadsheetId}/values:batchGet | read |
| sheets.spreadsheets.values.batchClear | POST | /v4/spreadsheets/{spreadsheetId}/values:batchClear | write |
| sheets.spreadsheets.values.update | PUT | /v4/spreadsheets/{spreadsheetId}/values/{range} | write |