Append Values to Range - Learn WorkflowDog

The Append Values to Range action adds rows after the existing data found within an A1 range. Google inserts rows and treats values as user-entered input.

Inputs

Input	Type	Required	Description
Third-party account	Google account	Yes	Account with write access.
Spreadsheet ID or URL	String	Yes	Spreadsheet to update.
Range	String	Yes	A1 table range, such as `Sheet1!A:B`.
Rows	List of lists	Yes	Rows of string or numeric cell values to append.

Outputs

Output	Type	Description
Updated Range	String	A1 range occupied by the newly appended rows.

Appended rows take on the table’s existing formatting behavior. The range tells Google where to detect the table; it is not necessarily the exact output range.

Example

For each new order, build a row containing the order ID, customer, and total, then append it to Orders!A:C. Store Updated Range if later actions need to locate the cells that were added.