# writeSpreadsheet Writes data to a range in a spreadsheet, overwriting existing values. Use appendRows to add data without overwriting. Agent View of the PolicyLayer registry record for `writeSpreadsheet`. HTML page: https://policylayer.com/tools/a-bonus-google-docs-mcp/writespreadsheet ## Facts - Tool: `writeSpreadsheet` - Server: Claude MCP x Google Docs (`a-bonus/google-docs-mcp`) — https://policylayer.com/tools/a-bonus-google-docs-mcp.md - Homepage: https://github.com/a-bonus/google-docs-mcp - Risk category: Write (Medium risk) - Registry record: grade F, identity unverified - Server rate-limited: no - Parameters: 0 - Recommended policy verdict: Rate-limited ## Example call (MCP tools/call, JSON-RPC 2.0) ```json { "jsonrpc": "2.0", "id": 1, "method": "tools/call", "params": { "name": "writeSpreadsheet", "arguments": {} } } ``` ## Why writeSpreadsheet is rated Medium This tool modifies data in a spreadsheet by overwriting existing values. While it changes data, it is reversible and does not permanently delete information. The impact is limited to the targeted range. It is categorized as Write rather than Destructive because overwrites can be recovered and the operation is not inherently irreversible. From the tool's own definition: "Tool description explicitly states 'Writes data to a range in a spreadsheet, overwriting existing values.' The overwriting of existing values is reversible (can be undone via version history or by writing different data back), distinguishing it from…" ## Use case AI agents use writeSpreadsheet to create or update resources in Claude MCP x Google Docs, usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your Claude MCP x Google Docs environment. ## Recommended policy (PolicyLayer) Verdict: **Rate-limited**. Enforced by the PolicyLayer MCP gateway (https://policylayer.com/mcp-gateway) before a call reaches Claude MCP x Google Docs: ```json { "version": "1", "default": "deny", "tools": { "writeSpreadsheet": { "limits": [ { "counter": "writespreadsheet_rate", "window": "minute", "max": 30, "scope": "grant" } ] } } } ``` ## Other tools on Claude MCP x Google Docs (83) - `clearRange` — Destructive — https://policylayer.com/tools/a-bonus-google-docs-mcp/clearrange.md - `deleteChart` — Destructive — https://policylayer.com/tools/a-bonus-google-docs-mcp/deletechart.md - `deleteConditionalFormatting` — Destructive — https://policylayer.com/tools/a-bonus-google-docs-mcp/deleteconditionalformatting.md - `deleteDraft` — Destructive — https://policylayer.com/tools/a-bonus-google-docs-mcp/deletedraft.md - `deleteEvent` — Destructive — https://policylayer.com/tools/a-bonus-google-docs-mcp/deleteevent.md - `deleteFile` — Destructive — https://policylayer.com/tools/a-bonus-google-docs-mcp/deletefile.md - `deleteSheet` — Destructive — https://policylayer.com/tools/a-bonus-google-docs-mcp/deletesheet.md - `deleteSheetsComment` — Destructive — https://policylayer.com/tools/a-bonus-google-docs-mcp/deletesheetscomment.md - `deleteTable` — Destructive — https://policylayer.com/tools/a-bonus-google-docs-mcp/deletetable.md - `trashMessage` — Destructive — https://policylayer.com/tools/a-bonus-google-docs-mcp/trashmessage.md - `createAppsScriptProject` — Execute — https://policylayer.com/tools/a-bonus-google-docs-mcp/createappsscriptproject.md - `sendEmail` — Execute — https://policylayer.com/tools/a-bonus-google-docs-mcp/sendemail.md - `downloadFile` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/downloadfile.md - `getAppsScriptContent` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/getappsscriptcontent.md - `getConditionalFormatting` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/getconditionalformatting.md - `getDocumentInfo` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/getdocumentinfo.md - `getDraft` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/getdraft.md - `getFolderInfo` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/getfolderinfo.md - `getMessage` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/getmessage.md - `getSheetsComment` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/getsheetscomment.md - `getSpreadsheetInfo` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/getspreadsheetinfo.md - `getTable` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/gettable.md - `listDocuments` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/listdocuments.md - `listDrafts` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/listdrafts.md - `listDriveFiles` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/listdrivefiles.md - `listEvents` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/listevents.md - `listFolderContents` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/listfoldercontents.md - `listLabels` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/listlabels.md - `listMessages` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/listmessages.md - `listSheetsComments` — Read — https://policylayer.com/tools/a-bonus-google-docs-mcp/listsheetscomments.md - …and 53 more: https://policylayer.com/tools/a-bonus-google-docs-mcp.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=a-bonus-google-docs-mcp · API: https://policylayer.com/registry/api · Policy library: https://policylayer.com/policies/a-bonus-google-docs-mcp