Sheet

A Model Context Protocol server that enables Claude to read, search, and analyze Google Sheets data through a set of spreadsheet tools.

python

0

GitHub Stars

python

Language

6 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "nileshphapale142-sheet-mcp-server": {
      "command": "uv",
      "args": [
        "--directory",
        "C:\\path\\to\\your\\SheetMCP",
        "run",
        "main.py"
      ],
      "env": {
        "SHEET_API_KEY": "your_api_key_here"
      }
    }
  }
}

You can run a Model Context Protocol (MCP) server that exposes tools to read, search, and interact with Google Sheets data. This server lets AI assistants access spreadsheets, extract ranges, list sheets, and retrieve metadata, all through a lightweight, dependency-managed runtime.

How to use

To use this MCP server with an MCP-compatible client, start the local server in the background or foreground and connect your client to the provided MCP endpoint. You will have access to tools that list spreadsheets, search by name, read data from ranges, fetch sheet metadata, list sheets, search within sheets, and retrieve formatted range data. Begin by starting the server, then configure your client to reference the server as shown in the example integration snippet.

How to install

Prerequisites you need before installing:

Python 3.8 or newer
uv package manager
Google Cloud Project with Sheets API enabled
Claude Desktop or another MCP-compatible client

Install dependencies and set up the project local environment using the package manager specified for this MCP server:

# Install dependencies using uv
uv sync

# Or if uv is not installed yet:
pip install uv
uv sync

Additional setup and running details

Authentication is required to access Google Sheets. You can authenticate using OAuth 2.0 for private sheets or API keys for public sheets. Generate an authentication token, then run the server. You can also provide an optional API key in a .env file for fallback access.

OAuth 2.0 (recommended for private sheets): create a Google Cloud project, enable the Sheets and Drive APIs, obtain OAuth credentials, and run the token generation step to complete the flow. The token is stored for subsequent usage.

API Key (public sheets only): obtain an API key from Google Cloud Console and place it in a .env file as SHEET_API_KEY for fallback usage. This method works only with publicly shared spreadsheets.

To run the server standalone, execute the main server entry point. To integrate with Claude Desktop, ensure the OAuth flow has completed before connecting and use the provided MCP configuration snippet to register the server.

Pre-authentication flow

Pre-authenticate to avoid interruptions during operation. Generate the authentication token first, then start the MCP server or add it to your MCP client configuration.

uv run token_gen.py

Then start the server normally with the appropriate entry point for your setup.

## Connecting from Claude Desktop

Add the MCP server configuration to Claude Desktop so it can call the available tools. Use the runtime command and arguments exactly as shown in the integration snippet to ensure the server starts correctly within your environment.

{ "mcpServers": { "sheet_mcp": { "command": "uv", "args": [ "--directory", "C:\path\to\your\SheetMCP", "run", "main.py" ] } } }


## Available tools

### list\_spreadsheets

Lists all Google Spreadsheets accessible to the authenticated user.

### search\_spreadsheets\_by\_name

Find spreadsheets by name with exact or partial matching.

### read\_sheet\_data

Extract data from a specific range or entire sheet.

### get\_sheet\_metadata

Retrieve detailed information about a spreadsheet.

### list\_sheets

Get all sheet/tab names within a spreadsheet.

### search\_sheet\_data

Find specific content within a sheet.

### get\_range\_data

Extract data with specific formatting options.