write_sheet
Write rows to a specific tab and cell of a Google Sheets spreadsheet. Supports raw text input or user-entered formulas, with an option to preview changes before writing.
Instructions
Write rows to a tab of a spreadsheet (item), starting at start_cell (default A1).
value_input RAW (default) stores cell text literally; pass 'USER_ENTERED' to interpret typed
values/formulas (a leading '=' becomes a live formula). Overwriting existing non-empty cells
requires confirm=true. dry_run=true returns a predicted before/after (client-side) without
writing; formula cells are shown literally (Google's recalculation is not simulated).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tab | Yes | ||
| item | Yes | ||
| rows | Yes | ||
| confirm | No | ||
| dry_run | No | ||
| start_cell | No | A1 | |
| value_input | No | RAW |