Mcp Google Sheets

@xing5

About Mcp Google Sheets

This MCP server integrates with your Google Drive and Google Sheets, to enable creating and modifying spreadsheets.

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp-google-sheets": {
      "command": "uvx",
      "args": [
        "mcp-google-sheets@latest"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is mcp-google-sheets?

mcp-google-sheets is a Python-based MCP server that acts as a bridge between any MCP‑compatible client (like Claude Desktop) and the Google Sheets API. It enables AI‑driven automation and data manipulation on Google Spreadsheets through a defined set of tools.

How to use mcp-google-sheets?

Install uv, set the environment variables SERVICE_ACCOUNT_PATH and DRIVE_FOLDER_ID with your Google Cloud service‑account credentials, then run uvx mcp-google-sheets@latest. Configure your MCP client (e.g., Claude Desktop) to connect to the server, optionally using tool filtering with --include-tools or ENABLED_TOOLS to reduce context usage.

Key features of mcp-google-sheets

Seamless integration with Google Drive & Sheets APIs
19 comprehensive tools (CRUD, listing, batching, sharing, formatting)
Flexible authentication: Service Accounts, OAuth 2.0, or credential injection
Zero‑install deployment via uvx
AI‑ready for natural‑language spreadsheet interaction
Tool filtering to reduce context window consumption

Use cases of mcp-google-sheets

Automate spreadsheet creation, reading, and updating from an AI assistant
Manage multiple spreadsheets and sheets (list, search, copy, rename)
Batch update cells across multiple ranges in a single API call
Share spreadsheets and control access programmatically
Retrieve cell formulas and grid data for advanced analysis

FAQ from mcp-google-sheets

What tools does mcp-google-sheets provide?

It provides 19 tools including get_sheet_data, update_cells, list_spreadsheets, list_sheets, create_spreadsheet, batch_update_cells, add_rows, share_spreadsheet, and more. See the full list in the README.

Do I need a Google Cloud Platform setup?

Yes. You must configure Google Cloud credentials (service account recommended) and enable the Google Sheets and Drive APIs before running the server.

How can I reduce the context usage of the server?

Use tool filtering via the --include-tools command‑line argument or the ENABLED_TOOLS environment variable to enable only the tools you need. By default, all 19 tools are exposed (~13K tokens).

How do I authenticate with Google Sheets?

Authentication is done through environment variables. The recommended method is to set SERVICE_ACCOUNT_PATH pointing to a service‑account key JSON file and DRIVE_FOLDER_ID. Alternative methods include OAuth 2.0 and inline credential configuration via CREDENTIALS_CONFIG.

Where does the data live?

Data stays in your Google Drive and Sheets. The server acts only as a bridge; it does not store any spreadsheet data itself. All operations are performed through the official Google Sheets API.

Frequently asked questions

What tools does mcp-google-sheets provide?

It provides 19 tools including `get_sheet_data`, `update_cells`, `list_spreadsheets`, `list_sheets`, `create_spreadsheet`, `batch_update_cells`, `add_rows`, `share_spreadsheet`, and more. See the full list in the README.

Do I need a Google Cloud Platform setup?

Yes. You must configure Google Cloud credentials (service account recommended) and enable the Google Sheets and Drive APIs before running the server.

How can I reduce the context usage of the server?

Use tool filtering via the `--include-tools` command‑line argument or the `ENABLED_TOOLS` environment variable to enable only the tools you need. By default, all 19 tools are exposed (~13K tokens).

How do I authenticate with Google Sheets?

Authentication is done through environment variables. The recommended method is to set `SERVICE_ACCOUNT_PATH` pointing to a service‑account key JSON file and `DRIVE_FOLDER_ID`. Alternative methods include OAuth 2.0 and inline credential configuration via `CREDENTIALS_CONFIG`.

Where does the data live?

Data stays in your Google Drive and Sheets. The server acts only as a bridge; it does not store any spreadsheet data itself. All operations are performed through the official Google Sheets API.