# write_values Overwrites one A1 range with a 2-D values matrix (rows first) and returns updatedRange/updatedRows/updatedColumns/updatedCells. The matrix is anchored at the range's top-left corner; cells beyond the matrix keep their old content, and a null entry skips (does not clear) that cell — use clear_values to empty cells. value_input_option USER_ENTERED (default) parses input like typing in the UI: "=SUM(A1:A10)" becomes a live formula, "1,234" and "2026-01-15" become number/date per the spreadsheet locale; RAW stores everything as literal values. For several ranges use batch_write_values (one quota unit instead of N). Agent View of the PolicyLayer registry record for `write_values`. HTML page: https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/write-values ## Facts - Tool: `write_values` - Server: Mcp Google Sheets (`@a1-x-tech/mcp-google-sheets`) — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets.md - Install: `npx -y @a1-x-tech/mcp-google-sheets` - Homepage: https://github.com/A1-x-Tech/mcp-google-sheets - Risk category: Write (Medium risk) - Registry record: grade F, identity unverified - Server rate-limited: no - Parameters: 5 (3 required) - Recommended policy verdict: Rate-limited ## Parameters | Parameter | Type | Required | Description | | --- | --- | --- | --- | | `range` | string | yes | A1-notation range, e.g. "Sheet1!A1:C10", "'My sheet'!B2:D" (quote titles with spaces) or a bare sheet title for the whole sheet. | | `values` | array | yes | 2-D array of cell values, outer array = rows: [["Name","Score"],["Ada",42]]. null leaves the existing cell untouched. | | `spreadsheet_id` | string | yes | The spreadsheet id — the long id from the URL (docs.google.com/spreadsheets/d//edit) or from create_spreadsheet / search_spreadsheets output. | | `value_input_option` | string | no | USER_ENTERED (default) parses formulas/numbers/dates; RAW stores literal strings. | | `include_values_in_response` | boolean | no | Return the written cells (as rendered) in the response. | Parameters from the server's own tool schema. ## Example call (MCP tools/call, JSON-RPC 2.0) ```json { "jsonrpc": "2.0", "id": 1, "method": "tools/call", "params": { "name": "write_values", "arguments": { "range": "", "values": [], "spreadsheet_id": "" } } } ``` ## Why write_values is rated Medium Modifies spreadsheet data reversibly; high impact if misused but not permanently destructive. From the tool's own definition: "Overwrites one A1 range with a 2-D values matrix; reversible modification." Risk signals: Bulk/mass operation — affects multiple targets ## Use case AI agents use write_values to create or update resources in Mcp Google Sheets, usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your Mcp Google Sheets environment. ## Recommended policy (PolicyLayer) Verdict: **Rate-limited**. Enforced by the PolicyLayer MCP gateway (https://policylayer.com/mcp-gateway) before a call reaches Mcp Google Sheets: ```json { "version": "1", "default": "deny", "tools": { "write_values": { "limits": [ { "counter": "write_values_rate", "window": "minute", "max": 30, "scope": "grant" } ] } } } ``` ## Other tools on Mcp Google Sheets (19) - `clear_values` — Destructive — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/clear-values.md - `manage_dimensions` — Destructive — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-dimensions.md - `manage_sheets` — Destructive — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-sheets.md - `raw_request` — Execute — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/raw-request.md - `append_values` — Read — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/append-values.md - `get_spreadsheet` — Read — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/get-spreadsheet.md - `read_values` — Read — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/read-values.md - `search_spreadsheets` — Read — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/search-spreadsheets.md - `batch_write_values` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/batch-write-values.md - `create_spreadsheet` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/create-spreadsheet.md - `format_cells` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/format-cells.md - `manage_charts` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-charts.md - `manage_conditional_formats` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-conditional-formats.md - `manage_permissions` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-permissions.md - `manage_protected_ranges` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-protected-ranges.md - `manage_tables` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-tables.md - `set_borders` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/set-borders.md - `set_data_validation` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/set-data-validation.md - `set_frozen` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/set-frozen.md ## For agents This record is a snapshot. Live verdicts and the full registry: - Check every server in your MCP config at once: `npx -y policylayer stack` - Vet a server before you add it: install the mcp-precheck skill — `npx skills add https://policylayer.com` (skill text: https://policylayer.com/skill.md) - Query the registry over MCP: endpoint `https://api.policylayer.com/mcp` — tools `check_mcp_server`, `check_mcp_stack`, `check_tool`, `search_registry`, `get_change_events` --- Source: the PolicyLayer MCP registry — one continuously verified record per MCP server. Full record: https://policylayer.com/registry?q=a1-x-tech-mcp-google-sheets · API: https://policylayer.com/registry/api · Policy library: https://policylayer.com/policies/a1-x-tech-mcp-google-sheets