{"name":"Google Spreadsheet","version":"1.14.1","protocol":"2025-06-18","transport":{"type":"sse","url":"https://sheetsmcp.wifigo.com.mx/sse","messages":"https://sheetsmcp.wifigo.com.mx/messages/"},"tools":[{"name":"get_sheet_data","description":"\n    Get data from a specific sheet in a Google Spreadsheet.\n    \n    Args:\n        spreadsheet_id: The ID of the spreadsheet (found in the URL)\n        sheet: The name of the sheet\n        range: Optional cell range in A1 notation (e.g., 'A1:C10'). If not provided, gets all data.\n        include_grid_data: If True, includes cell formatting and other metadata in the response.\n            Note: Setting this to True will significantly increase the response size and token usage\n            when parsing the response, as it includes detailed cell formatting information.\n            Default is False (returns values only, more efficient).\n    \n    Returns:\n        Grid data structure with either full metadata or just values from Google Sheets API, depending on include_grid_data parameter\n    ","inputSchema":{"properties":{"spreadsheet_id":{"title":"Spreadsheet Id","type":"string"},"sheet":{"title":"Sheet","type":"string"},"range":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"title":"Range"},"include_grid_data":{"default":false,"title":"Include Grid Data","type":"boolean"}},"required":["spreadsheet_id","sheet"],"title":"get_sheet_dataArguments","type":"object"}},{"name":"get_sheet_formulas","description":"\n    Get formulas from a specific sheet in a Google Spreadsheet.\n    \n    Args:\n        spreadsheet_id: The ID of the spreadsheet (found in the URL)\n        sheet: The name of the sheet\n        range: Optional cell range in A1 notation (e.g., 'A1:C10'). If not provided, gets all formulas from the sheet.\n    \n    Returns:\n        A 2D array of the sheet formulas.\n    ","inputSchema":{"properties":{"spreadsheet_id":{"title":"Spreadsheet Id","type":"string"},"sheet":{"title":"Sheet","type":"string"},"range":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"title":"Range"}},"required":["spreadsheet_id","sheet"],"title":"get_sheet_formulasArguments","type":"object"}},{"name":"update_cells","description":"\n    Update cells in a Google Spreadsheet.\n    \n    Args:\n        spreadsheet_id: The ID of the spreadsheet (found in the URL)\n        sheet: The name of the sheet\n        range: Cell range in A1 notation (e.g., 'A1:C10')\n        data: 2D array of values to update\n    \n    Returns:\n        Result of the update operation\n    ","inputSchema":{"properties":{"spreadsheet_id":{"title":"Spreadsheet Id","type":"string"},"sheet":{"title":"Sheet","type":"string"},"range":{"title":"Range","type":"string"},"data":{"items":{"items":{},"type":"array"},"title":"Data","type":"array"}},"required":["spreadsheet_id","sheet","range","data"],"title":"update_cellsArguments","type":"object"}},{"name":"batch_update_cells","description":"\n    Batch update multiple ranges in a Google Spreadsheet.\n    \n    Args:\n        spreadsheet_id: The ID of the spreadsheet (found in the URL)\n        sheet: The name of the sheet\n        ranges: Dictionary mapping range strings to 2D arrays of values\n               e.g., {'A1:B2': [[1, 2], [3, 4]], 'D1:E2': [['a', 'b'], ['c', 'd']]}\n    \n    Returns:\n        Result of the batch update operation\n    ","inputSchema":{"properties":{"spreadsheet_id":{"title":"Spreadsheet Id","type":"string"},"sheet":{"title":"Sheet","type":"string"},"ranges":{"additionalProperties":{"items":{"items":{},"type":"array"},"type":"array"},"title":"Ranges","type":"object"}},"required":["spreadsheet_id","sheet","ranges"],"title":"batch_update_cellsArguments","type":"object"}},{"name":"add_rows","description":"\n    Add rows to a sheet in a Google Spreadsheet.\n    \n    Args:\n        spreadsheet_id: The ID of the spreadsheet (found in the URL)\n        sheet: The name of the sheet\n        count: Number of rows to add\n        start_row: 0-based row index to start adding. If not provided, adds at the beginning.\n    \n    Returns:\n        Result of the operation\n    ","inputSchema":{"properties":{"spreadsheet_id":{"title":"Spreadsheet Id","type":"string"},"sheet":{"title":"Sheet","type":"string"},"count":{"title":"Count","type":"integer"},"start_row":{"anyOf":[{"type":"integer"},{"type":"null"}],"default":null,"title":"Start Row"}},"required":["spreadsheet_id","sheet","count"],"title":"add_rowsArguments","type":"object"}},{"name":"add_columns","description":"\n    Add columns to a sheet in a Google Spreadsheet.\n    \n    Args:\n        spreadsheet_id: The ID of the spreadsheet (found in the URL)\n        sheet: The name of the sheet\n        count: Number of columns to add\n        start_column: 0-based column index to start adding. If not provided, adds at the beginning.\n    \n    Returns:\n        Result of the operation\n    ","inputSchema":{"properties":{"spreadsheet_id":{"title":"Spreadsheet Id","type":"string"},"sheet":{"title":"Sheet","type":"string"},"count":{"title":"Count","type":"integer"},"start_column":{"anyOf":[{"type":"integer"},{"type":"null"}],"default":null,"title":"Start Column"}},"required":["spreadsheet_id","sheet","count"],"title":"add_columnsArguments","type":"object"}},{"name":"list_sheets","description":"\n    List all sheets in a Google Spreadsheet.\n    \n    Args:\n        spreadsheet_id: The ID of the spreadsheet (found in the URL)\n    \n    Returns:\n        List of sheet names\n    ","inputSchema":{"properties":{"spreadsheet_id":{"title":"Spreadsheet Id","type":"string"}},"required":["spreadsheet_id"],"title":"list_sheetsArguments","type":"object"}},{"name":"copy_sheet","description":"\n    Copy a sheet from one spreadsheet to another.\n    \n    Args:\n        src_spreadsheet: Source spreadsheet ID\n        src_sheet: Source sheet name\n        dst_spreadsheet: Destination spreadsheet ID\n        dst_sheet: Destination sheet name\n    \n    Returns:\n        Result of the operation\n    ","inputSchema":{"properties":{"src_spreadsheet":{"title":"Src Spreadsheet","type":"string"},"src_sheet":{"title":"Src Sheet","type":"string"},"dst_spreadsheet":{"title":"Dst Spreadsheet","type":"string"},"dst_sheet":{"title":"Dst Sheet","type":"string"}},"required":["src_spreadsheet","src_sheet","dst_spreadsheet","dst_sheet"],"title":"copy_sheetArguments","type":"object"}},{"name":"rename_sheet","description":"\n    Rename a sheet in a Google Spreadsheet.\n    \n    Args:\n        spreadsheet: Spreadsheet ID\n        sheet: Current sheet name\n        new_name: New sheet name\n    \n    Returns:\n        Result of the operation\n    ","inputSchema":{"properties":{"spreadsheet":{"title":"Spreadsheet","type":"string"},"sheet":{"title":"Sheet","type":"string"},"new_name":{"title":"New Name","type":"string"}},"required":["spreadsheet","sheet","new_name"],"title":"rename_sheetArguments","type":"object"}},{"name":"get_multiple_sheet_data","description":"\n    Get data from multiple specific ranges in Google Spreadsheets.\n    \n    Args:\n        queries: A list of dictionaries, each specifying a query. \n                 Each dictionary should have 'spreadsheet_id', 'sheet', and 'range' keys.\n                 Example: [{'spreadsheet_id': 'abc', 'sheet': 'Sheet1', 'range': 'A1:B5'}, \n                           {'spreadsheet_id': 'xyz', 'sheet': 'Data', 'range': 'C1:C10'}]\n    \n    Returns:\n        A list of dictionaries, each containing the original query parameters \n        and the fetched 'data' or an 'error'.\n    ","inputSchema":{"properties":{"queries":{"items":{"additionalProperties":{"type":"string"},"type":"object"},"title":"Queries","type":"array"}},"required":["queries"],"title":"get_multiple_sheet_dataArguments","type":"object"}},{"name":"get_multiple_spreadsheet_summary","description":"\n    Get a summary of multiple Google Spreadsheets, including sheet names, \n    headers, and the first few rows of data for each sheet.\n    \n    Args:\n        spreadsheet_ids: A list of spreadsheet IDs to summarize.\n        rows_to_fetch: The number of rows (including header) to fetch for the summary (default: 5).\n    \n    Returns:\n        A list of dictionaries, each representing a spreadsheet summary. \n        Includes spreadsheet title, sheet summaries (title, headers, first rows), or an error.\n    ","inputSchema":{"properties":{"spreadsheet_ids":{"items":{"type":"string"},"title":"Spreadsheet Ids","type":"array"},"rows_to_fetch":{"default":5,"title":"Rows To Fetch","type":"integer"}},"required":["spreadsheet_ids"],"title":"get_multiple_spreadsheet_summaryArguments","type":"object"}},{"name":"create_spreadsheet","description":"\n    Create a new Google Spreadsheet.\n    \n    Args:\n        title: The title of the new spreadsheet\n    \n    Returns:\n        Information about the newly created spreadsheet including its ID\n    ","inputSchema":{"properties":{"title":{"title":"Title","type":"string"}},"required":["title"],"title":"create_spreadsheetArguments","type":"object"}},{"name":"create_sheet","description":"\n    Create a new sheet tab in an existing Google Spreadsheet.\n    \n    Args:\n        spreadsheet_id: The ID of the spreadsheet\n        title: The title for the new sheet\n    \n    Returns:\n        Information about the newly created sheet\n    ","inputSchema":{"properties":{"spreadsheet_id":{"title":"Spreadsheet Id","type":"string"},"title":{"title":"Title","type":"string"}},"required":["spreadsheet_id","title"],"title":"create_sheetArguments","type":"object"}},{"name":"list_spreadsheets","description":"\n    List all spreadsheets in the configured Google Drive folder.\n    If no folder is configured, lists spreadsheets from 'My Drive'.\n    \n    Returns:\n        List of spreadsheets with their ID and title\n    ","inputSchema":{"properties":{},"title":"list_spreadsheetsArguments","type":"object"}},{"name":"share_spreadsheet","description":"\n    Share a Google Spreadsheet with multiple users via email, assigning specific roles.\n    \n    Args:\n        spreadsheet_id: The ID of the spreadsheet to share.\n        recipients: A list of dictionaries, each containing 'email_address' and 'role'.\n                    The role should be one of: 'reader', 'commenter', 'writer'.\n                    Example: [\n                        {'email_address': 'user1@example.com', 'role': 'writer'},\n                        {'email_address': 'user2@example.com', 'role': 'reader'}\n                    ]\n        send_notification: Whether to send a notification email to the users. Defaults to True.\n\n    Returns:\n        A dictionary containing lists of 'successes' and 'failures'. \n        Each item in the lists includes the email address and the outcome.\n    ","inputSchema":{"properties":{"spreadsheet_id":{"title":"Spreadsheet Id","type":"string"},"recipients":{"items":{"additionalProperties":{"type":"string"},"type":"object"},"title":"Recipients","type":"array"},"send_notification":{"default":true,"title":"Send Notification","type":"boolean"}},"required":["spreadsheet_id","recipients"],"title":"share_spreadsheetArguments","type":"object"}}],"dependencies":["google-auth","google-auth-oauthlib","google-api-python-client"],"capabilities":{"experimental":{},"prompts":{"listChanged":false},"resources":{"subscribe":false,"listChanged":false},"tools":{"listChanged":false}}}