Google Sheets: List Worksheets
List all worksheet tabs in a Google Sheets spreadsheet. Returns each sheet's numeric ID, title, and index. Provide the full Google Sheets URL (spreadsheet ID is extracted automatically). Use this to discover available sheets before other Google Sheets actions.
Catalog action Integrations pipedream:google_sheets
List all worksheet tabs in a Google Sheets spreadsheet. Returns each sheet's numeric ID, title, and index. Provide the full Google Sheets URL (spreadsheet ID is extracted automatically). Use this to discover available sheets before other Google Sheets actions.
At a Glance
| Field | Value |
|---|---|
| Action ID | google-sheets-list-worksheets |
| Category | Integrations |
| Connector | pipedream:google_sheets |
| Requires gas | No |
| Funds movement | None declared |
| Tags | pipedream, integration, oauth, google-sheets, spreadsheet, read, data |
Payload Schema
| Field | Type | Required | Description |
|---|---|---|---|
url | string | Yes | Paste the full Google Sheets URL for the spreadsheet. |
Result Schema
| Field | Type | Required | Description |
|---|---|---|---|
success | boolean | Yes | Whether the worksheets were listed successfully |
data | object | No | Google Sheets API response data |
exports | object | No | Exported values from the action |
Examples
json{ "type": "google-sheets-list-worksheets", "payload": { "url": "https://docs.google.com/spreadsheets/d/your-spreadsheet-id/edit#gid=0" }, "children": [], "connector": { "type": "pipedream:google_sheets", "id": "conn_pipedream_google_sheets" }}
bashcurl -X POST "https://api.b3os.org/v1/actions/google-sheets-list-worksheets/test" \ -H "Authorization: Bearer YOUR_API_KEY" \ -H "Content-Type: application/json" \ -d '{ "inputs": { "url": "https://docs.google.com/spreadsheets/d/your-spreadsheet-id/edit#gid=0" }}'
Payload fields can use workflow expressions such as {{$trigger.body.amount}}, {{$nodes.fetch.result.price}}, and {{$props.asset}} when the value should come from a trigger, prior node, or reusable workflow prop.