append_rows
Add new rows below existing data in a Google Sheet by specifying a range and values, with options for raw input or formula evaluation.
Instructions
Append rows after the last row of data within/near the given A1 range.
The range selects the table to append to (e.g. Sheet1!A1 or
Sheet1!A:D); new rows are added below the existing data.
value_input_option: RAW (verbatim strings; default) or
USER_ENTERED (evaluate formulas/dates/numbers — opt in explicitly).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | ||
| values | Yes | ||
| spreadsheet_id | Yes | ||
| value_input_option | No | RAW |