Google Super
GOOGLESUPER_INSERT_DIMENSION
Tool to insert new rows or columns into a sheet at a specified location. Use when you need to add empty rows or columns within an existing Google Sheet.
Remote googlesuper
Other tools also called GOOGLESUPER_INSERT_DIMENSION?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"spreadsheet_id": {
"type": "string",
"title": "Spreadsheet Id",
"examples": [
"abc123spreadsheetId"
],
"description": "The ID of the spreadsheet to update."
},
"response_ranges": {
"type": "array",
"items": {
"type": "string",
"properties": {}
},
"title": "Response Ranges",
"default": null,
"nullable": true,
"description": "Limits the ranges of the spreadsheet to include in the response."
},
"insert_dimension": {
"type": "object",
"title": "Insert Dimension",
"required": [
"range"
],
"properties": {
"range": {
"type": "object",
"title": "Range",
"required": [
"sheet_id",
"dimension",
"start_index",
"end_index"
],
"properties": {
"sheet_id": {
"type": "integer",
"title": "Sheet Id",
"examples": [
0
],
"description": "The ID of the sheet where the dimensions will be inserted."
},
"dimension": {
"enum": [
"ROWS",
"COLUMNS"
],
"type": "string",
"title": "Dimension",
"examples": [
"ROWS"
],
"description": "The dimension to insert. Valid values are \"ROWS\" or \"COLUMNS\"."
},
"end_index": {
"type": "integer",
"title": "End Index",
"examples": [
3
],
"description": "The end index (0-based, exclusive) of the dimension range to insert. The number of rows/columns to insert is `endIndex - startIndex`."
},
"start_index": {
"type": "integer",
"title": "Start Index",
"examples": [
1
],
"description": "The start index (0-based) of the dimension range to insert. The inserted dimensions will be placed before this index."
}
},
"description": "Specifies the dimensions to insert.",
"additionalProperties": false
},
"inherit_from_before": {
"type": "boolean",
"title": "Inherit From Before",
"default": null,
"examples": [
true
],
"nullable": true,
"description": "If true, the new dimensions will inherit properties from the dimension before the startIndex. If false (default), they will inherit from the dimension at the startIndex. startIndex must be greater than 0 if inheritFromBefore is true."
}
},
"description": "The details for the insert dimension request.",
"additionalProperties": false
},
"response_include_grid_data": {
"type": "boolean",
"title": "Response Include Grid Data",
"default": null,
"nullable": true,
"description": "True if grid data should be included in the response (if includeSpreadsheetInResponse is true)."
},
"include_spreadsheet_in_response": {
"type": "boolean",
"title": "Include Spreadsheet In Response",
"default": null,
"nullable": true,
"description": "True if the updated spreadsheet should be included in the response."
}
}
}