The Scenario
You just wrapped a trade show. Your SDR manager hands you an Excel workbook with 50 contacts from the event: name, email, company, and a "Disposition" column — "Interested," "Not Interested," or "Pause" — based on booth conversations. All 50 are already in Lemlist from a pre-event campaign. The dispositions need to be synced back to Lemlist today so follow-up sequencing respects them. The reps who worked the event are back in their home offices. You need this done before the morning standup.
The bad version:
- Open Lemlist, search for the first lead by email, open their profile, click to update their status, save.
- Repeat for 49 more contacts.
- Realize the Lemlist status options do not exactly match the disposition labels in the workbook, spend time mapping "Pause" to whatever Lemlist calls it.
- After an hour, you're 20 contacts in.
This is not analysis. This is data entry. You are supposed to be running the post-event retro.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your workbook and updates Lemlist lead statuses in bulk from a single command — no profile-by-profile clicking, no manual status mapping.
Read Column A (email) and Column B (disposition) in this workbook — if disposition is "Interested" mark the lead interested in Lemlist; if "Not Interested" mark them not interested — log the outcome in Column C
What You Get
- Every lead in Column A updated in Lemlist with the status corresponding to their Column B disposition.
- Column C populated with "updated" for each successful status change or the error for any lead that could not be found.
- Paused leads handled separately or flagged in Column C if you include that instruction.
- All 50 rows processed without you touching the Lemlist UI.
What If the Data Is Not Quite Ready
The disposition column includes a third value
Read Column A (email) and Column B (disposition) — if "Interested" mark the lead interested in Lemlist; if "Not Interested" mark not interested; if "Pause" pause the lead — log the outcome in Column C
Some leads might not exist in Lemlist yet
For each row where Column B is "Interested" or "Not Interested," update the Lemlist lead in Column A accordingly — if the lead does not exist in Lemlist, write "NOT IN LEMLIST" in Column C
You want to update custom variables at the same time
For each row in this workbook, update the Lemlist lead in Column A with status from Column B and also set the custom variable "event_name" to the value in Column C — log the result in Column D
Full post-event sync in one shot
For each row where Column B is "Interested," mark the lead in Lemlist as interested and set the custom variable "booth_notes" to Column C — for "Not Interested" rows, mark not interested — for "Pause" rows, pause across all campaigns — write "done" or the error into Column D
One prompt handles all three disposition types across all 50 contacts before your first coffee of the day.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook from your next event debrief, then ask SheetXAI to sync all dispositions back to Lemlist in one shot. See also: how to bulk-enrich leads with custom variables, or return to the hub overview.