> ## 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: Get Values

Retrieve values from a specific range in a Google Sheet. Provide the full Google Sheets URL (spreadsheet ID and sheet tab are extracted automatically from the URL). Use A1 notation for the range without sheet name prefix (e.g., 'A1:D10', 'A:E'). Ideal for: reading configuration data, fetching lookup tables, getting historical data.

![Google Sheets: Get Values logo](https://ai-icon.b3.fun/logo/google-sheets)
Catalog action Integrations pipedream:google_sheets

Retrieve values from a specific range in a Google Sheet. Provide the full Google Sheets URL (spreadsheet ID and sheet tab are extracted automatically from the URL). Use A1 notation for the range without sheet name prefix (e.g., 'A1:D10', 'A:E'). Ideal for: reading configuration data, fetching lookup tables, getting historical data.


## At a Glance

| Field | Value |
| --- | --- |
| Action ID | `google-sheets-get-values` |
| Category | Integrations |
| Connector | `pipedream:google_sheets` |
| Requires gas | No |
| Funds movement | None declared |
| Tags | `pipedream`, `integration`, `oauth`, `google-sheets`, `spreadsheet`, `read`, `data`, `fetch`, `lookup`, `query` |

## Payload Schema

| Field | Type | Required | Description |
| --- | --- | --- | --- |
| `url` | `string` | Yes | Paste the full Google Sheets URL, including the worksheet tab. |
| `range` | `string` | Yes | The A1 notation cell range WITHOUT a sheet name prefix. Examples: 'A1:D10', 'A:E', 'A1:Z100'. Do NOT include sheet name \(e.g., use 'A1:D10', not 'Sheet1!A1:D10'\). |

## Result Schema

| Field | Type | Required | Description |
| --- | --- | --- | --- |
| `success` | `boolean` | Yes | Whether the values were retrieved successfully |
| `data` | `object` | No | Google Sheets API response data |
| `exports` | `object` | No | Exported values from the action |

## Examples

**Workflow node**

```json
{
  "type": "google-sheets-get-values",
  "payload": {
    "url": "https://docs.google.com/spreadsheets/d/your-spreadsheet-id/edit#gid=0",
    "range": "example-range"
  },
  "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-get-values/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",
    "range": "example-range"
  }
}'
```

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