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