This n8n workflow automates the process of enriching business leads from a Google Sheet by performing a series of integrated steps to gather company information and extract emails. It is designed for marketers, sales teams, or data analysts aiming to efficiently collect contact details of potential clients. The process begins with monitoring a specific row activation in Google Sheets. Upon triggering, it searches for relevant companies based on specified business types and locations using Serper.dev’s search API. Results are filtered to exclude unwanted companies, and the workflow then generates possible contact page URLs for each relevant company.

Next, the workflow tests these URLs for validity and scrapes the pages using ScrapingBee, extracting email addresses using a custom code node. The emails are deduplicated and stored in the Google Sheet alongside company and website details. Additional updates mark the lead’s status as ‘Running’, ‘Missing data’, or ‘Finished’ depending on the progress, enabling ongoing tracking and management. The entire process automates lead enrichment, saving time and ensuring consistent data collection for targeted outreach campaigns.

Practical use cases include automating prospect list updates, enriching CRM data, or preparing contact lists for marketing campaigns, all with minimal manual intervention. The workflow can be customized further by adding more blacklist terms, changing the search parameters, or expanding the data extraction points.