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
TableJSON 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 |