Skip to main content
MCP server CX Codex

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 GitHub

What 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_id SHEET_ID and set its organization and status.
  • Find contacts by email in the spreadsheet with sheet_id SHEET_ID.
  • Show lead pipeline analytics for the sheet with sheet_id SHEET_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.

Similar MCP servers

All MCP servers for Data and databases →

Project sponsors

Companies that keep this analytics open