mcp-gsheets
npxVerifiedMCP server for Google Sheets API integration. Provides read, write, and update operations on Google Sheets. Connects to Google Drive API for file management. Used by developers to automate data workflows, sync spreadsheets, and build tools that require Google Sheets data.
44100Updated 2 months ago
Overview
MCP server for Google Sheets API integration. Provides read, write, and update operations on Google Sheets. Connects to Google Drive API for file management. Used by developers to automate data workflows, sync spreadsheets, and build tools that require Google Sheets data.
Installation
1Install the package
npx
npx -y mcp-gsheets2Add to Claude
Add this configuration to your claude_desktop_config.json:
claude_desktop_config.json
{
"mcpServers": {
"mcp-gsheets-npm": {
"command": "npx",
"args": [
"-y",
"npx -y mcp-gsheets"
]
}
}
}3Verify installation
Restart Claude Desktop, then ask:
"What tools do you have available from mcp-gsheets?"
Prerequisites
- Node.js 18 or higher
- npm or npx available
- Claude Desktop or Claude API access
- API key for mcp-gsheets
Configuration
API Key Required
This server requires an API key from mcp-gsheets. Add it to your environment or config.
| Variable | Required | Description |
|---|---|---|
| MCP-GSHEETS_API_KEY | Yes | Your mcp-gsheets API key |
Usage Examples
List Resources
"What resources are available in mcp-gsheets?"
Claude will query available resources and return a list of what you can access.
Get Details
"Show me details about [specific item] in mcp-gsheets"
Claude will fetch and display detailed information about the requested item.
Create New
"Create a new [item] in mcp-gsheets with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
Works with mcp-gsheets
Claude
AI assistant built for thoughtful, nuanced conversation
Supermetrics
Automate marketing data reporting across all platforms
Sheetgo
Automate your Google Workspace
Tray.io
Low-code automation platform for complex workflows
Coupler.io
Automated data sync for seamless workflows
SyncRange
Automate spreadsheet data sync across business tools
Apipheny
Connect APIs to Google Sheets effortlessly
Related skills
Browse all skillsNeed help with MCP integration?
We build custom MCP integrations for B2B companies. From simple connections to complex multi-tool setups.