Log inSubmit server
MCP Google Sheets logo

MCP Google Sheets

by xing5

Connects MCP-compatible clients to Google Sheets for spreadsheet discovery, reading, writing, and sheet management.

InstallRepositoryWebsite
Full README Compare alternatives Embed widget Claim this listing

Install MCP Google Sheets

Pick your client, then add it in one click or paste the config.

STDIOPython
~/Library/Application Support/Claude/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_VALUE_HERE",
        "DRIVE_FOLDER_ID": "YOUR_VALUE_HERE",
        "CREDENTIALS_CONFIG": "YOUR_VALUE_HERE",
        "ENABLED_TOOLS": "YOUR_VALUE_HERE"
      }
    }
  }
}

Settings → Developer → Edit Config, merge this into mcpServers, then fully quit and reopen Claude Desktop.

Values are written into the snippet above so you can paste it as is. They never leave your browser.

We couldn’t confirm it starts correctly

The install command didn't complete successfully in our automated test.

uvx mcp-google-sheets@latest

Downloading cryptography (4.5MiB) Downloading google-api-python-client (16.0MiB) Downloading pydantic-core (2.0MiB) Downloaded pydantic-core Downloaded cryptography Downloaded google-api-python-client Installed 48 packages in 32ms Traceback (most recent call last): File "/home/user/.cache/uv/archive-v0/Ke_gnMJ3LeZdFxmK/bin/mcp-google-sheets", line 6, in <module> from mcp_google_sheets import main File "/home/user/.cache/uv/archive-v0/Ke_gnMJ3LeZdFxmK/lib/python3.11/site-packages/mcp_g

This is an experimental automated check and can have false negatives — missing environment variables, a slow cold install, etc. It doesn’t necessarily mean something’s wrong. Last checked 24d ago.

Overview

The xing5/mcp-google-sheets MCP server connects MCP-compatible clients with Google Sheets and Google Drive APIs. It exposes tools for finding and creating spreadsheets, reading ranges, writing cell values, and navigating sheet tabs. Run it with uvx, authenticate with a service account or supported OAuth configuration, and optionally filter the enabled tools. Reach for it when an agent needs to inspect or modify spreadsheet data through structured MCP calls.

Use cases

  • Find spreadsheets in a Drive folder
  • Read values from a selected sheet range
  • Update spreadsheet cells
  • Create spreadsheets and worksheet tabs
  • Filter exposed tools for smaller contexts

Key features

  • Google Sheets and Drive API access
  • Spreadsheet and sheet discovery
  • Range reads and cell updates
  • Spreadsheet and worksheet creation
  • Batch, search, formula, and sharing tools
  • Optional tool filtering

Tools4

What MCP Google Sheets lets your agent do. Expand a tool for its parameters.

Self-reported~32 tokens of context

Security & health

What it can reach and how reliably it runs — from our own checks, not the maintainer’s claims.

ActiveLast checked Today

Recent health check succeeded.

16/17 checks healthy over the last 77d

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 8d ago via OSV.dev · mcp-google-sheets@latest (PyPI)

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars1kStargazers on the source repository.
Last commit5mo agoMost recent push to the default branch.
Install checkInconclusiveInstall command did not finish in our automated test.
Tools exposed4Callable tools this server registers over MCP.
Directory activity3 viewsConfig copies, upvotes, and views on AllMCPs.

How MCP Google Sheets works

What xing5/mcp-google-sheets MCP server does

The xing5/mcp-google-sheets MCP server provides an MCP interface to Google Sheets and related Google Drive operations. It is implemented in Python and is intended to run behind an MCP-compatible client such as Claude Desktop. Agents can discover spreadsheets, inspect tabs and ranges, create spreadsheet files, and change spreadsheet contents through named tools rather than direct conversational instructions.

The commonly used tools are list_spreadsheets, list_sheets, get_sheet_data, and update_cells. The complete tool set also includes spreadsheet and sheet creation, row and column additions, copying and renaming sheets, formula retrieval, searches, batch updates, folder listing, spreadsheet summaries, and sharing operations.

How it works

The server communicates with the Google Sheets API and Google Drive API using the configured credentials. Spreadsheet and folder identifiers generally come from Google URLs or from discovery results. Reading can target a named tab and an optional A1-notation range, such as A1:C10. By default, reads return values; enabling grid data also returns formatting and metadata and produces a larger response.

A typical workflow is to list available spreadsheets, identify a spreadsheet ID, list its tabs, read a selected range, and then submit updates to cells. Spreadsheet creation accepts a title and can optionally place the new file in a specified Drive folder. Tool filtering is available when the client only needs a subset of the exposed operations.

Setup and configuration

The xing5/mcp-google-sheets MCP server can be launched with uvx mcp-google-sheets@latest. The README recommends configuring Google Cloud credentials and enabling the necessary APIs before starting it. A service account is the recommended authentication approach; the relevant setup uses SERVICE_ACCOUNT_PATH for the JSON key and DRIVE_FOLDER_ID for a default Drive folder.

The project also documents OAuth 2.0 and direct credential injection through CREDENTIALS_CONFIG. After starting the process, configure the MCP client to launch or connect to it. Claude Desktop is shown as an example client. Tool exposure can be restricted with the --include-tools argument or the ENABLED_TOOLS environment variable, using comma-separated tool names without spaces.

Tools and capabilities

Available operations include:

  • Finding spreadsheets with list_spreadsheets or search_spreadsheets.
  • Creating spreadsheets and sheets with create_spreadsheet and create_sheet.
  • Reading one or more ranges with get_sheet_data and get_multiple_sheet_data.
  • Writing values with update_cells and applying grouped changes with batch tools.
  • Inspecting formulas, summaries, folders, and sheet tabs.
  • Adding rows or columns, copying or renaming sheets, and sharing spreadsheets.

Limitations and notes

Authentication, API enablement, and access permissions must be set up in Google Cloud before useful requests can succeed. Service-account access depends on the relevant spreadsheets or folders being available to that account. The default configuration exposes 19 tools, which the README estimates at about 13,000 tokens of context; filtering is available to reduce that initial tool description overhead.

The xing5/mcp-google-sheets MCP server works with spreadsheet and Drive identifiers, so agents or users may need to obtain those IDs from URLs or discovery results before operating on a target file. Requests that include full grid data can be substantially larger than values-only reads because formatting and metadata are included.

Read the full README View source on GitHub

Reviews

No reviews yet — be the first to share how it worked for you.

Frequently Asked Questions about MCP Google Sheets

xing5/mcp-google-sheets is an MCP server that connects MCP-compatible clients to Google Sheets and Google Drive APIs. Its main tools list spreadsheets, navigate tabs, read sheet ranges, and update cells. It also supports creating spreadsheets and sheets, searching, batch operations, formula retrieval, folder listing, summaries, and sharing.

Run it with `uvx mcp-google-sheets@latest` after installing `uv`. Before launching, configure Google Cloud credentials and enable the required APIs. The README recommends a service account and uses `SERVICE_ACCOUNT_PATH` plus an optional default `DRIVE_FOLDER_ID`.

Use a Google service account, OAuth 2.0, or direct credential injection through `CREDENTIALS_CONFIG`. Service-account setup is the recommended option in the README. With that approach, provide the JSON key path through `SERVICE_ACCOUNT_PATH` and grant the account access to the relevant Drive files or folders.

Set `ENABLED_TOOLS` to a comma-separated list of tool names, or pass the same list with `--include-tools`. For example, enable only `get_sheet_data,update_cells,list_spreadsheets,list_sheets` when those are the operations the client needs.

Yes, Claude Desktop is an MCP client documented in the README for this server. Configure it to launch the `uvx mcp-google-sheets@latest` command with the required authentication environment variables, or test the command manually before adding it to the client configuration.

Related MCP servers

All in Databases All alternatives
Add a badge to your READMEShow it’s listed — live SVG, Markdown or HTML.

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:
Live Dynamic SVG PreviewMCP Google Sheets AllMCPs Directory Badge
Markdown (GitHub README)
[![AllMCPs](https://allmcps.com/api/badge/xing5-mcp-google-sheets?style=directory)](https://allmcps.com/mcp/xing5-mcp-google-sheets)
HTML Embed
<a href="https://allmcps.com/mcp/xing5-mcp-google-sheets"><img src="https://allmcps.com/api/badge/xing5-mcp-google-sheets?style=directory" alt="MCP Google Sheets on AllMCPs" /></a>