manage_sheets
Read, write, and manage Google Sheets: append rows, update ranges, clear cells, and handle tabs (add, rename, delete, duplicate, copy) across spreadsheets.
Instructions
Read, write, and manage Google Sheets spreadsheets.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| Yes | Account email address | ||
| index | No | Position among tabs (0-based). Appended at the end if omitted. | |
| range | No | A1 notation range (e.g. 'Sheet1!A1:D10', or just 'Sheet1' for a whole tab). On `append`, the target tab — defaults to 'Sheet1'; use 'MyTab' or 'MyTab!A:Z' to append to a specific one. | |
| title | No | On `create`, the spreadsheet title (defaults to 'Untitled spreadsheet'); on `renameSpreadsheet`, its new title. On `addSheet`, the name of the new TAB; on `renameSheet`, that tab's new title; on `duplicateSheet`, the name for the copy (defaults to 'Copy of <source>'). | |
| values | No | Comma-separated values for a single row (e.g. 'Alice,100,true') | |
| sheetId | No | Sheet ID of the tab, from `manage_sheets get`. On `duplicateSheet` and `copySheetTo`, the SOURCE tab to copy. | |
| rowCount | No | Initial row count (default 1000) | |
| operation | Yes | get: get spreadsheet metadata and sheet names | create: create a new spreadsheet (optionally with a title) | read: read cell values from a range; rendered rows are prefixed with their sheet row number (e.g. 'R3: …') since blank rows are otherwise invisible | append: append rows to a spreadsheet (rows land after the last row of existing data in the target range) | getValues: get values from a specific range (raw API); rendered rows are prefixed with their sheet row number (e.g. 'R3: …') | updateValues: write values to a specific range | clearValues: clear cell values from a range (structure preserved) | addSheet: add a new tab (sheet) to the spreadsheet | renameSheet: rename a tab (sheet) within a spreadsheet | deleteSheet: delete a tab (sheet) from the spreadsheet — irreversible | duplicateSheet: duplicate a tab within the same spreadsheet | renameSpreadsheet: rename the spreadsheet (the document title, not a tab) | copySheetTo: copy a tab from this spreadsheet into another spreadsheet | |
| jsonValues | No | JSON 2D array of rows (e.g. '[["a","b"],["c","d"]]'). Use for bulk and multi-row writes. | |
| columnCount | No | Initial column count (default 26) | |
| spreadsheetId | No | Spreadsheet ID. On `copySheetTo`, the SOURCE spreadsheet. | |
| valueInputOption | No | How input is interpreted: USER_ENTERED (default, parses formulas/types) or RAW | |
| destinationSpreadsheetId | No | Destination spreadsheet ID |