The Scenario
You just wrapped a trade show. Your SDR manager hands you a Google Sheet with 50 contacts from the event: name, email, company, and a "Disposition" column — "Interested," "Not Interested," or "Pause" — based on conversations the reps had at the booth. 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 sheet, and 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 sheet and updates Lemlist lead statuses in bulk from a single command — no profile-by-profile clicking, no manual status mapping.
For each row in this sheet, mark the Lemlist lead in Column A (email) as interested or not interested based on the value in Column B, and write the result into 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 message 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 uses different labels
Read Column A (email) and Column B (disposition) — if disposition is "Interested" mark the lead interested in Lemlist; if "Not Interested" mark them 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 instead of failing
You want to update custom variables at the same time as the status
For each row in this sheet, update the Lemlist lead in Column A with status from Column B (Interested or Not Interested) 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 the value in Column C — for rows where Column B is "Not Interested," mark not interested — for rows where Column B is "Pause," pause the lead across all campaigns — write "done" or the error into Column D for every row
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 Google Sheet 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.