Turns a Google Sheet into a four-table CRM of leads, organizations, contacts and activities that an AI assistant can edit.
Plenty of small sales teams already track deals in a spreadsheet. MCP-Excel leans into that. Despite the name, it works on Google Sheets: the MCP-Excel MCP server turns any sheet you share with it into a four-entity CRM covering leads, organizations, contacts and activities, then lets an assistant read and edit it.
On first connection it creates four tabs if they are missing, Lead, Organization, Contact and Activity, each with its own primary key. Existing tabs are kept. Missing columns are appended without touching your data, along with Created At, Updated At and Deleted audit columns.
Two details make it friendlier than a raw Sheets connector. IDs continue whatever pattern you already use, so LD001 is followed by LD002, falling back to a UUID when no pattern exists. Headers are matched fuzzily, which means a sheet with slightly different column names still works.
Deleted rather than removing rows.Every call names its sheet with an explicit sheet_id, either a full URL or the bare ID. Nothing is stored between requests, so one running instance can serve several teams without their data crossing over.
You need a Google service account key, creds.json, with the Sheets and Drive APIs enabled. Share each sheet with that service account's email as an Editor; Viewer access produces permission errors. Install the Python requirements, then pick a transport. HTTP mode listens on port 5002 by default and suits a shared or Docker deployment. For Claude Desktop, set MCP_TRANSPORT=stdio as shown in the config below.
Keep in mind that the MCP-Excel MCP server sits on a spreadsheet, not a CRM database. There are no user roles, and anyone with the service account effectively has edit rights to every shared sheet. Keep creds.json out of version control. Deletes are soft, which is reassuring, but updates overwrite fields directly.
Teams that outgrow the spreadsheet may want a dedicated CRM and sales server such as HubSpot. For general sheet work, browse other spreadsheet servers.
Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.
| Tool | What it does |
|---|---|
| tool_get_sheet_info | Validates access, makes sure all four tabs exist and confirms write access. |
| tool_add_record | Adds a record to the Lead, Organization, Contact or Activity tab. |
| tool_list_records | Lists records with optional column filters, paged. |
| tool_search_records | Runs a keyword search across all columns. |
| tool_update_record | Updates fields on an existing record by primary-key ID. |
| tool_delete_record | Soft-deletes a record by setting Deleted to true. |
| tool_get_related_records | Looks up records through a foreign key, such as all activities for a lead. |
| tool_get_pipeline_analytics | Returns lead pipeline totals with status and segment breakdowns. |
| tool_dedupe_headers | Finds and merges duplicate columns, with a dry-run report first. |
| tool_extract_business_card | Extracts contact fields from a business-card image; requires ANTHROPIC_API_KEY. |
{
"mcpServers": {
"crm": {
"command": "python",
"args": [
"/path/to/mcp-excel/mcp_excel_server.py"
],
"env": {
"GOOGLE_APPLICATION_CREDENTIALS": "/path/to/mcp-excel/creds.json",
"MCP_TRANSPORT": "stdio"
}
}
}
}Run pip install -r requirements.txt first. Share each Google Sheet with the service account email as Editor.
| Variable | Description | Required |
|---|---|---|
| GOOGLE_APPLICATION_CREDENTIALS | Path to the Google service account JSON key. Defaults to creds.json in the server directory. | Yes |
| MCP_TRANSPORT | http (default) for server mode on a port, or stdio for Claude Desktop and other local hosts. | Optional |
| MCP_PORT | HTTP listen port. Defaults to 5002. | Optional |
| ANTHROPIC_API_KEY | Only needed for the business-card extraction tool. | Optional |
Search and read your Drive — Docs, Sheets and files become context your assistant can actually use.
Spreadsheet-database hybrid meets AI — inspect schemas, query records and update bases conversationally.
Google Sheets MCP server with allowlist-based permission control
Google Sheets API -- simple interface to read/write data and manage sheets
Extract, create, convert & validate invoices (UBL, CII, XRechnung, ZUGFeRD, PDF, Excel)
SheetForge MCP is an Excel MCP server for `.xlsx` automation over the Model Context Protocol. It is built for AI agents, MCP clients, and automation