MCP.so
Sign In

MCP Google Sheets Server

@shionhonda

Repository

About MCP Google Sheets Server

Model Context Protocol (MCP) server that allows interaction with Google Sheets

Basic information

Category

Other

License

MIT license

Runtime

python

Transports

stdio

Publisher

shionhonda

Config

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

{
  "mcpServers": {
    "mcp-gsheet": {
      "command": "uv",
      "args": [
        "venv"
      ]
    }
  }
}

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 Server?

MCP Google Sheets Server is a Model Context Protocol (MCP) server that enables interaction with Google Sheets. It is intended for AI agents or tools that need to list sheets, read cell ranges, and write data to spreadsheets, but it does not manage Google Drive files.

How to use MCP Google Sheets Server?

Set the GOOGLE_APPLICATION_CREDENTIALS environment variable to the absolute path of your service account JSON key, clone the repository, create a Python 3.11+ virtual environment with uv, install dependencies, then run mcp dev server.py (development) or mcp run server.py (production). The server communicates over standard input/output (stdio).

Key features of MCP Google Sheets Server?

  • List all sheet names (tabs) in a spreadsheet.
  • Read data from a specific cell range.
  • Write a 2D list of values to a specific cell range.
  • No Google Drive file management capabilities.
  • Authenticates via service account key.
  • Runs over stdio – suitable for MCP clients like Claude Desktop.

Use cases of MCP Google Sheets Server?

  • Extract data from Google Sheets for analysis or reporting.
  • Auto-populate spreadsheet cells from AI agent responses.
  • List sheets/tabs to discover spreadsheet structure.
  • Update cell values based on user queries or external inputs.

FAQ from MCP Google Sheets Server

What tools does MCP Google Sheets Server provide?

It provides three tools: list_sheets(spreadsheet_id), read_cells(spreadsheet_id, range_name), and write_cells(spreadsheet_id, range_name, values).

Can I manage Google Drive files (create/delete folders) with this server?

No. The server explicitly does not provide tools for managing Google Drive files. Access is restricted to spreadsheet content only.

What are the runtime requirements?

Python 3.11+, a Google Cloud Project with the Google Sheets API enabled, and a downloaded service account key file (JSON). Dependencies are managed via uv.

How do I authenticate?

Set the environment variable GOOGLE_APPLICATION_CREDENTIALS to the absolute path of your service account JSON key file. The service account must have the "Editor" role on the target Google Sheets.

How do I run the server?

Use mcp dev server.py for development with MCP Inspector, or mcp run server.py for production. For Claude Desktop, add a JSON configuration block pointing to uv and the server path.

Comments

More Other MCP servers

Peekaboo MCP – lightning-fast macOS screenshots for AI agents

steipete

Peekaboo is a macOS CLI & optional MCP server that enables AI agents to capture screenshots of applications, or the entire system, with optional visual question answering through local or remote AI models.

4.8K

Codelf

unbug

A search tool helps dev to solve the naming things problem.

14.2K

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

Awesome Mlops

visenger

A curated list of references for MLOps

14.0K

ACI: Open-Source Infra to Power Unified MCP Servers

aipotheosis-labs

ACI.dev is the open source tool-calling platform that hooks up 600+ tools into any agentic IDE or custom AI agent through direct function calling or a unified MCP server. The birthplace of VibeOps.

4.8K