append_rows
Add new rows to the end of a Google Sheets range. Provide the spreadsheet ID, target columns, and values as a JSON 2D array.
Instructions
Append rows to the end of data in a sheet.
Args: spreadsheet_id: The ID of the spreadsheet. range_notation: A1 notation indicating which columns (e.g., "Sheet1!A:D"). values: JSON 2D array of rows to append.
Returns: JSON with updated range and cells appended.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| values | Yes | ||
| range_notation | Yes | ||
| spreadsheet_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |