MCP-Excel — Claude Code MCP server for Google Sheets CRM
The MCP-Excel MCP server for Claude Code turns Google Sheets into a CRM for leads, organizations, contacts, and activities. Agents can manage records and inspect lead pipeline data.
MIT updated 2026-11-09
Open on GitHubWhat MCP-Excel does
MCP-Excel exposes Google Sheets CRM operations to an MCP client. It creates four tabs for leads, organizations, contacts, and activities when a sheet is first connected, then adds missing columns while keeping existing data. Each tool call needs a sheet_id, supplied as a spreadsheet URL or ID.
The server runs over HTTP or stdio. Its tools add, search, filter, update, and soft-delete records; find related entries; and report lead pipeline totals and breakdowns. Column matching handles synonyms, and tool_dedupe_headers can report and merge duplicate headers.
Setup requires the Python packages in requirements.txt and a Google service-account key. Enable Google Sheets API and Google Drive API, then share each spreadsheet with that account as an Editor. Business-card extraction also needs anthropic and ANTHROPIC_API_KEY.
What it helps with
- store CRM records in Google Sheets
- search records across spreadsheet columns
- change a record using its primary-key ID
- retrieve activities linked to a lead
- merge duplicate spreadsheet headers
Example prompts for the agent
- Add a lead to the sheet with
sheet_idSHEET_IDand set its organization and status. - Find contacts by email in the spreadsheet with
sheet_idSHEET_ID. - Show lead pipeline analytics for the sheet with
sheet_idSHEET_ID.
How to install MCP-Excel
Install
The MCP registry has no launch command for it: see the repository README
Step by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about MCP-Excel
How do I install MCP-Excel in Claude Code?
Install the dependencies with pip install -r requirements.txt, prepare a Google service-account key, and configure the MCP server in the client. Enable Google Sheets API and Google Drive API, then grant the service account Editor access to the spreadsheet.
What does MCP-Excel do?
It gives MCP clients tools for managing a CRM stored in Google Sheets, covering leads, organizations, contacts, and activities. The server can search and edit records, soft-delete them, and provide pipeline analytics.
What does MCP-Excel need to run?
It needs the Python packages in requirements.txt, a Google service-account key, enabled Google Sheets API and Google Drive API, and Editor access to the spreadsheet. Business-card extraction also requires anthropic and ANTHROPIC_API_KEY.