Automated Company Data Enrichment Using n8n and Google Sheets

This workflow automates the process of enriching company data stored in a Google Sheet with detailed business metrics. It starts with a Google Sheets trigger that monitors for new rows or updates in the specified sheet. Each valid row—one with both a company name and website—is processed individually in a loop. For each row, an AI agent powered by LangChain utilizes Explorium’s MCP (Market Confidence Platform) tools to perform company research, identify the business ID, and retrieve key data points such as annual revenue, number of employees, and NAICS code. The AI’s output is then formatted by a custom code node and the enriched data is used to update the corresponding row in Google Sheets. This process continues until all relevant rows are processed. Practical use cases include maintaining an up-to-date company database, lead enrichment for sales, or competitive analysis, enabling organizations to keep their data current with minimal manual effort.