Skip to main content
Glama

google-sheets-mcp

update_table_sorting_tool

Sorts all data rows in a Google Sheets table by a specified column while keeping the header row intact. Supports ascending ('ASC') or descending ('DESC') order. Ideal for organizing and managing table data efficiently.

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

NameRequiredDescriptionDefault
column_nameYesName of the column to sort by
sheet_nameYesThe name of the sheet containing the table
sort_orderNoSort order: 'ASC' or 'DESC' (default: 'ASC')ASC
spreadsheet_nameYesThe name of the Google Spreadsheet
table_nameYesName 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" }

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/henilcalagiya/google-sheets-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server