Append Values
Appends rows after a Google Sheets A1 range.
Type
google.sheets.append_valuesFolder
google/sheetsChannels
Any
Pipe
Value
Scope
Any
ServiceRequired
CapabilityRequired
Google Sheets
Listed only when a matching connected service is enabled.
Append Values Appends rows after a Google Sheets A1 range.
Configure
| Setting | Description |
|---|---|
| Spreadsheet ID | Spreadsheet id |
| Range | Table to append after, e.g. Sheet1!A:Z. You can insert variables, e.g. {{ tab }}!A:Z |
| Values | JSON 2D array. Liquid is rendered first |
| Value input | User entered (default) or raw |
| Insert data | Insert rows (default) or overwrite |
Pipe schema
| Key | Type | Description |
| --- | --- |
| spreadsheetId | text | Spreadsheet id |
| updatedRange | text | Range written |
| updatedRows | number | Rows written |
| values | list | Values sent |