Building MCP client in n8n · Rico AI Community

Building MCP client in n8n

I need a n8n workflow to make my agent to connect to my MCP server.

1. To generate reports and save it in google docs and send mail with the report.

2. The workflow must be executed every day at 9.00 pm

3. The agent has always use the context from context file - CALC_FMONTH.txt before fetch data from the mcp server

MCP server is SQL database already build and working with sse

This is example of the prompt:

1. 📊 Financial Monitoring Agent

Functions:

Daily checks income/expenses against plan

Alerts for deviations above 15% from the average

Automatically generates weekly financial reports

Track margins by services and doctors

1 comment

skool.com/ai-business

AI made simple — so you can learn, build and earn.