update_table_sorting_tool
Sort table rows in Google Sheets by a specific column while keeping the header intact. Specify the spreadsheet, sheet, table, column, and sort order for precise data organization.
Instructions
Update table sorting by a specific column.
This tool sorts all data rows in a table based on a specified column.
The header row remains in place, and data rows are reordered.
Args:
spreadsheet_name: Name of the spreadsheet
sheet_name: Name of the sheet containing the table
table_name: Name of the table to sort
column_name: Name of the column to sort by
sort_order: Sort order - "ASC" or "DESC" (default: "ASC")
Returns:
JSON string with success status and sorting details
Input Schema
Name | Required | Description | Default |
---|---|---|---|
column_name | Yes | Name of the column to sort by | |
sheet_name | Yes | The name of the sheet containing the table | |
sort_order | No | Sort order: 'ASC' or 'DESC' (default: 'ASC') | ASC |
spreadsheet_name | Yes | The name of the Google Spreadsheet | |
table_name | Yes | Name of the table to sort |
Input Schema (JSON Schema)
{
"properties": {
"column_name": {
"description": "Name of the column to sort by",
"title": "Column Name",
"type": "string"
},
"sheet_name": {
"description": "The name of the sheet containing the table",
"title": "Sheet Name",
"type": "string"
},
"sort_order": {
"default": "ASC",
"description": "Sort order: 'ASC' or 'DESC' (default: 'ASC')",
"title": "Sort Order",
"type": "string"
},
"spreadsheet_name": {
"description": "The name of the Google Spreadsheet",
"title": "Spreadsheet Name",
"type": "string"
},
"table_name": {
"description": "Name of the table to sort",
"title": "Table Name",
"type": "string"
}
},
"required": [
"spreadsheet_name",
"sheet_name",
"table_name",
"column_name"
],
"title": "update_table_sorting_toolArguments",
"type": "object"
}