Google Sheets
BasicGoogle Sheets MCP server provides AI agents with access to Google Sheets API for reading, writing, and managing spreadsheet data. It allows agents to create, update, and query spreadsheets, work with ranges, and handle formatting. It integrates with Google Workspace and other Google services. Developers use it to automate data entry, analysis, and reporting tasks, and to build applications that require real-time collaboration and data sharing.
000
Overview
Google Sheets MCP server provides AI agents with access to Google Sheets API for reading, writing, and managing spreadsheet data. It allows agents to create, update, and query spreadsheets, work with ranges, and handle formatting. It integrates with Google Workspace and other Google services. Developers use it to automate data entry, analysis, and reporting tasks, and to build applications that require real-time collaboration and data sharing.
Installation
1Install the package
2Add to Claude
Add this configuration to your claude_desktop_config.json:
claude_desktop_config.json
{
"mcpServers": {
"google-sheets-smithery": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-google-sheets-smithery"
]
}
}
}3Verify installation
Restart Claude Desktop, then ask:
"What tools do you have available from Google Sheets?"
Prerequisites
- Node.js 18 or higher
- npm or npx available
- Claude Desktop or Claude API access
- API key for Google Sheets
Configuration
API Key Required
This server requires an API key from Google Sheets. Add it to your environment or config.
| Variable | Required | Description |
|---|---|---|
| GOOGLE_SHEETS_API_KEY | Yes | Your Google Sheets API key |
Usage Examples
List Resources
"What resources are available in Google Sheets?"
Claude will query available resources and return a list of what you can access.
Get Details
"Show me details about [specific item] in Google Sheets"
Claude will fetch and display detailed information about the requested item.
Create New
"Create a new [item] in Google Sheets with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
Works with Google Sheets
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.