Skip to main content
Glama

Set Field Autofill

sheet.set_autofill
DestructiveIdempotent

Make a field fill itself on an existing sheet, or stop it. source: ai writes from an instruction reading readFields (by name) — it uses AI credit, so tell the user (the result's note). source: formula computes the value from formula, with fields in braces ({Price} * {Quantity}). source: manual removes the field's autofill. Fields are named as sheet.schema lists them; an unknown name is refused with the valid ones.

Input Schema

NameRequiredDescriptionDefault
whenNoWhen it fills: `created` (new rows), `first_value` (once the named field gets a value) or `changed` (whenever the named fields change). Default: AI on created; a formula whenever the fields it reads change.
fieldYesName (or code) of the field that fills itself.
sourceYes`ai` fills from an instruction, `formula` computes it, `manual` turns autofill off.
formulaNoFormula only: fields in braces, e.g. `{Price} * {Quantity}`.
sheetIdYes
readFieldsNoAI only: the fields the AI reads, by name.
instructionNoAI only: what to write into the field.
keepUpdatedNoAlso refill a value autofill wrote earlier (never a person's). Default: true for a formula, false for AI.

Output Schema

NameRequiredDescriptionDefault
noteNoTell the user this (AI credit use)
fieldYesThe field whose autofill was set
sourceYesWhat fills it now; manual = autofill removed
workflowIdNoThe autofill workflow

Schema Changelog

Changes observed during successful MCP inspections.

  1. Added

TDQS

A4.4/5.0
Behavior4/5

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

Annotations already flag destructiveHint=true and idempotentHint=true, but the description adds genuinely new behavior: `source: ai` consumes AI credit and surfaces a `note` the agent should relay, and `manual` removes the existing autofill. It stops short of describing reversibility or what happens to already-written values beyond the keepUpdated default note.

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

Conciseness4/5

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

Front-loaded with the core action, then one clause per source mode, then the naming rule. Dense but every clause carries information; the heavy em-dash compression costs a little readability but no sentence is wasted.

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?

With an output schema present, the description does not need to explain return values, yet it still calls out the `note` field where it matters. Nested `when` semantics and keepUpdated defaults are documented in schema, and the description covers the mode-selection and naming contract that complete the picture for an 8-parameter mutation tool.

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

Parameters4/5

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

Schema coverage is already 88%, so a baseline 3 applies, but the description adds real meaning: `field` names must match what `sheet.schema` lists, `formula` uses brace-referenced fields, and `readFields` is by name. These tie the AI and formula parameters to the naming contract the schema alone does not state.

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 opens with a specific verb phrase and resource: make a field fill itself on an existing sheet, or stop it. The three modes (ai, formula, manual) sharpen the scope enough that an agent can distinguish this from siblings like sheet.update_attribute or sheet.set_dependencies without opening either schema.

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?

It gives explicit selection logic among the three sources — AI writes from an instruction reading readFields, formula computes from braces, manual removes autofill — plus the unknown-field-name refusal behavior. It does not explicitly contrast against sibling tools such as sheet.update_attribute, which keeps it short of a 5.

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

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources