Update Values
Overwrites cell values in a Google Sheets A1 range.
Type
google.sheets.update_valuesFolder
google/sheetsChannels
Any
Pipe
Value
Scope
Any
ServiceRequired
CapabilityRequired
Google Sheets
Listed only when a matching connected service is enabled.
Update Values Overwrites cell values in a Google Sheets A1 range.
Configure
| Setting | Description |
|---|---|
| Spreadsheet ID | Spreadsheet id |
| Range | A1 range to write. You can insert variables, e.g. Sheet1!A1:C{{ lastRow }} |
| Values | JSON 2D array. Liquid is rendered first |
| Value input | User entered (default) or raw |
Pipe schema
| Key | Type | Description |
| --- | --- |
| spreadsheetId | text | Spreadsheet id |
| updatedRange | text | Range written |
| updatedRows | number | Rows written |
| updatedColumns | number | Columns written |
| values | list | Values sent |