The Scenario
You are a sales ops analyst building the targeting brief for next week's outbound push. Before creating new Lemlist campaigns, your team has a rule: check whether any of the 60 prospects on the new list are already in an active sequence. Reaching out to a lead who is already mid-campaign is a compliance and relationship risk. You need to know — for each email in the list — whether they exist in Lemlist and what their current status is.
The bad version:
- Open Lemlist, go to the contacts search, type the first email, note the result, tab back to the sheet, type it in.
- Repeat 59 more times.
- Realize 12 of the emails returned ambiguous results — the contact exists but is paused, or is in a campaign that was archived — and you are not sure how to interpret the status.
- After 45 minutes you are only on row 23.
You were supposed to have this brief ready for the head of sales by noon.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Google Sheet and runs every lookup against Lemlist in a single command — no tab-switching, no manual typing, no ambiguous status interpretation.
For each email in Column A, look up the lead in Lemlist and write their current campaign name and status into columns B and C — mark "Not Found" if they don't exist
What You Get
- Column B populated with the name of the most recent or active Lemlist campaign for each email.
- Column C showing the lead's current status: active, replied, interested, not interested, paused, or unsubscribed.
- Rows where the email does not exist in Lemlist clearly marked "Not Found" — no blank cells that you have to guess the meaning of.
- All 60 rows completed in one prompt run.
What If the Data Is Not Quite Ready
You want all campaign memberships, not just the most recent
Check every email in Column A against Lemlist and write all campaign names the lead has been enrolled in into Column B (comma-separated) and their current status in Column C
You want to auto-flag leads who are already active
For each email in Column A, look up the lead in Lemlist and write campaign name in Column B and status in Column C — then add "DO NOT ENROLL" in Column D for any lead whose status is "active" or "replied"
You need to pull additional lead details alongside status
Look up each email in Column A in Lemlist — write campaign name in Column B, status in Column C, and the date they were added to Lemlist in Column D — mark "Not Found" for any email with no record
Full pre-campaign audit in one shot
For each email in Column A, look up the lead in Lemlist — write their most recent campaign name in Column B, current status in Column C, and whether they are safe to enroll in Column D (mark "SAFE" if status is "Not Found" or "not interested"; mark "HOLD" for any other status) — then count total SAFE and total HOLD leads and write the counts into cells F1 and F2
One prompt, and you have a targeting brief with a clear enroll-or-hold decision for every lead on the list.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where your next prospect list lives, then ask SheetXAI to check every email against Lemlist before you build the campaign. You might also want to read how to bulk-enroll the safe leads afterward, or return to the hub overview.