Skip to main content
Glama
salviz

Google Workspace MCP Server

by salviz

sheets_batch_get

Read multiple cell ranges from a Google Sheet in a single call. Specify ranges in A1 notation to fetch data from different sheets at once.

Instructions

Read multiple ranges at once from a Google Spreadsheet (spreadsheets.values.batchGet)

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
rangesYesComma-separated ranges in A1 notation, e.g. 'Sheet1!A1:B2,Sheet1!C1:D2'
spreadsheetIdYesThe spreadsheet ID
Behavior2/5

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

No annotations provided, so description must carry full behavioral burden. It lacks details about read-only nature, error handling, rate limits, or permissions. Minimally discloses that it reads multiple ranges.

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?

Single sentence, front-loaded with purpose. Efficient with zero waste, but could benefit from slight structure like listing key aspects.

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

Completeness2/5

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

Lacks crucial context such as return format (array of values?), maximum ranges allowed, and error scenarios. Without output schema or annotations, agent is left guessing.

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%, so baseline is 3. Description does not add extra meaning beyond what schema provides for both parameters (spreadsheetId, ranges). No additional constraints or examples.

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?

Description clearly states verb ('Read'), resource ('multiple ranges from a Google Spreadsheet'), and includes the underlying API method. This distinguishes it from single-range reads like sheets_read.

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?

No guidance on when to use this tool vs alternatives such as sheets_read or sheets_batch_get_by_data_filter. Agent must infer usage from context.

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/salviz/google-mcp-server'

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