Google Sheets
GOOGLESHEETS_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 googlesheets
Other tools also called GOOGLESHEETS_DELETE_DIMENSION?
See providers with this name
Input Schema
{
"type": "object",
"properties": {
"spreadsheet_id": {
"type": "string",
"description": "The ID of the spreadsheet.\nExample: \"abc123xyz789\""
},
"response_ranges": {
"anyOf": [
{
"type": "array",
"items": {
"type": "string"
}
},
{
"type": "null"
}
],
"default": null,
"description": "Limits the ranges of cells included in the response spreadsheet.\nExample: [\"Sheet1!A1:B2\",\"Sheet2!C:C\"]"
},
"delete_dimension_request": {
"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 from which to delete the dimension.\nExamples:\n 0\n 123456789"
},
"dimension": {
"enum": [
"ROWS",
"COLUMNS"
],
"type": "string",
"description": "The dimension to delete.\nExamples:\n \"ROWS\"\n \"COLUMNS\""
},
"end_index": {
"type": "integer",
"description": "The zero-based end index of the range to delete, exclusive. The end index must be greater than the start index.\nExamples:\n 1\n 10",
"exclusiveMinimum": 0
},
"start_index": {
"type": "integer",
"minimum": 0,
"description": "The zero-based start index of the range to delete, inclusive. The start index must be less than the end index.\nExamples:\n 0\n 5"
}
},
"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",
"null"
],
"default": null,
"description": "True if grid data should be returned. This parameter is ignored if a field mask was set in the request.\nExamples:\n true\n false"
},
"include_spreadsheet_in_response": {
"type": [
"boolean",
"null"
],
"default": null,
"description": "Determines if the update response should include the spreadsheet resource.\nExamples:\n true\n false"
}
}
}