Lead Contact Enrichment and Lemlist Sync - n8n Workflow

• Sales development representatives (SDRs) needing to quickly verify contact data.


• Marketing professionals running targeted outreach campaigns.


• Growth hackers looking for ready-to-use n8n templates for lead management.


• Users seeking an efficient n8n workflow for B2B data enrichment and CRM synchronization.

Preparing comprehensive and accurate lead data is critical for successful outreach campaigns. Manually enriching large lists from Google Sheets before importing them into a sales engagement tool like Lemlist is tedious and error-prone. This specialized n8n workflow completely automates this process.

Starting with a raw list in a Google Sheet, this n8n automation leverages the powerful Dropcontact API to find missing details like company names, LinkedIn URLs, and accurate emails. Once enriched, the data is immediately pushed to Lemlist, ready for sequence deployment. Using this powerful n8n solution ensures your sales sequences always hit targets with validated data, drastically improving delivery rates and conversion potential. This specific n8n templates saves valuable administrative time and accelerates your lead-to-opportunity cycle.

This automation is initiated using a manual n8n trigger, designed for batch processing lists on demand.

1. Start and Read Data: The n8n workflow begins with the 'On clicking 'execute'' n8n trigger. It immediately connects to the 'Google Sheets' n8n node, reading data across the specified range (A:K), treating each row as a separate item to be processed.


2. Contact Enrichment: The retrieved items are passed to the 'Dropcontact' n8n node. This node uses the initial contact fields (email, company name, website, etc.) as input parameters. Dropcontact validates and enriches the lead data, providing crucial missing information, configured specifically to request French language ('fr') details and siren information.


3. Lemlist Sync: Finally, the fully enriched data flows to the 'Lemlist' n8n node. This final n8n node creates a new lead in a specified Lemlist campaign. Crucially, the Lemlist node dynamically maps the enriched data (email, first name, last name, company name) received from the preceding Dropcontact node, ensuring only the highest quality, verified data is added to your outreach tool. This seamless data transition exemplifies the power of an interconnected n8n workflow.

1. Import the n8n template: Copy the provided JSON code and paste it into your n8n canvas using the 'New' > 'Import from JSON' function.


2. Google Sheets Setup: Click on the 'Google Sheets' n8n node. You must provide the specific Sheet ID you wish to read from and authenticate using a Google Sheets OAuth2 API credential. Ensure your sheet structure aligns with the expected data mapping (A:K).


3. Dropcontact Setup: Configure the 'Dropcontact' n8n node. You will need to create and select a Dropcontact API key credential.


4. Lemlist Setup: Configure the 'Lemlist' n8n node. Provide the necessary API credentials for Lemlist and ensure you specify the correct campaignId where the leads should be added.


5. Execution: Since this n8n workflow uses a manual n8n trigger, click 'Execute Workflow' or use the Test Run feature to process your contact list.

On clicking 'execute' (Manual Trigger): The starting point of this n8n workflow. This n8n trigger allows for manual execution, suitable for batch jobs processing large lists.
Google Sheets n8n node: Function is to retrieve the raw contact list. Key configuration includes reading columns A through K ("range":"A:K") using OAuth2 authentication.
Dropcontact n8n node: Serves as the enrichment engine. It maps input data fields like email, companyName, and website from the Google Sheets output. It is configured to request French specific data ("language":"fr").
Lemlist n8n node: The final action node, responsible for lead creation. It uses expression mapping (={{$node["Dropcontact"].json["email"][0]["email"]}}) to ensure only the verified, enriched data from the previous n8n node is pushed to the target sales campaign.