workiva_format_cells
Apply cell formatting to Workiva table ranges, including fill colors and borders, using batch operations for efficient updates.
Instructions
Format cells via POST /content/tables/{tableId}/cells/edit (v2026).
table_id here is the sheet's OPAQUE content-table TOKEN (sheet.table.table — a long base64-ish string), NOT a 32-hex UUID. The legacy UUID path 404s on v2026. Colors are RGB objects {red, green, blue} with integer channels 0–255.
⚠️ v2026 PERSISTENCE (live-verified 2026-05-31 with before/after readback): NOT every op that returns 202 actually applies. On this cells/edit endpoint:
setCellsProperties (fillColor) — ✅ PERSISTS. Use this for cell fill.
setCellsBorders — borders (use NO_BORDER to clear; dedupe per edge).
formatCells (font/bold/color) — ⚠️ returns 202 but does NOT persist on v2026. For font/bold/size use the SEPARATE platform path: POST /spreadsheets/{ss}/sheets/{sid}/update with applyFormats.textFormat (fontFamily/fontSize/bold) — NOT exposed by this tool; call via api_request.
valueFormat / dataValidation / conditionalFormat — NO proven REST route on v2026 (UI-only); cells/edit returns 400 MalformedValue for DV/CF. A 202 from this tool is acceptance, NOT proof of apply — read the cell properties back to confirm.
Args: table_id: The opaque content-table token (from describe_workbook / get_sheet → table.table) operations: Array of format operations. Recommended types: - setCellsProperties (PERSISTS): {"type":"setCellsProperties","setCellsProperties":{"ranges":[...],"fillColor":{"red":230,"green":240,"blue":255}}} - setCellsBorders: {"type":"setCellsBorders","setCellsBorders":{"ranges":[...],"bottom":{"color":{"red":0,"green":0,"blue":0},"style":"single","weight":1}}} - formatCells (⚠️ 202 but no-persist on v2026 — see note): {"type":"formatCells","formatCells":{"ranges":[...],"color":{...},"fontFamily":"Arial","bold":true}}
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table_id | Yes | ||
| operations | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |