# manage_conditional_formats Manages conditional-format rules that style cells when a condition holds (boolean rules; gradient color scales need raw_request). Rules are addressed by SHEET + INDEX in that sheet's rule list — get current rules and indexes from get_spreadsheet (sheets[].conditionalFormats), and re-read after every mutation because add/delete shift later indexes. action=add inserts a rule at index (default 0 = highest priority; rules are evaluated in order and the first match wins): needs ranges, condition_type (+condition_values; CUSTOM_FORMULA with a "=..." formula is the most flexible) and at least one format field (background_color, text_color, bold, italic). action=update replaces the ENTIRE rule at sheet_id+index with the newly provided one. action=delete removes the rule at sheet_id+index. Agent View of the PolicyLayer registry record for `manage_conditional_formats`. HTML page: https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-conditional-formats ## Facts - Tool: `manage_conditional_formats` - Server: Mcp Google Sheets (`@a1-x-tech/mcp-google-sheets`) — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets.md - Install: `npx -y @a1-x-tech/mcp-google-sheets` - Homepage: https://github.com/A1-x-Tech/mcp-google-sheets - Risk category: Write (Medium risk) - Registry record: grade F, identity unverified - Server rate-limited: no - Parameters: 11 (2 required) - Recommended policy verdict: Rate-limited ## Parameters | Parameter | Type | Required | Description | | --- | --- | --- | --- | | `bold` | boolean | no | Bold text for matching cells. | | `index` | integer | no | Rule position in the sheet's list. add: insert position (default 0); update/delete: required. | | `action` | string | yes | What to do with the rules. | | `italic` | boolean | no | Italic text for matching cells. | | `ranges` | array | no | add/update: the cells the rule applies to. | | `sheet_id` | integer | no | update/delete: the sheet whose rule list is addressed. | | `text_color` | string | no | Text color for matching cells, "#RRGGBB". | | `condition_type` | string | no | Sheets API condition type, e.g. ONE_OF_LIST, ONE_OF_RANGE, NUMBER_GREATER, NUMBER_LESS, NUMBER_BETWEEN, NUMBER_EQ, TEXT_CONTAINS, TEXT_STARTS_WITH, TEXT_EQ, TEX | | `spreadsheet_id` | string | yes | The spreadsheet id — the long id from the URL (docs.google.com/spreadsheets/d//edit) or from create_spreadsheet / search_spreadsheets output. | | `background_color` | string | no | Fill for matching cells, "#RRGGBB". | | `condition_values` | array | no | Condition arguments: list items for ONE_OF_LIST (["Yes","No"]), one number for NUMBER_GREATER (["100"]), two for NUMBER_BETWEEN, "=A1>B1"-style formula for CUST | Parameters from the server's own tool schema. ## Example call (MCP tools/call, JSON-RPC 2.0) ```json { "jsonrpc": "2.0", "id": 1, "method": "tools/call", "params": { "name": "manage_conditional_formats", "arguments": { "action": "", "spreadsheet_id": "" } } } ``` ## Why manage_conditional_formats is rated Medium Modifies spreadsheet formatting rules reversibly; no data deletion or code execution. From the tool's own definition: "Manages conditional-format rules that style cells when a condition holds; add inserts rule" Risk signals: High parameter count (16 properties) · Bulk/mass operation — affects multiple targets ## Use case AI agents use manage_conditional_formats to create or update resources in Mcp Google Sheets, usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your Mcp Google Sheets environment. ## Recommended policy (PolicyLayer) Verdict: **Rate-limited**. Enforced by the PolicyLayer MCP gateway (https://policylayer.com/mcp-gateway) before a call reaches Mcp Google Sheets: ```json { "version": "1", "default": "deny", "tools": { "manage_conditional_formats": { "limits": [ { "counter": "manage_conditional_formats_rate", "window": "minute", "max": 30, "scope": "grant" } ] } } } ``` ## Other tools on Mcp Google Sheets (19) - `clear_values` — Destructive — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/clear-values.md - `manage_dimensions` — Destructive — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-dimensions.md - `manage_sheets` — Destructive — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-sheets.md - `raw_request` — Execute — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/raw-request.md - `append_values` — Read — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/append-values.md - `get_spreadsheet` — Read — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/get-spreadsheet.md - `read_values` — Read — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/read-values.md - `search_spreadsheets` — Read — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/search-spreadsheets.md - `batch_write_values` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/batch-write-values.md - `create_spreadsheet` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/create-spreadsheet.md - `format_cells` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/format-cells.md - `manage_charts` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-charts.md - `manage_permissions` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-permissions.md - `manage_protected_ranges` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-protected-ranges.md - `manage_tables` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-tables.md - `set_borders` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/set-borders.md - `set_data_validation` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/set-data-validation.md - `set_frozen` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/set-frozen.md - `write_values` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/write-values.md ## For agents This record is a snapshot. Live verdicts and the full registry: - Check every server in your MCP config at once: `npx -y policylayer stack` - Vet a server before you add it: install the mcp-precheck skill — `npx skills add https://policylayer.com` (skill text: https://policylayer.com/skill.md) - Query the registry over MCP: endpoint `https://api.policylayer.com/mcp` — tools `check_mcp_server`, `check_mcp_stack`, `check_tool`, `search_registry`, `get_change_events` --- Source: the PolicyLayer MCP registry — one continuously verified record per MCP server. Full record: https://policylayer.com/registry?q=a1-x-tech-mcp-google-sheets · API: https://policylayer.com/registry/api · Policy library: https://policylayer.com/policies/a1-x-tech-mcp-google-sheets