Google Sheets MCP Server for interacting with spreadsheets through Claude
Server has 9 tools with complete input schemas and descriptions present for all tools and parameters. Naming follows verb_noun convention (list_, open_, read_, update_, create_, append_). However, descriptions are generic and lack LLM-optimization guidance. Parameter descriptions are minimal (10-30 chars typically). No output schemas documented. No error handling guidance. Missing tool annotations (readOnlyHint, destructiveHint). No pagination support for list operations. Lacks actionable error messages and recovery guidance.
Append a row to a worksheet
Create a new spreadsheet
Create a new worksheet in an existing spreadsheet
List all available spreadsheets
List all worksheets in the currently opened spreadsheet
Open a spreadsheet by title or URL
Read data from a worksheet
No output schemas documented. LLMs cannot plan downstream tool calls or extract required fields (e.g., spreadsheet_id returned by create_spreadsheet). Breaks tool chaining.
Descriptions lack LLM-optimization guidance. Generic 10-30 char descriptions (e.g., 'List all available spreadsheets') do not explain WHEN to use vs similar tools or what the LLM should expect. Baseline: 194 chars avg for A+ tools.
No tool annotations (readOnlyHint, destructiveHint, idempotentHint). LLMs cannot distinguish safe read-only tools from destructive writes. Agents may retry destructive operations, causing duplicates.
Inferred effective spec: <=2025-11-25.
| Scored | Grade | Overall | Spec posture | Rubric |
|---|---|---|---|---|
| 2026-09-23 | D | 52 | <=2025-11-25 | v2 |
Update a single cell in a worksheet
Update a range of cells in a worksheet
No error handling guidance. No recovery hints (e.g., 'If spreadsheet not found, call list_spreadsheets first'). No categorization of errors as retryable vs user-fixable. Agents cannot self-correct.
list_spreadsheets and list_worksheets lack pagination (limit, offset, next_cursor). Large result sets will blow context window. No documented result limits.