Google Spreadsheets

🚀 Google Spreadsheet MCP Server

This project is a Model Context Protocol (MCP) server for accessing Google Spreadsheet data. It enables LLMs to directly utilize spreadsheet information.

🚀 Quick Start

This project is a Model Context Protocol (MCP) server designed to access Google Spreadsheet data. It provides LLMs with the ability to directly use spreadsheet information, facilitating seamless data interaction and utilization.

✨ Features

• Retrieve basic information about worksheets (e.g., worksheet lists).
• Fetch and format specific worksheet data into Markdown.
• Integrate with MCP clients (e.g., Desktop Claude).

📦 Installation

# Clone the repository
git clone https://github.com/your-username/spreadsheet-mcp-server.git
cd spreadsheet-mcp-server

# Install dependencies
npm install

# Copy the example environment file
cp .env.example .env
# Edit the .env file to set GAS_WEB_APP_URL and GAS_API_KEY

# Build the project
npm run build

🔧 Environment Variable Configuration

The following environment variables are required for the server to run:

• GAS_WEB_APP_URL: The URL of the Google Apps Script Web App.
• GAS_API_KEY: The API key for accessing the Google Apps Script Web App.

These environment variables can be set in the .env file:

GAS_WEB_APP_URL=https://script.google.com/macros/s/your-deployment-id/exec
GAS_API_KEY=your-api-key

If the environment variables are not configured, the server will run in simulation mode and will not actually access Google Spreadsheets.

💻 Usage Examples

Basic Usage

npm start

Advanced Usage

Integrate with Desktop Claude by adding the following content to the Desktop Claude configuration file (claude_desktop_config.json):

{
  "mcpServers": {
    "spreadsheet": {
      "command": "node",
      "args": ["<absolute-path-to-project>/build/index.js"]
    }
  }
}

If you need to set environment variables, you can add the env field as follows:

{
  "mcpServers": {
    "spreadsheet": {
      "command": "node",
      "args": ["<absolute-path-to-project>/build/index.js"],
      "env": {
        "GAS_WEB_APP_URL": "https://script.google.com/macros/s/your-deployment-id/exec",
        "GAS_API_KEY": "your-api-key"
      }
    }
  }
}

The paths to the configuration file are as follows:

• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
• Windows: %AppData%\\Claude\\claude_desktop_config.json

🧪 Testing

npm test

📄 License

This project is licensed under the MIT License.