Auto-enroll Airtable prospects into Lemlist with a custom icebreaker

When a new prospect lands in Airtable, find their verified email, write a one-line icebreaker, and add them to the right Lemlist campaign.

Agentic Task
AirtableLemlistSalesOperationsLead EnrichmentEmail AutomationData Sync
PromptCreate

Build me an agent workflow that automatically enrolls new Airtable prospects into a Lemlist campaign with a personalized icebreaker.

Trigger: poll my Airtable Prospects table for new records (new_record event). I'll wire up the base, table, and the Airtable connection when I install the workflow.

For each new row, do the following:

1. Read the prospect's first name, last name, company, role, any research notes I pasted into the row, and the Lemlist campaign slug from a field on the row (call it campaignSlug).

2. Call the Lemlist Enrich Data operation with the prospect's first name, last name, and company to find a verified email and LinkedIn URL. Enrichment is async: Lemlist returns an enr_ id, so wait for the job to finish before using the result (poll the enrichment status on a short interval, with a sensible timeout).

3. If enrichment fails to return a verified email, skip the row entirely. Do not enroll the lead and do not update Airtable. I do not want to burn campaign capacity or sender reputation on bad data.

4. If we got a verified email, generate a one-sentence personalized icebreaker. Ground it in the prospect's company, role, or the research notes from the row. No generic compliments like "love what you're building" or "impressed by your growth." It should sound like a human read their LinkedIn and the notes, and picked one specific hook.

5. Call the Lemlist Create Lead in Campaign operation against the campaignSlug from the row. Pass firstName, lastName, companyName, linkedinUrl, and the icebreaker as custom variables so my sequence template can reference {{icebreaker}}, {{firstName}}, etc.

6. Call the Airtable Update Record operation on the original row to set status to "Enrolled" and write the verified email into the email field. This keeps Airtable as the source of truth.

Use an agent workflow (not a deterministic graph) because the icebreaker quality and the skip-on-bad-enrichment decision both need judgement. Log each step so I can see why a row was skipped or enrolled when I open the run.

What does this prompt do?

  • Watches your Airtable Prospects table for new rows.
  • Finds a verified email and LinkedIn profile for each prospect using Lemlist's built-in enrichment.
  • Writes a one-sentence icebreaker grounded in the prospect's company or role, never a generic compliment.
  • Adds the prospect to the Lemlist campaign you picked on the row, with first name, last name, company, LinkedIn URL, and the icebreaker ready for your sequence.
  • Marks the Airtable row as Enrolled and writes the verified email back so your list stays the source of truth.

What do I need to use this?

  • An Airtable base with a Prospects table that holds first name, last name, company, role, any research notes, and a field for the Lemlist campaign you want each prospect to land in.
  • A Lemlist account with at least one active campaign and enrichment credits available.
  • A status column on the row so the workflow can mark it Enrolled when it finishes.

How can I customize it?

  • Point the trigger at a different table or filter to a specific view (for example, only rows tagged Ready to enroll).
  • Tune the icebreaker instructions to match your voice, a specific angle, or a recent company event.
  • Change how the workflow handles bad enrichment, either by skipping silently or by moving the row to a manual review view.

FAQs

Will this enroll prospects without a verified email?
No. If enrichment cannot find a verified email, the workflow skips the row so you do not burn campaign capacity on bad data.
Can different prospects flow into different Lemlist campaigns?
Yes. The workflow reads the campaign from a field on each Airtable row, so you can route prospects into whichever campaign you want by editing that one cell.
What custom variables get passed to my Lemlist sequence?
First name, last name, company name, LinkedIn URL, and the generated icebreaker. You can reference all of them in your sequence template, for example using the icebreaker as the opening line of email one.
How quickly does a new row get enrolled?
Within minutes of the row appearing in your Prospects table. The workflow polls Airtable on a short interval and runs as soon as it sees a new record.
Do I need to clean up the row before the workflow runs?
No. Paste in the prospect's name, company, role, and any research notes you have. The agent does the enrichment, writes the icebreaker, and updates the row when it is done.

Related templates

Review and approve Lemlist openers before anyone gets enrolled

Stage a batch of prospects, let an agent draft a personalized opener for each one, then approve them line by line before a single lead enters a campaign.

Lemlist
Google Sheets
HubSpot
App
Work your Lemlist replies as people, not campaign rows

Open one queue every morning with every interested reply across all your campaigns, deduped to one row per human, with research and CRM handoff built in.

Lemlist
HubSpot
App
Lemlist campaign comparison board for outbound teams

Put four or five Lemlist campaigns side by side on the same rates, see where leads stall, and get an on-demand diagnosis of what to fix.

Lemlist
Google Sheets
App
Creator roster board for rebook, test, or pause calls

Decide who stays on your creator roster after every campaign, with each creator's real numbers on screen and every call recorded where the team can see it.

Later
Airtable
Slack Bot
App
Run your nutrition clients' weekly meal plans from one console

See who is due, build a week of dinners on demand, swap anything you do not like, then send the recipe and grocery links yourself.

Instacart
Airtable
Gmail
App
Instagram UGC rights tracker and repost approval board

See every customer photo that tags your brand, ask for permission in one click, and repost only once a yes is on the record.

Instagram
Airtable
Slack Bot
App

Stop writing icebreakers row by row.

Connect Airtable and Lemlist once, and Geni enrolls every new prospect with a personalized opener and a verified email.