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