google-sheets-mcp

Get sheet cells by range. This tool retrieves cell data from a specific range within a sheet. You can specify the exact cell range using A1 notation. Args: spreadsheet_name: Name of the spreadsheet sheet_name: Name of the sheet to get cells from start_cell: Starting cell reference (e.g., 'A1', 'B2') end_cell: Ending cell reference (e.g., 'C5', 'D10') include_headers: Whether to include header row Returns: JSON string with cells data and metadata

{ "properties": { "end_cell": { "description": "Ending cell reference (e.g., 'C5', 'D10')", "title": "End Cell", "type": "string" }, "include_headers": { "default": false, "description": "Whether to include header row (default: False)", "title": "Include Headers", "type": "boolean" }, "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" }, "start_cell": { "description": "Starting cell reference (e.g., 'A1', 'B2')", "title": "Start Cell", "type": "string" } }, "required": [ "spreadsheet_name", "sheet_name", "start_cell", "end_cell" ], "title": "get_sheet_cells_by_range_toolArguments", "type": "object" }