Skip to main content
Glama
orieg

orieg/gws-connector

gws.sheets.write_range

Destructive

Write values to a specified range in a Google Spreadsheet using a 2D array of cell data. Choose USER_ENTERED for parsed formulas/dates or RAW for verbatim input, after confirming intent.

Instructions

Write values to a range in a Google Spreadsheet. values is a JSON array of arrays of scalars (strings/numbers/bools/null). Example: values = [["A1","B1"],["A2","B2"]]. value_input_option defaults to 'USER_ENTERED' (formulas, dates are parsed); pass 'RAW' to write values verbatim. This tool irreversibly modifies user content. Confirm intent with the user before calling it on documents you did not create in this session.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
rangeYesA1-notation range (e.g., 'Sheet1!A1:B2')
valuesYes2D array of cell values (array of row arrays)
accountNoAccount label or email. Uses default if omitted.
spreadsheet_idYesThe spreadsheet ID
value_input_optionNo'RAW' or 'USER_ENTERED' (default)
Behavior5/5

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

Beyond annotations declaring destructiveHint, the description adds essential context: 'This tool irreversibly modifies user content' and instructs to confirm intent with the user, especially for documents not created in the session. It also explains the behavioral difference between USER_ENTERED and RAW input options.

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 concise and front-loaded with the primary purpose, followed by necessary parameter details and a safety warning. Each sentence contributes meaningful information without unnecessary verbosity.

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

Completeness5/5

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

For a destructive write tool with no output schema, the description is complete: it covers the core action, parameter semantics for the more complex fields, and includes a clear warning about irreversibility and user confirmation. It equips an agent to use the tool safely and correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, providing baseline meaning for all parameters. The description adds extra value by detailing the structure of 'values' with an explicit example and clarifying that value_input_option defaults to 'USER_ENTERED'—information not fully present in the schema description.

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 with a specific verb and resource: 'Write values to a range in a Google Spreadsheet.' It distinguishes from the sibling read tool by the verb 'write' versus 'read,' and the example further clarifies the intended use.

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

Usage Guidelines4/5

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

The description provides clear context that this is for writing values, but it does not explicitly name alternatives like gws.sheets.read_range or specify when-not-to-use. However, it does include a caution to confirm intent with the user, which offers some usage guidance.

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/orieg/gws-connector'

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