MCP with N8N

mcp-autopeças with n8n

MCP Server in Python that reads and writes to Google Sheets tabs via the MCP protocol — compatible with Claude Desktop, Claude Code, and any MCP Client (including the mcpClientTool node in N8N).

The server covers two domains in a single process, each mapped to a tab in the same spreadsheet:

Prerequisites

• Python 3.12+

• uv (recommended) or pip

• Google Service Account with Editor permission on the spreadsheet (required for leitos_atualizar_status_limpeza)

Installation

cd mcp-alura
uv sync          # ou: pip install -e .

Configuration

1. Google Credentials (Service Account)

In the Google Cloud Console:

1. Create a project → APIs & Services → Enable Google Sheets API

2. Create a Service Account → generate and download the JSON key

3. Share the spreadsheet with the service account email with Editor permission

2. Environment Variables

cp .env.example .env

Edit the .env file with at least:

SPREADSHEET_ID=1zt4h2v3ldK3zELNNmvyn02elEB9dHdfXD5q85ZYh2k0
AUTOPECAS_SHEET_NAME=AutoPeças
LEITOS_SHEET_NAME=Leitos
GOOGLE_CREDENTIALS_PATH=/caminho/para/service_account.json

# Para leitos_enviar_notificacao (e-mail):
GMAIL_USER=setor@hospital.com.br
GMAIL_APP_PASSWORD=xxxx_xxxx_xxxx_xxxx

# Para leitos_enviar_sms:
TWILIO_ACCOUNT_SID=ACxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
TWILIO_AUTH_TOKEN=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
TWILIO_FROM_NUMBER=+18647139932

The SPREADSHEET_ID is in the URL: docs.google.com/spreadsheets/d/**{ID}**/edit

Expected Spreadsheet Structure

AutoPeças Tab:

Leitos Tab — columns confirmed by the N8N node schema:

Column names can be adjusted in the .env file using COL_* and LEITOS_COL_*.

AutoParts Tools

Hospital Beds Tools

Mapping of N8N agents (mcp-all-nodes.json) to Python tools:

Occupancy_Status: Available 🟢 · Occupied 🔴 · Reserved 🔵

Cleaning_Status: Completed ✅ · Pending ⚠️ · In Progress 🔄

Room types: Ward · ICU · Apartment · Semi-Intensive

Configuring email sending

The leitos_enviar_notificacao tool uses Gmail SMTP with an App Password:

1. Enable two-step verification on your Google account

2. Go to myaccount.google.com/apppasswords

3. Create a password for "Email" and paste it into GMAIL_APP_PASSWORD in the .env file

Configuring SMS sending

The leitos_enviar_sms tool uses the Twilio REST API:

1. Create an account at twilio.com

2. Get your Account SID and Auth Token from the dashboard

3. Register or purchase a sender number and configure TWILIO_FROM_NUMBER

Usage in Claude Desktop

Add to ~/Library/Application Support/Claude/claude_desktop_config.json:

{
  "mcpServers": {
    "hospital-mcp": {
      "command": "uv",
      "args": ["run", "--project", "/caminho/para/mcp-alura", "python", "server.py"],
      "env": {
        "SPREADSHEET_ID": "1zt4h2v3ldK3zELNNmvyn02elEB9dHdfXD5q85ZYh2k0",
        "AUTOPECAS_SHEET_NAME": "AutoPeças",
        "LEITOS_SHEET_NAME": "Leitos",
        "GOOGLE_CREDENTIALS_PATH": "/caminho/para/service_account.json",
        "GMAIL_USER": "setor@hospital.com.br",
        "GMAIL_APP_PASSWORD": "xxxx_xxxx_xxxx_xxxx",
        "TWILIO_ACCOUNT_SID": "ACxxxxxxxx",
        "TWILIO_AUTH_TOKEN": "xxxxxxxx",
        "TWILIO_FROM_NUMBER": "+18647139932"
      }
    }
  }
}

Usage in Claude Code

claude mcp add hospital-mcp -- uv run --project /caminho/para/mcp-alura python server.py

Usage in N8N (MCP Client)

Configure the MCP Client Tool node pointing to the server endpoint. The three N8N agents can share the same Python MCP server, each using the tools appropriate for their role via include: selected.

Local testing

uv run python server.py

To inspect the 15 tools with the MCP Inspector:

npx @modelcontextprotocol/inspector uv run python server.py