google-sheets-mcp

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

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