Skip to main content
Glama

create_chart

Visualize data by creating an embedded chart in a Google Sheet using specified chart type and data ranges.

Instructions

Create an embedded chart from existing sheet data.

chart_type: COLUMN, BAR, LINE, AREA, SCATTER, COMBO, STEPPED_AREA, PIE, or DONUT.

domain_range is the category/label range; series_ranges is one or more value ranges. Each source must be a single row or single column, e.g. Sheet1!A2:A10 plus Sheet1!B2:B10. Ranges without a sheet prefix use sheet. anchor_cell is where the chart is overlaid on that sheet.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
sheetYes
titleNo
pie_holeNo
chart_typeYes
anchor_cellNoE2
domain_rangeYes
header_countNo
stacked_typeNo
width_pixelsNo
x_axis_titleNo
y_axis_titleNo
height_pixelsNo
series_rangesYes
spreadsheet_idYes
legend_positionNoRIGHT_LEGEND
offset_x_pixelsNo
offset_y_pixelsNo
three_dimensionalNo
Behavior3/5

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

No annotations are provided, so the description bears full responsibility. It discloses chart types, range constraints, and default anchor cell, but lacks warnings about side effects, permissions, or behavior when overlapping data. Adequate but not thorough.

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?

The description is brief (5 lines) and front-loaded with the main purpose. It logically lists chart types then range specifications. No redundant sentences, but could be slightly more compact.

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?

No output schema exists, and the description does not mention what the tool returns (e.g., chart ID). It covers creation aspects but omits return value, error conditions, and the fact that the chart is embedded on the specified sheet. Incomplete for a tool with 18 parameters.

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 0%, so the description must compensate. It explains 'chart_type' (lists valid values), 'domain_range' and 'series_ranges' (single row/column, sheet prefix), and 'anchor_cell' default. However, 18 parameters exist; many like 'pie_hole', 'header_count', 'stacked_type' are left unexplained. Partial compensation.

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 an embedded chart') and the resource ('from existing sheet data'). It specifies the source and distinguishes from sibling tools like 'create_chart_from_spec' and 'update_chart'.

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

Usage Guidelines3/5

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

The description implies usage for creating embedded charts but does not explicitly state when to use this tool over alternatives (e.g., 'create_chart_from_spec'). No guidance on prerequisites or when not to use it.

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/richmcpharlin/google-sheets-mcp'

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