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.
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
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" }}
bashcurl -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" }}'
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.