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"
}