Skip to main content
Glama
circuitry-dev

Circuitry MCP Server

Official

sheet.fillRange

Fill spreadsheet ranges with formula patterns using {row} and {col} placeholders to efficiently compute columns or rows in Circuitry workflows.

Instructions

Fill a range with a formula pattern - efficient for computed columns/rows. Use {row} for 1-indexed row number (Excel-style), {col} for column letter.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
nodeIdYesSheet node ID or name
formulaYesFormula pattern with {row}/{col} placeholders (e.g., "=A{row}*B{row}")
colNoColumn index for vertical fill (0-indexed)
startRowNoStart row (0-indexed, defaults to 0)
endRowNoEnd row (0-indexed, defaults to last row)
rowNoRow index for horizontal fill (0-indexed)
startColNoStart column for horizontal fill (0-indexed)
endColNoEnd column for horizontal fill (0-indexed)
Behavior2/5

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

With no annotations provided, the description carries full burden but lacks critical behavioral details. It mentions efficiency but does not disclose whether this is a mutation operation, what permissions are required, how errors are handled, or the impact on existing data. For a tool with 8 parameters and no annotations, this is a significant gap in transparency.

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?

The description is front-loaded with the core purpose and efficiently explains the formula pattern syntax in a single, clear sentence. Every word earns its place, with no redundant or verbose language, making it highly concise and well-structured.

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

Completeness3/5

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

Given the tool's complexity (8 parameters, no output schema, no annotations), the description is incomplete. It adequately covers the formula pattern aspect but lacks details on behavioral traits, error handling, and output expectations. While the schema provides parameter documentation, the description does not compensate for the absence of annotations and output schema, leaving gaps for an AI agent.

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 description coverage is 100%, so the schema already documents all parameters thoroughly. The description adds value by explaining the formula pattern syntax with {row}/{col} placeholders and Excel-style indexing, which clarifies semantics beyond the schema's basic descriptions. However, it does not elaborate on other parameters like nodeId or fill directions, relying on the schema.

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 specific action ('Fill a range with a formula pattern') and resource ('sheet'), distinguishing it from sibling tools like sheet.setCell or sheet.setCells by emphasizing pattern-based filling for computed columns/rows. The mention of efficiency for computed columns/rows further clarifies its specialized use case.

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

Usage Guidelines3/5

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

The description implies usage for computed columns/rows with formula patterns, providing some context, but does not explicitly state when to use this tool versus alternatives like sheet.setCellFormula or sheet.setCells. No exclusions or prerequisites are mentioned, leaving gaps in guidance.

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/circuitry-dev/circuitry-mcp-server'

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