Loading ToolBench

Reading the current corpus…

mcp-google-sheets MCP server · D · ToolBench

mcp-google-sheets

github.com/SunCreation/mcp-google-sheets

This MCP server integrates with your Google Drive and Google Sheets, to enable creating and modifying spreadsheets. (Forked with Gemini API schema fix)

2026-07-28+STREAMABLE_HTTP3 tools

57/100

Definition Quality61

Protocol Readiness72

Supportability41

Spec posture

Inferred effective spec 2026-07-28+·current baseline 2026-07-28

Static source inference · medium confidence · detected: Dynamic Client Registration

Deprecated protocol patterns detected

Summary

The server provides 3 tools with reasonable naming (get_*, update_*) and acceptable descriptions. However, significant gaps exist: the update_cells tool lacks a description entirely, parameter descriptions are inconsistent in depth, and output schemas are not documented. The server follows basic verb-noun naming conventions but lacks the LLM-optimized clarity expected of production tools. Schema completeness is mixed, some parameters are well-described while others lack context. Error handling is not evident in the source code provided.

Tools (3)

get_sheet_dataread onlyauthsource verified73/100

Get data from a specific sheet in a Google Spreadsheet. Args: spreadsheet_id: The ID of the spreadsheet (found in the URL) sheet: The name of the sheet range: Optional cell range in A1 notation (e.g., 'A1:C10'). If not provided, gets all data. include_grid_data: If True, includes cell formatting and other metadata in the response. Note: Setting this to True will significantly increase the response size and token usage when parsing the response, as it includes detailed cell formatting information. Default is False (returns values only, more efficient). Returns: Grid data structure with either full metadata or just values from Google Sheets API, depending on include_grid_data parameter

get_sheet_formulasread onlyauthsource verified70/100

Get formulas from a specific sheet in a Google Spreadsheet. Args: spreadsheet_id: The ID of the spreadsheet (found in the URL) sheet: The name of the sheet range: Optional cell range in A1 notation (e.g., 'A1:C10'). If not provided, gets all formulas from the sheet. Returns: A 2D array of the sheet formulas.

update_cellswriteauthsource verified40/100

Issues (6)

CRITICALtool-description ↗

update_cells tool has NO description, violates core DEFINITION QUALITY requirement

update_cells

HIGHtool, response-shaper ↗

Output schemas are not documented for any tool, LLMs cannot reason about downstream chaining

get_sheet_dataget_sheet_formulasupdate_cells

HIGHconstrained-input, tool-description ↗

Parameter descriptions are inconsistent and lack constraints, 'data' parameter in update_cells is unexplained

update_cells

MEDIUMinclude-chaining-ids ↗

No return value documentation in function signatures, cannot verify if responses include chaining IDs

get_sheet_dataget_sheet_formulasupdate_cells

MEDIUMrecovery-guide, error-classification ↗

No error handling guidance documented, LLMs cannot self-correct on invalid input

Recommendations

Add a comprehensive description to update_cells (currently 0 chars). State that it overwrites cell values, is irreversible, and what it returns.
Document the exact output schema for each tool, including field types and nested structure. Use JSON Schema or clear examples.
For update_cells, explain what 'data' parameter accepts: types (string, number, boolean, null, formula?), nesting rules, and size limits.
Add 'required' field markers to all parameters and explain which fields are truly required vs optional with defaults.
Document error conditions for each tool and provide recovery guidance in descriptions (e.g., 'If spreadsheet not found, verify ID is from the URL').
Consider renaming update_cells to update_sheet_cells or set_cell_values to disambiguate from a potential 'batch_update' tool.
Add parameter range/limit constraints: 'range must be valid A1 notation (e.g., A1:Z100)', 'data array must match range dimensions'.
Enrich parameter descriptions with format examples: instead of 'A1:C10', show 'A1:C10 or Sheet1!A1:C10 or 'Sales Data'!A1:B100'.
Document pagination/limits: do get_sheet_data and get_sheet_formulas have maximum range sizes? Do they support pagination?
Return structured error messages from tools, not raw API exceptions. Include suggestions for correction (e.g., 'Sheet not found. Available sheets: Sales, Inventory, Forecast').

Score history

Overall score trend

↑ 28 points across a rubric change (v1 → v2)

57/100

Scored	Grade	Overall	Spec posture	Rubric
2026-09-22	D	57	2026-07-28+	v2
2026-03-09	F	29	-	v1