The Scenario
Monday morning. You manage eight active Lemlist campaigns and your sales director wants to see which sequences to scale and which to kill — before the pipeline review at 11. The data you need is all in Lemlist: campaign name, emails sent, open rate, reply rate, number of interested leads. But it's spread across eight separate campaign dashboards, and pulling it into a single Google Sheet by hand means eight separate export-and-paste operations that you do not have time for.
The bad version:
- Open the first campaign in Lemlist, navigate to the analytics tab, note the numbers, switch to your sheet, type them in.
- Repeat seven more times, switching tabs back and forth, losing your place twice.
- Finish, realize you forgot to add the "interested" column because Lemlist's export does not include it by default, go back and re-check each campaign manually.
You are a sales manager, not a data-entry clerk. The meeting is in two hours.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Google Sheet and connects directly to Lemlist, so you can pull all campaign stats in one command. No tab-switching, no manual copy, no missing columns.
Fetch stats for all active Lemlist campaigns and write campaign name, emails sent, open rate, reply rate, and interested count into columns A through E of this sheet
What You Get
- One row per active campaign, written starting at row 1 (or wherever you point the prompt).
- Columns A through E: campaign name, emails sent, open rate (as a percentage), reply rate (as a percentage), and interested-lead count.
- Any campaign with zero emails sent listed as a row with zeros rather than silently omitted.
- The sheet ready to sort and filter the moment the prompt finishes.
What If the Data Is Not Quite Ready
You only want campaigns active in a specific date range
Pull Lemlist campaign stats for the date range in cells A1 and B1 — list every campaign's name, emails sent, open rate, reply rate, and interested count in this sheet starting at row 3
You want a calculated column added inline
Fetch stats for all active Lemlist campaigns, write name, emails sent, open rate, and reply rate into columns A through D, and add a "reply-to-open ratio" column in E — calculated as reply rate divided by open rate
You only care about campaigns above a reply-rate threshold
Pull stats for all active Lemlist campaigns and write only those with a reply rate above 10% into this sheet — columns: campaign name, open rate, reply rate, interested count
Full pull plus summary row in one shot
Fetch all active Lemlist campaign stats, write campaign name, emails sent, open rate, reply rate, and interested leads into columns A through E, and add a totals and averages row at the bottom of the data — then flag any campaign with a reply rate below 5% by writing "REVIEW" in Column F
Describing what you want plus what the finished sheet should look like means you get both the data and the analysis in a single step.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet you use for pipeline reviews, then ask SheetXAI to pull your current Lemlist campaign stats. You can also explore how to bulk-enroll leads into a campaign, or return to the hub overview for all Lemlist workflows.