Google Sheets — Append rows
Google Sheets — Append rows
Section titled “Google Sheets — Append rows”Type: googlesheets-append · Package: Google Sheets Activities v1.0.0
Adds rows to the end of existing data, without overwriting. Ideal for accumulating records in a shared sheet over time: a log, a log, growing results.
How it works
Section titled “How it works”Detects the last data in the indicated range (the entire sheet by default) and writes the values below. Accepts a DataTable (or a DataRow for a single row). Requires a Google Sheets — Open session.
Required parameters
Section titled “Required parameters”| Parameter | Editor | Description |
|---|---|---|
values | expression | The DataTable to add (or a DataRow for a single row). |
Optional parameters
Section titled “Optional parameters”| Parameter | Editor | Description |
|---|---|---|
session | session | Google Sheets — Open session. Optional: within a body it is inherited. |
sheet | expression | Sheet where to add. |
range | expression | Range where to search for the latest data. By default, the entire sheet. |
Example
Section titled “Example”Record the result of each execution on a sheet:
Google Sheets — Append rows session = = hoja sheet = "Bitácora" values = = arr(arr(now().ToString("yyyy-MM-dd HH:mm"), proceso, "OK"))Related activities
Section titled “Related activities”- Write sheet — write from A1 (overwrites).
- Write range — write at a fixed position.