MCP server for Google Sheets API with read/write capabilities - Claude Desktop integration
npm install @arthur_kim/google-sheets-mcp

Model Context Protocol (MCP) server for seamless Google Sheets integration with Claude Desktop and other MCP clients.
- đ Read spreadsheet data with A1 notation
- âī¸ Write data to specific cells or ranges
- â Append new rows to spreadsheets
- đ Update spreadsheet titles
- âšī¸ Get spreadsheet metadata and information
- đ Secure OAuth 2.0 authentication
- đ Easy setup with environment variables
``bash`
npm install -g @arthur_kim/google-sheets-mcp
`bash`
git clone https://github.com/arthur_kim/google-sheets-mcp.git
cd google-sheets-mcp
npm install
1. Go to Google Cloud Console
2. Create a new project or select existing one
3. Enable Google Sheets API
4. Create OAuth 2.0 Client ID (Desktop App)
5. Download credentials
Set up environment variables with your Google OAuth credentials:
`bash`
export GOOGLE_CLIENT_ID="your-client-id.apps.googleusercontent.com"
export GOOGLE_CLIENT_SECRET="your-client-secret"
Add to your Claude Desktop config file:
macOS: ~/Library/Application Support/Claude/claude_desktop_config.json%APPDATA%\Claude\claude_desktop_config.json
Windows:
`json`
{
"mcpServers": {
"google-sheets": {
"command": "npx",
"args": ["-y", "@arthur_kim/google-sheets-mcp"],
"env": {
"GOOGLE_CLIENT_ID": "your-client-id.apps.googleusercontent.com",
"GOOGLE_CLIENT_SECRET": "your-client-secret"
}
}
}
}
Restart Claude Desktop to apply the configuration.
Once configured, you can interact with Google Sheets naturally in Claude:
"Read data from spreadsheet 1nOFeUYjxOQClms8dP8Sz8XuGlEocorYi5injSS0MFlY, range Sheet1!A1:D10"
`$3
`
"Change the title of spreadsheet 1nOFeUYjxOQClms8dP8Sz8XuGlEocorYi5injSS0MFlY to 'Q1 Sales Report'"
`$3
`
"Write 'New Value' to cell A1 in Sheet1"
`$3
`
"Add a new row to Sheet1 with values: ['John', 'Doe', '30', 'Engineer']"
`$3
`
"Get information about spreadsheet 1nOFeUYjxOQClms8dP8Sz8XuGlEocorYi5injSS0MFlY"
`đ§ Available Tools
| Tool | Description |
|------|-------------|
|
sheets_read | Read data from a spreadsheet range |
| sheets_write | Write data to specific cells |
| sheets_append | Append rows to a spreadsheet |
| sheets_update_title | Update spreadsheet title |
| sheets_get_info | Get spreadsheet metadata |đ Documentation
For detailed setup instructions, see:
- SETUP_GUIDE.md - Complete setup guide
- QUICKSTART.md - Quick start tutorial
đ Troubleshooting
$3
- Verify OAuth credentials in environment variables
- Ensure Google Sheets API is enabled in Google Cloud Console
- Check that OAuth consent screen is configured$3
- Restart Claude Desktop completely
- Check MCP server logs in Claude Desktop
- Verify claude_desktop_config.json syntax$3
- Ensure required scope is authorized: https://www.googleapis.com/auth/spreadsheets`Contributions are welcome! Please feel free to submit a Pull Request.
MIT License - see LICENSE file for details
- Google Sheets API v4
- Model Context Protocol
- OAuth 2.0 Documentation
arthur_kim