Action Google Sheets
Write to Google Sheet
Writes data to a Google Sheets range, overwriting existing values.
Node IDGoogleSheetsWriteAction
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!A1 | The starting cell in A1 notation (e.g., "Sheet1!A1"). Data will be written from this cell. |
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/cells to write). |
Outputs
| Output | Type | Identifier | Description |
|---|---|---|---|
Write Result output0 | object | write_result | Contains updated range, cells updated count, and spreadsheet ID. |