Google Sheets
GOOGLESHEETS_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 googlesheets
Other tools also called GOOGLESHEETS_INSERT_DIMENSION?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"spreadsheet_id": {
"type": "string",
"description": "The ID of the spreadsheet to update.\nExample: \"abc123spreadsheetId\""
},
"response_ranges": {
"anyOf": [
{
"type": "array",
"items": {
"type": "string"
}
},
{
"type": "null"
}
],
"default": null,
"description": "Limits the ranges of the spreadsheet to include in the response."
},
"insert_dimension": {
"type": "object",
"required": [
"range"
],
"properties": {
"range": {
"type": "object",
"required": [
"dimension",
"end_index",
"sheet_id",
"start_index"
],
"properties": {
"sheet_id": {
"type": "integer",
"description": "The ID of the sheet where the dimensions will be inserted.\nExample: 0"
},
"dimension": {
"enum": [
"ROWS",
"COLUMNS"
],
"type": "string",
"description": "The dimension to insert. Valid values are \"ROWS\" or \"COLUMNS\".\nExample: \"ROWS\""
},
"end_index": {
"type": "integer",
"description": "The end index (0-based, exclusive) of the dimension range to insert. The number of rows/columns to insert is `endIndex - startIndex`.\nExample: 3"
},
"start_index": {
"type": "integer",
"description": "The start index (0-based) of the dimension range to insert. The inserted dimensions will be placed before this index.\nExample: 1"
}
},
"description": "Specifies the dimensions to insert.",
"additionalProperties": false
},
"inherit_from_before": {
"type": [
"boolean",
"null"
],
"default": null,
"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.\nExample: true"
}
},
"description": "The details for the insert dimension request.",
"additionalProperties": false
},
"response_include_grid_data": {
"type": [
"boolean",
"null"
],
"default": null,
"description": "True if grid data should be included in the response (if includeSpreadsheetInResponse is true)."
},
"include_spreadsheet_in_response": {
"type": [
"boolean",
"null"
],
"default": null,
"description": "True if the updated spreadsheet should be included in the response."
}
}
}