Lead Synchronization: Airtable to Lemlist Campaign - n8n Workflow

• Sales professionals needing to quickly onboard new leads into outreach campaigns.


• Marketing teams managing segmented lead lists in Airtable.


• Business owners looking for reliable n8n templates to sync CRMs and databases.


• Automation specialists seeking a robust example of a transactional n8n workflow.

Manually transferring lead data from a database like Airtable to an outreach platform like Lemlist is time-consuming and error-prone. This specialized n8n workflow solves this problem by creating a direct bridge between the two platforms. By utilizing the Airtable n8n node and the Lemlist n8n node, sales teams can ensure new leads are instantly enrolled in their dedicated email campaigns. This saves significant administrative time, allowing teams to focus on engagement. This robust n8n workflow provides a reliable, repeatable method for lead onboarding, making it a powerful addition to your library of n8n templates.

This n8n workflow executes a three-step process to ensure lead data moves efficiently from Airtable to Lemlist:

1. Data Retrieval (Airtable): The process begins when the n8n trigger (or manual execution) initiates the Airtable n8n node. This node connects to the specified base and table and retrieves a list of potential leads.


2. Lead Creation (Lemlist): The data retrieved from Airtable, specifically the email and name fields, is passed to the first Lemlist n8n node. This node is configured to create a new lead and instantly assign it to a pre-defined marketing campaign using its unique campaign ID. The mapping ensures the lead's email and name are correctly populated.


3. Verification (Lemlist): Following the creation attempt, the second Lemlist n8n node (Lemlist1) performs a 'Get Lead' operation using the original email address sourced from the Airtable n8n node. This step serves as an immediate verification that the lead was successfully created and allows the n8n workflow to retrieve the full, updated lead object from Lemlist for subsequent steps or logging.

To install and utilize this specific n8n workflow, follow these steps:

1. Import: Copy the provided JSON code and import it directly into your self-hosted or cloud n8n instance using the 'New' -> 'Import from JSON' function.


2. Airtable Credentials: Click on the 'Airtable' n8n node. You will need to set up new credentials for your Airtable API key if you haven't already. Ensure the credentials link to the base containing your lead data.


3. Lemlist Credentials: Click on both Lemlist n8n nodes. Configure your Lemlist API credentials. These credentials are vital for the n8n workflow to communicate with your Lemlist account.


4. Configuration: Update the 'Airtable' n8n node parameters to specify the exact Base ID and Table Name you wish to pull leads from.


5. Campaign ID: In the first 'Lemlist' n8n node, ensure you update the campaignId parameter (cam_H5pYEryq6mRKBiy5v in the example) to match the ID of the specific Lemlist campaign you want the leads added to.


6. Test: Execute the n8n workflow manually to ensure leads are fetched correctly and created within Lemlist.

Airtable n8n Node (Airtable)
Function: Retrieves records (potential leads) from a configured Airtable base/table. This acts as the primary data source for the n8n workflow.
Key Configuration: Operation is set to list to retrieve multiple records. The workflow relies on the output fields being named 'Email' and 'Name' for subsequent mapping.
Lemlist n8n Node (Lemlist)
Function: Creates a new lead in Lemlist and assigns it to a campaign.
Key Configuration: Resource set to lead. Email is mapped using ={{$json["fields"]["Email"]}} and First Name is mapped via ={{$json["fields"]["Name"]}}. Crucially, the target campaignId is specified, making this a focused sales automation n8n template.
Lemlist n8n Node (Lemlist1)
Function: Verifies the existence or retrieves the full details of the lead immediately after creation.
* Key Configuration: Resource set to lead and Operation is get. It uses an expression ={{$node["Airtable"].json["fields"]["Email"]}} to reference the original email address, ensuring the correct lead is checked.