Mcp Google Sheets

Name: Mcp Google Sheets
Author: xing5

@xing5

Repository

About Mcp Google Sheets

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

#google #mcp #spreadsheet #mcp-server

Basic information

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.

Comments

More Files & Storage MCP servers

MCP File System Server

MarcusJellinghaus

MCP Workspace Server: A secure Model Context Protocol server providing file, git, and GitHub tools for AI assistants within a sandboxed project directory.

Filesystem

chrisdoc

Manage your Hevy workouts, routines, folders, and exercise templates. Create and update sessions faster, organize plans, and search exercises to build workouts quickly. Stay synced with changes so your training log is always up to date.

310