Append rows
append_rowsAdd rows after the last occupied row of a table to insert new data without altering existing entries.
Instructions
Adds rows after the last occupied row of the given table. This is the safe way to insert new data without touching what is already there.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | Tab or range identifying the table, e.g. 'Sheet1' or 'Sheet1!A:D'. | |
| values | Yes | Rows to append. | |
| spreadsheetId | Yes | Spreadsheet ID, or its full URL. The ID is the segment between /d/ and /edit in the URL. | |
| valueInputOption | No | USER_ENTERED parses values as if typed by hand (formulas, dates, numbers). RAW stores them literally as strings. | USER_ENTERED |