append_table_rows
Append rows to a structured Google Sheets table, automatically extending its range and typing values as boolean, number, formula, or string.
Instructions
Append rows to a structured Sheets table, auto-extending its range.
Side effects: mutates the table — new rows are added after the last existing row and the table range grows to include them. Values are typed automatically: bool → boolean, numeric → number, strings starting with "=" → formula, otherwise string. For plain range writes use modify_sheet_values. Requires the spreadsheets OAuth scope.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| user_google_email | Yes | The user's Google email address (authenticated account). | |
| spreadsheet_id | Yes | Target spreadsheet ID. | |
| table_id | Yes | Table ID from list_sheet_tables (a numeric string; distinct from sheetId). | |
| values | Yes | 2D list (each inner list = one row of cell values) or a JSON-encoded version of same. Column count should match the table. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |