Google Sheets

Google Sheets is a cloud-based spreadsheet application for organizing, calculating, analyzing, and collaborating on tabular data.

• Base URL: https://sheets.googleapis.com
• Auth: OAuth 2.0 (user-delegated) — attach an InTouch oauth credential. Mint one with itcli.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 spreadsheet
• sheets_spreadsheets_developermetadata_get — GET /v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId} — Returns the developer metadata with the specified ID. The caller must specify th
• sheets_spreadsheets_values_get — GET /v4/spreadsheets/{spreadsheetId}/values/{range} — Returns a range of values from a spreadsheet. The caller must specify the spread
• sheets_spreadsheets_values_batchget — GET /v4/spreadsheets/{spreadsheetId}/values:batchGet — Returns one or more ranges of values from a spreadsheet. The caller must specify
• sheets_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 oauth credential (no key inputs) — the server injects a fresh Authorization: Bearer from it
• operation — one of the operations above
• path parameters when an operation's path contains {...}
• query — optional JSON object of query params
• body — JSON object for create/update ops

Example

operation: sheets_spreadsheets_get
# (attach an 'oauth' credential to the task — no inline secrets)

Publishes

The keys a later task may reference as {{taskName.key}}. Referencing anything not listed here resolves to nothing at run time.

• error
• operation
• result
• status

Input Properties

Every property this tool accepts, from its own tool.iml.