The Scenario
You are an AE who just got assigned three deals that were being worked by a rep who left last week. The previous rep ran all their outreach through Lemlist. You have a Google Sheet with 15 prospect emails, and before you reach out to any of them, you need the full message history — what was sent, when, what they replied — so you are not walking into a first call cold on accounts that already had five touchpoints with your company.
The bad version:
- Open Lemlist, go to the first contact's profile, read through the thread, take notes.
- Open your sheet, type a summary of what you found into Column B.
- Repeat for all 15 contacts.
- Realize that two contacts have the same first name and you mixed up their threads mid-way through, go back and fix your notes.
You have 15 discovery calls booked for next week. This exercise is eating the time you were supposed to use to research the companies.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Google Sheet and retrieves Lemlist contact histories directly, so you can pull message threads for every contact in the list without leaving the spreadsheet.
For each contact email in Column A, fetch the full message history from Lemlist and write the last message subject and date into columns B and C
What You Get
- Column B populated with the subject line of the most recent message sent to each contact.
- Column C showing the date of that last touchpoint.
- Any contact not found in Lemlist returned with "Not Found" rather than a blank — so you know the absence is real, not a failed lookup.
- All 15 rows completed in a single prompt run, each attributed to the correct contact.
What If the Data Is Not Quite Ready
You want the full thread written into a single cell per contact
Look up the Lemlist conversation thread for every email in Column A and write a concatenated message history into Column B — most recent message first — 15 rows total
You also want to know the campaign each contact was enrolled in
For each email in Column A, look up the contact in Lemlist and write their most recent campaign name into Column B, last message subject into Column C, and last activity date into Column D
You need to flag contacts who never replied
For each email in Column A, fetch the Lemlist message history and write the last message subject and date into columns B and C — add "NO REPLY" in Column D for any contact who was messaged but never responded
Full context brief in one shot
For each email in Column A, retrieve the full Lemlist thread — write the campaign name in Column B, number of messages sent in Column C, last message subject in Column D, last message date in Column E, and whether they replied (Yes or No) in Column F — leave Column G blank for your call prep notes
You get a pre-call context sheet without clicking through 15 separate Lemlist contact profiles.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your inherited prospect list, then ask SheetXAI to pull the Lemlist message history for every contact. Also worth reading: how to export engaged leads for CRM handoff, or the hub overview of all Lemlist workflows.