google-sheets-mcp

Get values from specific cells in a sheet. This tool retrieves values from multiple cells in a sheet using A1 notation. Args: spreadsheet_name: Name of the spreadsheet sheet_name: Name of the sheet to get cells from cell_notations: List of cell notations to get values from (e.g., ['A1', 'A6', 'A10', 'E5']) Returns: JSON string with cell values and mapping

{ "properties": { "cell_notations": { "description": "List of cell notations to get values from (e.g., ['A1', 'A6', 'A10', 'E5'])", "items": { "type": "string" }, "title": "Cell Notations", "type": "array" }, "sheet_name": { "description": "The name of the sheet to get cells from", "title": "Sheet Name", "type": "string" }, "spreadsheet_name": { "description": "The name of the Google Spreadsheet", "title": "Spreadsheet Name", "type": "string" } }, "required": [ "spreadsheet_name", "sheet_name", "cell_notations" ], "title": "get_sheet_cells_by_notation_toolArguments", "type": "object" }