Write cells
write_rangeWrites values and formulas into a Google Sheets range from its top-left cell. Saves prior content for undo and reports formula errors.
Instructions
Write values and/or formulas starting at the top-left cell of the range. Input is parsed like typing into the UI (formulas, dates, percentages work). Previous contents are saved for undo_last. Returns any formula errors found after writing.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | Top-left cell or full range, e.g. "Sheet1!B2" | |
| 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. | |
| dry_run | No | Only show what would be overwritten | |
| allow_large | No | Required for writes over 10000 cells | |
| spreadsheet | Yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |