Sheeter MCP Server

MCP server that enables Claude Desktop to interact with Google Sheets through the Sheeter API.

Main Project: github.com/SarthakS97/sheeter

What it does

Connects Claude Desktop to Google Sheets via secure API, enabling:

• Create spreadsheets through conversation
• Read and analyze sheet data
• Write and update cells
• Append data to sheets
• Clear ranges and delete rows
• Get spreadsheet metadata
• Batch operations for efficiency

Setup

1. Get API Key

Visit sheeter-2.onrender.com and sign in with Google to get your API key.

2. Configure Claude Desktop

Add to your Claude Desktop MCP configuration:

{
  "mcpServers": {
    "sheeter": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-web"],
      "env": {
        "WEB_BASE_URL": "https://sheeter-2.onrender.com",
        "WEB_API_KEY": "your_api_key_here"
      }
    }
  }
}

3. Use with Claude

Ask Claude to work with your spreadsheets:

• "Create a budget tracker spreadsheet"
• "Read data from my sales sheet"
• "Add this week's expenses to my tracker"
• "Analyze my project data and create a summary"

Available Tools

• create_spreadsheet - Create new Google Spreadsheets
• read_sheet - Read data from sheets
• write_sheet - Update specific ranges
• append_to_sheet - Add data to end of sheets
• clear_range - Clear specific ranges
• batch_get_ranges - Read multiple ranges at once
• batch_update_ranges - Update multiple ranges
• get_sheet_metadata - Get spreadsheet information
• delete_rows - Remove specific rows
• batch_update_spreadsheet - Advanced operations

Tech Stack

• TypeScript
• MCP SDK
• Sheeter API integration
• Deployed on Smithery

Source

This MCP server is part of the larger Sheeter project: github.com/SarthakS97/sheeter