Append or Update Rows
Update rows matched by a column value; append the rest (upsert).
Overview
Append or Update Rows is a no-code automation step in the Google Sheets category of AutoFlowRPA. It performs its action in a single step when the workflow reaches it. You can configure 6 parameter(s) to control exactly how it behaves. It is one of 369 commands you can drag into a workflow in the visual builder — no scripting required.
What it does
Update rows matched by a column value; append the rest (upsert).
Parameters
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
| Connection name | variable | Required | sheets | Name of the connection created by Authorize. |
| Spreadsheet (ID or URL) | string | Required | Spreadsheet ID, or paste the full Sheets URL. Example: 1AbC...xyz Supports variables | |
| Sheet/tab name | string | Required | Sheet1 | Example: Sheet1 Supports variables |
| Column to match on | string | Required | Example: id Supports variables | |
| Data (DataTable / list) | variable | Required | Example: rows | |
| Value input | dropdownUSER_ENTERED · RAW | Optional | USER_ENTERED | USER_ENTERED parses numbers/dates/formulas; RAW stores literally. |
How to use Append or Update Rows
- 1
Open AutoFlowRPA and drag the Append or Update Rows command from the Google Sheets group onto the canvas.
- 2
Set its parameters in the side panel — Append or Update Rows has 6 configurable field(s).
- 3
Connect it into your workflow and press Run. Everything executes locally on your machine.
Frequently asked questions
What does the Append or Update Rows command do?
Update rows matched by a column value; append the rest (upsert).
Which group does the Append or Update Rows command belong to?
Append or Update Rows is part of the Google Sheets group. AutoFlowRPA ships with 369+ ready-made commands you can combine without code.
Does the Append or Update Rows command take any parameters?
Yes — Append or Update Rows has 6 configurable field(s), all editable in the visual node editor.
More Google Sheets commands
Ready to automate your busywork?
Start your free 30-day trial today. No credit card, no commitment.