Append Values to Range

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

New order
  → Build [Order ID, Customer, Total] row
  → Google Sheets: Append Values to Range (Orders!A:C)
  → Store Updated Range

Create Range from PartsBuild Google Sheets A1 notation from row and column components.

Overview

Fundamentals

Web, Files & Data

AI

Scraping & Rendering

Google Workspace

Email, CRM & Scheduling

Databases & Tables

Microsoft

Inputs

Outputs

Example

​Inputs

​Outputs

​Example

Inputs

Outputs

Example