Google Sheets

@xing5 · github.com/xing5/mcp-google-sheets

A Model Context Protocol server for interacting with Google Sheets. This server provides tools to create, read, update, and manage spreadsheets through the Google Sheets API.

ClaimedWeb & APIsSSElocal auth

GitHub

Install one command

terminal

$ uvx mcp-google-sheets@latest

Or add it with the Claude CLI: claude mcp add xing5-mcp-google-sheets

Requires uvx (install via pip install uv)

Tools exposed 20 tools

enabled_tools

get_sheet_data

update_cells

list_spreadsheets

list_sheets

add_columns

add_rows

batch_update

batch_update_cells

copy_sheet

create_sheet

create_spreadsheet

find_in_spreadsheet

get_multiple_sheet_data

get_sheet_formulas

list_folders

rename_sheet

search_spreadsheets

share_spreadsheet

folder_id

Configuration claude_desktop_config.json

claude_desktop_config.json

{
  "mcpServers": {
    "xing5-mcp-google-sheets": {
      "command": "uvx",
      "args": ["mcp-google-sheets@latest"],
      "env": {
        "SERVICE_ACCOUNT_PATH": "<your-service-account-path>",
        "DRIVE_FOLDER_ID": "<your-drive-folder-id>",
        "YOUR_DRIVE_FOLDER_ID": "<your-your-drive-folder-id>",
        "CREDENTIALS_CONFIG": "<your-credentials-config>",
        "ENABLED_TOOLS": "<your-enabled-tools>",
        "CREDENTIALS_PATH": "<your-credentials-path>",
        "TOKEN_PATH": "<your-token-path>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<your-google-application-credentials>",
        "YOUR_BASE64_CREDENTIALS": "<your-your-base64-credentials>"
      }
    }
  }
}

Paste under mcpServers in your config, then restart Claude Desktop. For Claude Code, reference this server in your project's CLAUDE.md.

Google Sheets

Install one command

Tools exposed 20 tools

Configuration claude_desktop_config.json

Similar servers