sheets_duplicate_sheet
Duplicate a sheet in Google Sheets by specifying the spreadsheet ID, sheet ID, insertion index, and new name. Streamline worksheet replication for organized data management.
Instructions
Duplicate a sheet within a Google Sheets spreadsheet
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| insertSheetIndex | No | The index where the new sheet should be inserted (0-based) | |
| newSheetName | No | The name for the duplicated sheet | |
| sheetId | Yes | The ID of the sheet to duplicate (use sheets_get_metadata to find sheet IDs) | |
| spreadsheetId | Yes | The ID of the spreadsheet (found in the URL after /d/) |
Input Schema (JSON Schema)
{
"properties": {
"insertSheetIndex": {
"description": "The index where the new sheet should be inserted (0-based)",
"type": "number"
},
"newSheetName": {
"description": "The name for the duplicated sheet",
"type": "string"
},
"sheetId": {
"description": "The ID of the sheet to duplicate (use sheets_get_metadata to find sheet IDs)",
"type": "number"
},
"spreadsheetId": {
"description": "The ID of the spreadsheet (found in the URL after /d/)",
"type": "string"
}
},
"required": [
"spreadsheetId",
"sheetId"
],
"type": "object"
}