Append rows
append_rowsAppend rows after the last data row in a Google Sheets table, using a tab or range and a 2D array of values to add records or formulas.
Instructions
Append rows after the last row of data in a table (detected from the given range or tab).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | Tab name or table range, e.g. "Sales" or "Sales!A:F" | |
| values | Yes | 2D array of rows. Strings starting with = are formulas. | |
| account | No | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. | |
| spreadsheet | Yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |