Google Sheets MCP

What it does

Connects an AI assistant to the Google Sheets and Drive APIs, allowing the AI to read, write, and manage spreadsheets. It enables complex data automation, from creating new reports to updating specific cell ranges using natural language.

Tools

• list_spreadsheets: Find accessible spreadsheets in a specific Drive folder.
• create_spreadsheet: Initialize a new spreadsheet with a custom title.
• get_sheet_data: Read values or formulas from a specified range using A1 notation.
• update_cells: Write data to a target range, overwriting existing content.
• batch_update_cells: Perform multiple range updates in a single API call.
• add_rows/add_columns: Insert empty space into sheets for data expansion.
• list_sheets: Get all tab names within a spreadsheet.
• share_spreadsheet: Manage collaborator access with specific roles (reader, writer).
• add_chart: Generate visual charts (COLUMN, BAR, LINE, etc.) from data ranges.

Installation

Add the following to your claude_desktop_config.json:

{
  "mcpServers": {
    "google-sheets": {
      "command": "uvx",
      "args": ["mcp-google-sheets@latest"],
      "env": {
        "SERVICE_ACCOUNT_PATH": "/path/to/your/service-account-key.json",
        "DRIVE_FOLDER_ID": "your_shared_folder_id_here"
      }
    }
  }
}

Supported hosts

• Claude Desktop