sheets_append_values
Append rows to a Google Sheets table after the last row of existing data, preventing overwrites. Provide spreadsheet ID, range, and 2D values to add rows and return the updated range.
Instructions
Append rows after the last row of existing data in a table/range.
Unlike sheets_write_range, this never overwrites existing rows — the Sheets API finds the end of the data and inserts after it.
Returns:
str: JSON with updated_range describing where the new rows landed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |