Action Google Sheets
Read Google Sheet
Reads data from a Google Sheets range using the Google Sheets API v4.
Node IDGoogleSheetsReadAction
Parameters
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Spreadsheet ID spreadsheet_id | string | Yes | — | The Google Sheets spreadsheet ID (found in the URL: https://docs.google.com/spreadsheets/d/{SPREADSHEET_ID}/edit) |
Range range | string | Yes | Sheet1!A1:Z100 | The A1 notation range to read (e.g., "Sheet1!A1:D10" or "MySheet!A:A") |
Access Token Secret Key access_token_secret_key | string | Yes | GOOGLE_SHEETS_ACCESS_TOKEN | The key in the Secrets store that holds your Google OAuth 2.0 access token. |
Inputs
| Input | Type | Required | Description |
|---|---|---|---|
Execute input0 | object | No | An execution signal to trigger the read operation. |
Outputs
| Output | Type | Identifier | Description |
|---|---|---|---|
Sheet Data output0 | object | sheet_data | The sheet data as an array of rows, where each row is an array of cell values. |