Action Google Sheets
Append to Google Sheet
Appends new rows to the end of a Google Sheet.
Node IDGoogleSheetsAppendAction
Parameters
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Spreadsheet ID spreadsheet_id | string | Yes | — | The Google Sheets spreadsheet ID (found in the URL). |
Range range | string | Yes | Sheet1 | The sheet name or range to append to (e.g., "Sheet1" or "Sheet1!A:D"). Data appends after the last row. |
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. |
Value Input Option value_input_option | enum | Yes | USER_ENTERED | How values should be interpreted. RAW = exactly as entered. USER_ENTERED = parsed as if typed in UI (formulas, dates, etc). |
Inputs
| Input | Type | Required | Description |
|---|---|---|---|
Execute input0 | object | Yes | Execution signal. The 'value' field should contain a 'values' array (2D array of rows to append). |
Outputs
| Output | Type | Identifier | Description |
|---|---|---|---|
Append Result output0 | object | append_result | Contains updated range, cells updated, rows appended, and spreadsheet ID. |