This n8n workflow is designed to automatically enrich company information stored in a Google Sheets spreadsheet using the Explorium MCP (Master Customer Profile) service. The process begins with a trigger that detects when new or updated rows are added to the sheet. It filters out invalid entries, then processes each valid row individually in a loop. For each company, it uses an AI agent integrated with Explorium MCP to research and gather key business metrics such as annual revenue, number of employees, and NAICS code, based on the company name and website. The AI’s output is formatted via a code node and then used to update the corresponding row in Google Sheets, ensuring your data stays current with minimal manual effort. This workflow is ideal for businesses wanting to maintain a comprehensive and enriched dataset of companies for market analysis, lead generation, or CRM purposes, automating the tedious process of data enrichment.
Automated Company Data Enrichment with Explorium MCP
Node Count | 11 – 20 Nodes |
---|---|
Nodes Used | @n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmChatAnthropic, @n8n/n8n-nodes-langchain.mcpClientTool, @n8n/n8n-nodes-langchain.outputParserStructured, code, googleSheets, googleSheetsTrigger, if, splitInBatches, stickyNote |
Reviews
There are no reviews yet.