Google Super
GOOGLESUPER_DELETE_DIMENSION
Tool to delete specified rows or columns from a sheet in a Google Spreadsheet. Use when you need to remove a range of rows or columns.
Remote googlesuper
Other tools also called GOOGLESUPER_DELETE_DIMENSION?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"spreadsheet_id": {
"type": "string",
"title": "Spreadsheet Id",
"examples": [
"abc123xyz789"
],
"description": "The ID of the spreadsheet."
},
"response_ranges": {
"type": "array",
"items": {
"type": "string",
"properties": {}
},
"title": "Response Ranges",
"default": null,
"examples": [
[
"Sheet1!A1:B2",
"Sheet2!C:C"
]
],
"nullable": true,
"description": "Limits the ranges of cells included in the response spreadsheet."
},
"delete_dimension_request": {
"type": "object",
"title": "Delete Dimension Request",
"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,
123456789
],
"description": "The ID of the sheet from which to delete the dimension."
},
"dimension": {
"enum": [
"ROWS",
"COLUMNS"
],
"type": "string",
"title": "Dimension",
"examples": [
"ROWS",
"COLUMNS"
],
"description": "The dimension to delete."
},
"end_index": {
"type": "integer",
"title": "End Index",
"examples": [
1,
10
],
"description": "The zero-based end index of the range to delete, exclusive. The end index must be greater than the start index.",
"exclusiveMinimum": 0
},
"start_index": {
"type": "integer",
"title": "Start Index",
"minimum": 0,
"examples": [
0,
5
],
"description": "The zero-based start index of the range to delete, inclusive. The start index must be less than the end index."
}
},
"description": "The range of the dimension to delete.",
"additionalProperties": false
}
},
"description": "The details for the delete dimension request object.",
"additionalProperties": false
},
"response_include_grid_data": {
"type": "boolean",
"title": "Response Include Grid Data",
"default": null,
"examples": [
true,
false
],
"nullable": true,
"description": "True if grid data should be returned. This parameter is ignored if a field mask was set in the request."
},
"include_spreadsheet_in_response": {
"type": "boolean",
"title": "Include Spreadsheet In Response",
"default": null,
"examples": [
true,
false
],
"nullable": true,
"description": "Determines if the update response should include the spreadsheet resource."
}
}
}