Skip to main content
Glama
Longtran2404

mcp-google-sheets-server

by Longtran2404

sheets_create_chart_from_table

Creates a chart in a Google Sheets spreadsheet from a selected table range, using headers as labels. Provide spreadsheet ID, range, and chart type to generate visual data insights.

Instructions

Create a chart from a table structure with headers and data

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
titleNoTitle of the chart
chartTypeYesType of chart to create
tableRangeYesRange of the table including headers (e.g., A1:D10)
chartOptionsNoAdditional chart options
spreadsheetIdYesThe ID of the spreadsheet
useFirstRowAsLabelsNoWhether to use first row as chart labels

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv2.2.1

TDQS

B3/5.0
Behavior1/5

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

There are no annotations and the description only states the high-level action. It does not disclose whether the tool overwrites existing charts, requires specific permissions, or has any side effects beyond creating a chart, leaving the agent without information about behavioral consequences.

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?

The description is a single clear sentence that directly states the tool's purpose. It is concise with no unnecessary words or redundant information, making it easy for an agent to parse quickly.

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?

With 6 parameters and a nested object, the tool has moderate complexity, but the description provides no context about the output, return value, or how to integrate this with other spreadsheet operations. The absence of an output schema and lack of usage guidance for a crowded sibling space leaves gaps in task completion context.

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?

All parameters have descriptions, so schema coverage is 100% (baseline 3). However, 'chartOptions' is defined only as 'Additional chart options' without explaining what options are valid or their effect, and 'useFirstRowAsLabels' is clear but could be more explicit about default behavior. No contradictions or missing parameters.

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?

The description clearly states the action ('Create'), the object ('a chart'), and the specific input format ('from a table structure with headers and data'), which distinguishes it from sibling tools like sheets_create_chart_with_data or sheets_create_chart that might have different input expectations.

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 is provided on when to use this tool versus the many sibling chart creation/update tools. There is no mention of selection criteria, such as preferring this when data is already in a table layout or when needing headers as labels, which would help an agent choose correctly.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.