append_rows
Append rows to a Google Sheet after the last data row without overwriting. Supports literal input, dry-run preview, and safety limits.
Instructions
Append rows after the last data row of a sheet. Never overwrites.
Args: spreadsheet_id_or_url: Full Sheets URL or bare spreadsheet ID. sheet: Sheet name OR gid string. rows: 2D list of row values to append. raw: If true, store inputs literally (formulas become plain text). dry_run: If true, return the execution plan without writing. force: Allow writes touching more than the cell limit.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| raw | No | ||
| rows | Yes | ||
| force | No | ||
| sheet | Yes | ||
| dry_run | No | ||
| spreadsheet_id_or_url | Yes |