README.md•1.94 kB
# Sheeter MCP Server
MCP server that enables Claude Desktop to interact with Google Sheets through the Sheeter API.
**Main Project**: [github.com/SarthakS97/sheeter](https://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](https://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:
```json
{
"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](https://github.com/SarthakS97/sheeter)