Googleapis Sheets
Connector for the googleapis-sheets API, generated deterministically from its OpenAPI spec (endpoints, auth, and methods match the spec exactly — nothing is invented).
- Base URL:
https://sheets.googleapis.com - Auth: OAuth 2.0 (user-delegated) — attach an InTouch
oauthcredential. Mint one withitcli.py /oauth <provider>(device-code) or/google-auth(Google); the server auto-refreshes the access token before each run, so the connector never handles or stores tokens.
Operations
sheets_spreadsheets_get— GET /v4/spreadsheets/{spreadsheetId} — Returns the spreadsheet at the given ID. The caller must specify the spreadsheetsheets_spreadsheets_developermetadata_get— GET /v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId} — Returns the developer metadata with the specified ID. The caller must specify thsheets_spreadsheets_values_get— GET /v4/spreadsheets/{spreadsheetId}/values/{range} — Returns a range of values from a spreadsheet. The caller must specify the spreadsheets_spreadsheets_values_batchget— GET /v4/spreadsheets/{spreadsheetId}/values:batchGet — Returns one or more ranges of values from a spreadsheet. The caller must specifysheets_spreadsheets_create— POST /v4/spreadsheets — Creates a spreadsheet, returning the newly created spreadsheet.sheets_spreadsheets_developermetadata_search— POST /v4/spreadsheets/{spreadsheetId}/developerMetadata:search — Returns all developer metadata matching the specified DataFilter. If the provide
Inputs
- a linked
oauthcredential (no key inputs) — the server injects a freshAuthorization: Bearerfrom it operation— one of the operations above- path parameters when an operation's path contains
{...} query— optional JSON object of query paramsbody— JSON object for create/update ops
Example
operation: sheets_spreadsheets_get
# (attach an 'oauth' credential to the task — no inline secrets)