Skip to main content
Glama

Sheets Get

sheets_get
Read-onlyIdempotent

Get current sheet metadata, column types, stable IDs, option IDs and versions before editing an existing sheet. Preserve existing schema and data. For a newly created sheet, reuse create/add-column receipts instead of rereading known metadata; read cell values with sheets_query.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
sheetIdYes

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
columnsYes
sheetIdYes
metadataYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A4.5/5.0
Behavior4/5

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

Annotations already declare readOnlyHint, idempotentHint, and non-destructive, and an output schema exists, so the safety and return-format burdens are largely carried elsewhere. The description still adds workflow context (pre-edit metadata fetch, preserving existing schema/data) that is not encoded in any structured field.

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?

Three tight sentences, front-loaded with the primary purpose, then constraints, then alternatives. No filler or restatement of the title.

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 one-parameter, read-only metadata getter with an existing output schema and full annotation coverage, the agent has everything needed: what it returns, when to call it, and what to call instead.

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 0% and the single sheetId parameter is never mentioned in the description. The schema's format:uuid gives partial signal, but the description does nothing to clarify the identifier, so it neither compensates nor adds value here.

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?

States a specific verb (Get) and resource (sheet metadata) and enumerates exactly what comes back: column types, stable IDs, option IDs, versions. It explicitly distinguishes itself from sheets_query for cell values and from create/add-column receipts for newly created sheets, so an agent can route correctly without opening a schema.

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

Usage Guidelines5/5

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

Gives an explicit when-to-use trigger (read metadata before editing an existing sheet) and names two alternatives with the condition that selects them: reuse receipts for fresh sheets, and sheets_query for cell values. This is close to a complete routing rule.

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