The mcp google sheets server connects to Google Drive and Sheets APIs to create, read, update, and delete spreadsheets. It exposes functions for managing spreadsheets, worksheets, and cell data. Developers use it to build AI agents that automate spreadsheet tasks, such as data entry, reporting, and analysis.
The mcp google sheets server connects to Google Drive and Sheets APIs to create, read, update, and delete spreadsheets. It exposes functions for managing spreadsheets, worksheets, and cell data. Developers use it to build AI agents that automate spreadsheet tasks, such as data entry, reporting, and analysis.
pip install mcp-google-sheetsAdd this configuration to your claude_desktop_config.json:
{
"mcpServers": {
"xing5-mcp-google-sheets-github": {
"command": "uvx",
"args": [
"pip install mcp-google-sheets"
]
}
}
}Restart Claude Desktop, then ask:
"What tools do you have available from mcp google sheets?"
API Key Required
This server requires an API key from mcp google sheets. Add it to your environment or config.
| Variable | Required | Description |
|---|---|---|
| MCP_GOOGLE_SHEETS_API_KEY | Yes | Your mcp google sheets API key |
"What resources are available in mcp google sheets?"
Claude will query available resources and return a list of what you can access.
"Show me details about [specific item] in mcp google sheets"
Claude will fetch and display detailed information about the requested item.
"Create a new [item] in mcp google sheets with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
We build custom MCP integrations for B2B companies. From simple connections to complex multi-tool setups.