Write cells into a Rootr spreadsheet sheet (preferred way to fill in data)
rootr_patch_spreadsheet_cellsPatches individual cells in a sheet using a sparse map of A1 references, supporting values, formulas, and null to clear. Only modifies specified cells, leaving others unchanged.
Instructions
Sparse-patch cells of ONE sheet in a Rootr (루터) SPREADSHEET, without touching the rest of the sheet. PREFER this over rootr_update_spreadsheet when you are only filling in / editing cell values or formulas. Cells are addressed A1-style ("A1", "B12", ...) in a sparse map: { "A1": { v: 42 }, "B1": { f: "=A1*2" } }. Set a cell to null to clear it. Read the sheet first (rootr_read_spreadsheet) so you know current dimensions and existing content before patching — patchCells only touches the keys you send, everything else is untouched.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cells | Yes | Map of A1-style ref -> cell (or null to clear), e.g. { "A1": { "v": 42 }, "B1": { "f": "=A1*2" } } | |
| sheetId | Yes | Sheet id to patch | |
| spreadsheetId | Yes | SPREADSHEET node id |