sheets_insert_sheet
Add a new sheet to a Google Sheets spreadsheet by specifying its title, position, and dimensions. Requires the spreadsheet ID for integration.
Instructions
Add a new sheet to an existing Google Sheets spreadsheet
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| columnCount | No | Number of columns in the sheet (default: 26) | |
| index | No | The index where the sheet should be inserted (0-based) | |
| rowCount | No | Number of rows in the sheet (default: 1000) | |
| spreadsheetId | Yes | The ID of the spreadsheet (found in the URL after /d/) | |
| title | Yes | The title of the new sheet |
Input Schema (JSON Schema)
{
"properties": {
"columnCount": {
"description": "Number of columns in the sheet (default: 26)",
"type": "number"
},
"index": {
"description": "The index where the sheet should be inserted (0-based)",
"type": "number"
},
"rowCount": {
"description": "Number of rows in the sheet (default: 1000)",
"type": "number"
},
"spreadsheetId": {
"description": "The ID of the spreadsheet (found in the URL after /d/)",
"type": "string"
},
"title": {
"description": "The title of the new sheet",
"type": "string"
}
},
"required": [
"spreadsheetId",
"title"
],
"type": "object"
}