Skip to main content
Glama

Read a range of cells

read_google_sheet_range

Read cell values from an A1 range, e.g. "Sheet1!A1:D50" or a whole tab like "Invoices". Formulas come back as the value they display. At most 10,000 cells per call — ask for a narrower range rather than a whole large sheet.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
rangeYesA1 notation, e.g. "Sheet1!A1:D50". A bare tab name reads the whole tab
mailboxYesEmail address of the connected Gmail/Google Workspace mailbox to act on. Call list_authorized_mailboxes to see available options.
spreadsheetIdYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A3.7/5.0
Behavior4/5

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

With no annotations provided, the description carries the full behavioral burden. It usefully discloses that formulas return their displayed value and that calls are limited to 10,000 cells, which are non-obvious behaviors. It does not cover error cases or authentication, but the disclosed traits are meaningful.

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 with no filler: the first states the purpose with examples, the second adds formula behavior and a practical constraint. The most important usage information is front-loaded.

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

Completeness4/5

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

For a simple read tool with no annotations and no output schema, the description covers the essential calling details: range format, whole-tab support, formula behavior, and size limits. It does not describe the return shape or spreadsheetId semantics, but the core invocation is adequately specified.

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 67%, with range and mailbox described but spreadsheetId left undocumented. The description adds value by giving concrete A1 notation examples, explaining whole-tab reads, and warning about the 10,000-cell limit, which clarifies the range parameter beyond the schema.

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

Purpose4/5

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

The description states a specific action ('Read cell values from an A1 range') with concrete examples like 'Sheet1!A1:D50' and 'Invoices'. It is clear about the resource and scope, though it does not explicitly differentiate itself from the sibling read_excel_range beyond the tool name.

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

Usage Guidelines2/5

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

The description gives no guidance on when to use this tool versus alternatives such as read_excel_range or get_google_spreadsheet. It implies usage through the name and examples, but there is no explicit when-to-use or when-not-to-use direction.

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