MCP + n8n for Sales & Research: Real Business Data Enrichment Example (FREE Template)

Key Concepts

• MCP (Machine Comprehension Pipeline): A tool used to automatically enrich data.
• NADN (No-Code Automation and Data Network): A platform used to build automated workflows.
• Explorium: A B2B data and infrastructure provider specializing in AI agents.
• API Key: A unique key used to authenticate and access the Explorium MCP.
• Google Sheets Trigger: A trigger that listens for changes in a Google Sheet.
• Loop Node: A node that iterates through each row in a Google Sheet.
• AI Agent: An agent that uses a chat model and the Explorium MCP to extract data.
• System Prompt: Instructions given to the AI agent to guide its behavior.
• Output Parser: A tool used to control the format of the AI agent's output.
• Business ID: A unique identifier for a company in a database.
• NYAX Code: A standardized classification of a company's primary industry.

Demo Overview

The video demonstrates how to use an MCP with NADN to automatically enrich company data in a Google Sheet. By inputting a company name and website, the workflow automatically pulls in details such as business ID, NYAX code, number of employees, and yearly revenue range. The demo uses OpenAI, Google, and Figure.AI as examples.

Step-by-Step Workflow Explanation

1. Google Sheets Trigger: The workflow starts with a Google Sheets trigger that monitors a specified Google Sheet for new data.
2. Filter Rows: A filter is applied to ensure that only non-empty rows are processed.
3. Loop Item: A loop node is added to iterate through each row in the Google Sheet, ensuring that all rows are processed.
4. AI Agent:
   • Prompt: The AI agent is given a system prompt that instructs it to research and extract key business metrics, including name, website, annual revenue, number of employees, and NYAX code, using the Explorium tools.
   • Chat Model: The AI agent uses a chat model (e.g., Anthropic) to process the data.
   • Explorium MCP: The Explorium MCP is used as a tool to match the business name, find the business ID, and enrich the business firmographics to get company details.
5. Explorium MCP Setup:
   • MCP Client Tool: The MCP client tool is added to the workflow.
   • Endpoint: The endpoint is set to mcp.explorium.ai/sse.
   • Authentication: Authentication is set up using an API key obtained from admin.explorium.ai/appi key. The API key is added as a header credential with the name "API key."
   • Tools: All tools within the MCP are selected to ensure access to all functionalities.
6. Output Parser: An output parser is used to control the format of the AI agent's output, ensuring that it matches the columns in the Google Sheet (name, website, business ID, NYAX, number of employees, yearly revenue range).
7. Code Node: A code node is used to format the output of the AI agent into a structured format.
8. Update Company Rows: The Google Sheets node is used to update the rows in the Google Sheet with the enriched data from the AI agent. The data is mapped from the code node output to the corresponding columns in the Google Sheet.

Explorium MCP Details

• Functionality: Explorium provides B2B data and infrastructure specifically built for AI agents.
• API Key: A free API key can be obtained from admin.explorium.ai/appi key for trial use.
• MCP Server: Documentation and details about the MCP server can be found on the Explorium website.

Key Arguments and Perspectives

• Ease of Use: The video emphasizes how easy it is to put MCPs to work, even though many people don't realize it.
• Time-Saving: The workflow can save a significant amount of time for sales, research, and other teams by automating the process of enriching company data.
• Power of MCPs: MCPs are presented as a powerful tool that will become even more powerful in the future, making AI agents more effective.
• Real-World Use Case: The video highlights a real-world use case of how an MCP can be used to enrich company data for business purposes.

Notable Quotes

• "So, whether you're in sales research, or just love working smarter, this is going to save you a ton of time."
• "Explorium is a great company. Feel free to check that out. They have uh they're basically a B2B data and infrastructure for specifically built for AI agents."
• "MCP is very powerful tomb and it's going to be even more powerful in the future because we're just in the beginning stages."

Technical Terms and Concepts

• Machine Comprehension Pipeline (MCP): A pipeline that enables machines to understand and process data, often used for data enrichment.
• No-Code Automation and Data Network (NADN): A platform that allows users to automate tasks and integrate data without writing code.
• API (Application Programming Interface): A set of rules and specifications that software programs can follow to communicate with each other.
• Endpoint: A specific URL where an API can be accessed.
• Authentication: The process of verifying the identity of a user or application.
• Header Credential: A method of authentication that involves passing credentials in the header of an HTTP request.
• System Prompt: A set of instructions given to an AI model to guide its behavior.
• Output Parser: A tool used to control the format and structure of the output generated by an AI model.
• Business ID: A unique identifier assigned to a business entity in a database.
• NYAX (North American Industry Classification System) Code: A standard used to classify businesses by their primary industry.

Logical Connections

The video logically connects the following elements:

1. Problem: The need to enrich company data efficiently.
2. Solution: Using an MCP with NADN to automate the data enrichment process.
3. Implementation: A step-by-step guide on how to set up the workflow, including configuring the Google Sheets trigger, AI agent, Explorium MCP, output parser, and code node.
4. Benefits: Time-saving, increased efficiency, and access to valuable company data.

Data, Research Findings, or Statistics

The video does not explicitly mention specific data, research findings, or statistics. However, it implies the value of enriched company data for sales, research, and other business functions.

Synthesis/Conclusion

The video provides a practical guide on how to use an MCP with NADN to automate the process of enriching company data in a Google Sheet. By leveraging the Explorium MCP and a well-defined workflow, users can efficiently pull in valuable company information, such as business ID, NYAX code, number of employees, and yearly revenue range. This automation can save time, increase efficiency, and provide valuable insights for sales, research, and other business functions. The video emphasizes the ease of use and the potential of MCPs as a powerful tool for AI-driven data enrichment. The provided template and step-by-step instructions make it easy for viewers to implement the workflow and start enriching their own company data.