Append Rows

Append rows, mapping DataTable columns onto the sheet header (writes a header first if the sheet is empty).

Google SheetsGoogleSheetsAppendRows

What it does

Append rows, mapping DataTable columns onto the sheet header (writes a header first if the sheet is empty).

Parameters

ParameterTypeRequiredDefaultDescription
Connection namevariable
RequiredsheetsName of the connection created by Authorize.
Spreadsheet (ID or URL)string
RequiredSpreadsheet ID, or paste the full Sheets URL.
Example: 1AbC...xyz
Supports variables
Sheet/tab namestring
RequiredSheet1
Example: Sheet1
Supports variables
Data (DataTable / list)variable
Required
Example: rows
Value inputdropdown
USER_ENTERED · RAW
OptionalUSER_ENTEREDUSER_ENTERED parses numbers/dates/formulas; RAW stores literally.

More Google Sheets commands

Ready to automate your busywork?

Start your free 10-day trial today. No credit card, no commitment.