SSyncDev

MCP-Excel MCP Server

Turns a Google Sheet into a four-table CRM of leads, organizations, contacts and activities that an AI assistant can edit.

Local server

What is the MCP-Excel MCP Server?

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.

How the sheet is organised

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.

What an assistant can do with it

  • Add, list, search and update records in any of the four tabs.
  • Follow foreign keys, for example every activity logged against a lead.
  • Soft-delete records by flagging Deleted rather than removing rows.
  • Summarise the pipeline by status and segment.
  • Merge duplicate columns, with a dry-run report first.
  • Pull contact fields from a photographed business card, if you supply an Anthropic API key.

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.

Setup steps

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.

Things to weigh

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.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
tool_get_sheet_infoValidates access, makes sure all four tabs exist and confirms write access.
tool_add_recordAdds a record to the Lead, Organization, Contact or Activity tab.
tool_list_recordsLists records with optional column filters, paged.
tool_search_recordsRuns a keyword search across all columns.
tool_update_recordUpdates fields on an existing record by primary-key ID.
tool_delete_recordSoft-deletes a record by setting Deleted to true.
tool_get_related_recordsLooks up records through a foreign key, such as all activities for a lead.
tool_get_pipeline_analyticsReturns lead pipeline totals with status and segment breakdowns.
tool_dedupe_headersFinds and merges duplicate columns, with a dry-run report first.
tool_extract_business_cardExtracts contact fields from a business-card image; requires ANTHROPIC_API_KEY.

How to install the MCP-Excel MCP Server

{
  "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.

Configuration

VariableDescriptionRequired
GOOGLE_APPLICATION_CREDENTIALSPath to the Google service account JSON key. Defaults to creds.json in the server directory.Yes
MCP_TRANSPORThttp (default) for server mode on a port, or stdio for Claude Desktop and other local hosts.Optional
MCP_PORTHTTP listen port. Defaults to 5002.Optional
ANTHROPIC_API_KEYOnly needed for the business-card extraction tool.Optional

Frequently asked questions

No. Despite the name, it works on Google Sheets through the Sheets and Drive APIs, using a Google service account.