# manage_dimensions Row/column operations on a run of rows (dimension=ROWS) or columns (dimension=COLUMNS), addressed by sheet_id + 0-based start_index (inclusive) and end_index (exclusive) — e.g. columns A-C = start 0, end 3. action=resize sets an exact pixel_size; auto_resize fits to content; insert adds empty rows/columns at start_index (inherit_from_before=true copies formatting from the row/column before instead of after); delete removes them WITH their data (irreversible; cell references below/right shift); hide/show toggle visibility without touching data; group/ungroup add or remove a collapsible outline group over the run (groups nest — repeat group on a subrange for a deeper level). Agent View of the PolicyLayer registry record for `manage_dimensions`. HTML page: https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-dimensions ## Facts - Tool: `manage_dimensions` - 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: Destructive (Critical risk) - Registry record: grade F, identity unverified - Server rate-limited: no - Parameters: 8 (6 required) - Recommended policy verdict: Hidden ## Parameters | Parameter | Type | Required | Description | | --- | --- | --- | --- | | `action` | string | yes | What to do with the rows/columns. | | `sheet_id` | integer | yes | The numeric sheetId (NOT the title) from get_spreadsheet sheets[].properties.sheetId; the first sheet of a new spreadsheet is 0. | | `dimension` | string | yes | Whether the run is rows or columns. | | `end_index` | integer | yes | End of the run, exclusive (rows 1-3 = start 0, end 3). | | `pixel_size` | integer | no | resize: the new size in pixels. | | `start_index` | integer | yes | First row/column of the run, 0-based inclusive. | | `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. | | `inherit_from_before` | boolean | no | insert: new rows/columns copy formatting from before the insertion point (default: after). | 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": "manage_dimensions", "arguments": { "action": "", "sheet_id": 0, "dimension": "", "end_index": 0, "start_index": 0, "spreadsheet_id": "" } } } ``` ## Why manage_dimensions is rated Critical Delete action irreversibly removes rows/columns and their data, shifting references permanently. From the tool's own definition: "delete removes them WITH their data (irreversible; cell references below/right shift)" ## Use case AI agents call manage_dimensions to permanently remove resources in Mcp Google Sheets, typically in cleanup and lifecycle workflows. It does its job in a single call, and there is no undo. ## Recommended policy (PolicyLayer) Verdict: **Hidden**. Enforced by the PolicyLayer MCP gateway (https://policylayer.com/mcp-gateway) before a call reaches Mcp Google Sheets: ```json { "version": "1", "default": "deny", "hide": [ "manage_dimensions" ] } ``` ## Other tools on Mcp Google Sheets (19) - `clear_values` — Destructive — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/clear-values.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 - `write_values` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/write-values.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