Fill cells
fill_rangeFill cells from a source block like dragging a fill handle: repeat formulas, values, and formatting across a range, or continue series patterns (1,2,3 → 4,5,6).
Instructions
Fill cells from a source block, like dragging the fill handle or pasting onto a bigger selection: the source's formulas (relative references shift), values and formatting repeat across the destination. Use it after writing one row or column of formulas to extend them across a table, instead of sending every column. With continue_series, patterns continue instead (1, 2, 3 → 4, 5, 6; Jan → Feb; dates). The destination's previous contents are saved for undo_last. Returns any formula errors found after filling.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| paste | No | all = formulas, values and formatting; formulas = formulas and values without formatting; values = results as plain values; formats = formatting only | all |
| source | Yes | The cells to fill from, e.g. "Model!O25:O97" | |
| 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. | |
| allow_large | No | Required for fills over 10000 cells | |
| destination | Yes | The cells to fill, e.g. "Model!P25:AE97" (it may include the source). For continue_series it must sit right after, or right before, the source in the same rows or columns | |
| spreadsheet | Yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works | |
| continue_series | No | Extend the pattern in the source (like the fill handle) instead of repeating it |