> ## Documentation Index
> Fetch the complete documentation index at: https://docs.b3os.org/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.

![Google Sheets: List Worksheets logo](https://ai-icon.b3.fun/logo/google-sheets)
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

**Workflow node**

```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"
  }
}
```
  **Test with API**

```bash
curl -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"
  }
}'
```

**Use expressions for dynamic values**

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.