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.
sheet_idintegerThe unique numeric ID of the sheet (not the index/position). This ID is assigned by Google Sheets and does not change when sheets are reordered. Use GOOGLESHEETS_GET_SPREADSHEET_INFO to find the sheet ID, or use sheet_name instead. Either sheet_id or sheet_name must be provided.
dimensionstringThe dimension to delete (ROWS or COLUMNS).
end_indexintegerThe zero-based end index of the range to delete, exclusive. Must be greater than start_index and at most equal to the sheet's current row/column count. Note: Cannot delete all rows or columns from a sheet - at least one row and one column must remain.
sheet_namestringThe name/title of the sheet from which to delete the dimension. Using sheet_name is recommended as it's more intuitive than sheet_id. Either sheet_id or sheet_name must be provided.
start_indexintegerThe zero-based start index of the range to delete, inclusive. Must be less than end_index and within the sheet's current row/column count. Note: Cannot delete all rows or columns from a sheet - at least one row and one column must remain.
spreadsheet_idRequiredstringThe ID of the spreadsheet.
response_rangesarrayLimits the ranges of cells included in the response spreadsheet.
delete_dimension_requestobjectThe details for the delete dimension request object.
response_include_grid_databooleanTrue if grid data should be returned. This parameter is ignored if a field mask was set in the request.
include_spreadsheet_in_responsebooleanDetermines if the update response should include the spreadsheet resource.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
OAuth connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.