The Scenario
It is 4 PM on a Thursday and your SDR team closes its list-building sprint at 5. You have 150 qualified leads in an Excel workbook — columns A through D holding first name, last name, email, and company — and they all need to be inside the "Q3 Outbound" Lemlist campaign before EOD so sequencing can kick off Friday morning.
The bad version:
- Save the workbook as a CSV, open Lemlist, navigate to the campaign, click "Add leads," choose "Import from CSV," upload the file, and map each column by hand.
- Discover that two rows have blank email fields and the import errors out — go back to the workbook, fix the gaps, save, re-upload, and start over.
- Finish the import, verify in the Lemlist lead list, find that 12 rows duplicated because those emails were already in the campaign from a previous push, and spend 20 minutes manually removing them.
You are supposed to be handing the campaign brief to the copywriter right now, not managing a CSV re-upload loop.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives directly inside your Excel workbook. It reads your data and talks to Lemlist on your behalf — no CSV export, no upload UI, no column mapping dialog. Open the SheetXAI sidebar and type a single prompt.
Add each row as a new lead to the Lemlist campaign ID in cell F1, using columns A through D for first name, last name, email, and company — write "added" or the error into Column E
What You Get
- Every row processed against the Lemlist campaign specified in F1.
- Column E populated with "added" for each successful enrollment or the specific API error for any row that failed.
- Duplicate emails automatically skipped — Lemlist returns an error for existing leads, and SheetXAI logs it in Column E rather than silently dropping the row.
- Your Excel workbook stays open and live throughout — no CSV step, no re-upload if something goes wrong.
What If the Data Is Not Quite Ready
Some rows are missing a company name
Add each row in this workbook as a lead to the Lemlist campaign in cell F1 — if Column D (company) is blank, use the email domain instead — write "added" or the error into Column E
You only want rows where Column E is empty (first-time push only)
For each row where Column E is blank, add the lead to the Lemlist campaign in cell F1 using columns A through D — write "added" or the error into Column E
The campaign ID changes every quarter and lives in a named range
Add all rows with a non-blank email in Column C to the Lemlist campaign whose ID is in the named range CampaignID — use columns A, B, C, and D for first name, last name, email, and company — log the result in Column E
Full cleanup and enroll in one shot
Check Column C for blank or malformed emails and write "INVALID" into Column E for those rows — then for every remaining row, add the lead to the Lemlist campaign in cell F1 using columns A through D, and overwrite Column E with "added" or the API error
The pattern: ask for the data check and the action in the same prompt. SheetXAI handles both passes inline without you exporting a file between steps.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your next outbound list lives, then ask SheetXAI to enroll every row into your Lemlist campaign. Also worth reading: how to export campaign performance stats into a workbook, and the hub overview of all Lemlist workflows.