Google Sheets
GOOGLESHEETS_ADD_SHEET
Adds a new sheet (worksheet) to a spreadsheet. Use this tool to create a new tab within an existing Google Sheet, optionally specifying its title, index, size, and other properties. IMPORTANT: - Always provide the spreadsheetId. Use 'Search Spreadsheets' action if you need to find it by name - Sheet names must be unique within the spreadsheet - For tab colors, use EITHER rgbColor OR themeColor, never both - Index must be less than or equal to the current number of sheets - CONCURRENCY WARNING: Do not use 'index' when creating multiple sheets in parallel - this causes 'index is too high' errors. For parallel creation, omit the index field and let sheets be added at the end Common use cases: - Add a new sheet with a specific name - Insert a sheet at a specific position - Create a sheet with custom colors and formatting
Remote googlesheets
Other tools also called GOOGLESHEETS_ADD_SHEET?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"properties": {
"anyOf": [
{
"type": "object",
"properties": {
"index": {
"anyOf": [
{
"type": "integer",
"minimum": 0
},
{
"type": "null"
}
],
"default": null,
"description": "The zero-based index where the sheet should be inserted. Must be less than or equal to the current number of sheets. If not set, the sheet will be added at the end. Example: 0 for the first position. CONCURRENCY WARNING: Do not use 'index' when creating multiple sheets in parallel - this causes 'index is too high' errors. For parallel creation, omit this field and let sheets be added at the end."
},
"title": {
"type": [
"string",
"null"
],
"default": null,
"description": "The name of the sheet. Must be unique within the spreadsheet. Example: \"Q3 Report\", \"Sales Data 2025\""
},
"hidden": {
"type": [
"boolean",
"null"
],
"default": null,
"description": "True if the sheet is hidden in the UI, false if it's visible."
},
"sheetId": {
"anyOf": [
{
"type": "integer",
"minimum": 0
},
{
"type": "null"
}
],
"default": null,
"description": "The ID of the sheet. If not set, an ID will be randomly generated. Must be non-negative and unique within the spreadsheet. WARNING: Avoid setting this unless you need a specific ID."
},
"sheetType": {
"anyOf": [
{
"enum": [
"GRID",
"OBJECT",
"DATA_SOURCE"
],
"type": "string"
},
{
"type": "null"
}
],
"default": "GRID",
"description": "The type of sheet."
},
"rightToLeft": {
"type": [
"boolean",
"null"
],
"default": null,
"description": "True if the sheet is an RTL sheet, false if it's LTR."
},
"tabColorStyle": {
"anyOf": [
{
"type": "object",
"properties": {
"rgbColor": {
"anyOf": [
{
"type": "object",
"properties": {
"red": {
"anyOf": [
{
"type": "number",
"maximum": 1,
"minimum": 0
},
{
"type": "null"
}
],
"default": null,
"description": "The amount of red in the color as a value in the interval [0, 1]."
},
"blue": {
"anyOf": [
{
"type": "number",
"maximum": 1,
"minimum": 0
},
{
"type": "null"
}
],
"default": null,
"description": "The amount of blue in the color as a value in the interval [0, 1]."
},
"alpha": {
"anyOf": [
{
"type": "number",
"maximum": 1,
"minimum": 0
},
{
"type": "null"
}
],
"default": null,
"description": "The fraction of this color that should be applied to the pixel. E.g. 0.5 for 50% transparent."
},
"green": {
"anyOf": [
{
"type": "number",
"maximum": 1,
"minimum": 0
},
{
"type": "null"
}
],
"default": null,
"description": "The amount of green in the color as a value in the interval [0, 1]."
}
},
"additionalProperties": false
},
{
"type": "null"
}
],
"default": null,
"description": "RGB color. Specify EITHER rgbColor OR themeColor, but not both. If using rgbColor, provide values for red, green, blue (0.0-1.0)."
},
"themeColor": {
"anyOf": [
{
"enum": [
"THEME_COLOR_TYPE_UNSPECIFIED",
"TEXT",
"BACKGROUND",
"ACCENT1",
"ACCENT2",
"ACCENT3",
"ACCENT4",
"ACCENT5",
"ACCENT6",
"LINK"
],
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"description": "Theme color. Specify EITHER themeColor OR rgbColor, but not both. Use predefined theme colors like ACCENT1, TEXT, BACKGROUND, etc."
}
},
"additionalProperties": false
},
{
"type": "null"
}
],
"default": null,
"description": "The color of the sheet tab."
},
"gridProperties": {
"anyOf": [
{
"type": "object",
"properties": {
"rowCount": {
"anyOf": [
{
"type": "integer",
"minimum": 0
},
{
"type": "null"
}
],
"default": null,
"description": "The number of rows in the sheet."
},
"columnCount": {
"anyOf": [
{
"type": "integer",
"minimum": 0
},
{
"type": "null"
}
],
"default": null,
"description": "The number of columns in the sheet."
},
"hideGridlines": {
"type": [
"boolean",
"null"
],
"default": null,
"description": "True if the gridlines are hidden, false if they are shown."
},
"frozenRowCount": {
"anyOf": [
{
"type": "integer",
"minimum": 0
},
{
"type": "null"
}
],
"default": null,
"description": "The number of rows that are frozen in the sheet."
},
"frozenColumnCount": {
"anyOf": [
{
"type": "integer",
"minimum": 0
},
{
"type": "null"
}
],
"default": null,
"description": "The number of columns that are frozen in the sheet."
},
"rowGroupControlAfter": {
"type": [
"boolean",
"null"
],
"default": null,
"description": "True if the row group control toggle is shown after the group, false if before."
},
"columnGroupControlAfter": {
"type": [
"boolean",
"null"
],
"default": null,
"description": "True if the column group control toggle is shown after the group, false if before."
}
},
"additionalProperties": false
},
{
"type": "null"
}
],
"default": null,
"description": "Additional properties of the sheet if it's a grid sheet."
}
},
"additionalProperties": false
},
{
"type": "null"
}
],
"default": null,
"description": "The properties the new sheet should have. All properties are optional. If none are specified, a default sheet will be created."
},
"spreadsheetId": {
"type": "string",
"description": "The ID of the spreadsheet to add the sheet to. This is the long string of characters in the URL of your Google Sheet. Use the 'Search Spreadsheets' action first to find the spreadsheet ID by name if you don't have it.\nExample: \"1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms\""
}
}
}