The Scenario
You are a growth marketer and your hyper-personalized cold email campaign launches in 48 hours. You've spent a week writing custom icebreaker copy — one sentence per lead, referencing something specific about their company or recent news — and it's all sitting in Column C of your Excel workbook: 200 rows, 200 unique icebreakers. Every lead is already in Lemlist. The sequence is ready. The only thing left is pushing the "icebreaker" custom variable to each lead in Lemlist so the personalization tokens actually resolve when emails go out.
The bad version:
- Open the first lead's Lemlist profile, click "Edit," find the custom variables section, paste the icebreaker from the workbook, save.
- Repeat 199 more times.
- Realize partway through that you lost your place and are not sure whether row 87 was already updated.
- Spend the last two hours before launch verifying entries rather than doing QA on the sequence.
You wrote these icebreakers to make the campaign feel human. Spending hours on data entry to get them into Lemlist is the opposite of that.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your workbook and writes custom variables to Lemlist leads in bulk — no profile clicking, no copy-paste, no lost-place risk.
For each row in this workbook, add the value in Column C as the "icebreaker" custom variable to the Lemlist lead with email in Column A — write success or error into Column D
What You Get
- All 200 Lemlist lead profiles updated with the icebreaker text from Column C.
- Column D showing "success" for each updated lead or the specific error if a lead could not be found or updated.
- Any failed rows clearly identifiable so you can fix them specifically rather than re-running the entire batch.
- The campaign ready to launch with personalization tokens populated across every contact.
What If the Data Is Not Quite Ready
You need to push two custom variables at once
Update every Lemlist lead in Column A with the custom variable "industry" from Column B and "company_size" from Column C — write "updated" or the error into Column D — 200 rows total
Some leads might not be in Lemlist yet
For each row in this workbook, try to update the Lemlist lead in Column A with the "icebreaker" variable from Column C — if the lead does not exist in Lemlist, write "NOT FOUND" in Column D and skip the update
You want to verify the update landed correctly
Update each Lemlist lead in Column A with the icebreaker custom variable from Column C, then fetch the stored icebreaker value back from Lemlist and write it into Column E for comparison — log success or error in Column D
Full pre-launch enrichment in one shot
For each row where Column D is blank (not yet processed): update the Lemlist lead in Column A with the "icebreaker" variable from Column C and the "industry" variable from Column B — write "enriched" into Column D on success, or the error on failure — when done, count total enriched and total failed and write the counts into cells F1 and F2
Your personalization is live across 200 contacts before lunch.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your pre-campaign personalization data, then ask SheetXAI to push every custom variable to Lemlist before your sequence goes live. See also: how to bulk-enroll leads into a campaign, or return to the hub overview.