Skip to main content
Glama

sheets_get_conditional_formatting

Read-onlyIdempotent

Read conditional formatting rules and banded ranges (alternating row/column colors) for a sheet. Includes normalized formulas with raw originals available.

Instructions

Read conditional formatting rules and banded ranges (alternating row/column colors) for a sheet. CF formulas are normalized to English locale (semicolons → commas) by default. Each rule with a formula includes a "_formulaLocaleRaw" field with the original unmodified formula. Set normalizeFormulas:false to get raw formulas as returned by the API.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
sheetNameYesName of the sheet (tab) to inspect
spreadsheetIdYesThe ID of the spreadsheet (found in the URL after /d/)
normalizeFormulasNoDefault: true. Normalize formula separators to English locale (semicolons → commas). Each normalized rule includes "_formulaLocaleRaw" with the original formula. Set to false to get formulas exactly as returned by the Google Sheets API.
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already indicate read-only and idempotent. The description adds significant extra detail: normalized formulas to English locale, inclusion of '_formulaLocaleRaw', and the option to disable normalization. This goes beyond annotations and explains important behavior.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two sentences, front-loaded with the main purpose, and then a focused note on normalization. Every sentence earns its place without redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a read-only getter with no output schema, the description covers what is read (CF rules, banded ranges), default normalization, the raw locale field, and the escape hatch via parameter. It is complete for the tool's complexity.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100% with detailed descriptions for each parameter. The description reinforces the normalization behavior already in the schema but doesn't add new meaning beyond what the schema provides, so baseline 3 is appropriate.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool reads conditional formatting rules and banded ranges, using a specific verb (Read) and resource. It distinguishes from siblings like 'sheet_get_sheet_formatting' by focusing on conditional formatting specifically.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Provides clear context that this tool is for reading conditional formatting and banded ranges, and mentions the normalization behavior. Though it doesn't explicitly name alternatives, the scope is well-defined so an agent can infer when to use it.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/freema/mcp-gsheets'

If you have feedback or need assistance with the MCP directory API, please join our Discord server