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 Excel workbook by hand means eight separate export-and-paste operations you do not have time for.
The bad version:
- Open the first campaign in Lemlist, navigate to analytics, note the numbers, switch to your workbook, type them in.
- Repeat seven more times, switching windows back and forth, losing your place twice.
- Finish, realize the "interested" count was not in the default export — go back and 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 Excel workbook and connects directly to Lemlist, so you can pull all campaign stats in one command. No window-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 workbook
What You Get
- One row per active campaign, written starting at row 1.
- Columns A through E: campaign name, emails sent, open rate, reply rate, and interested-lead count.
- Any campaign with zero emails sent included as a row with zeros rather than silently omitted.
- The workbook 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 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 workbook — 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, add a totals and averages row at the bottom, then flag any campaign with a reply rate below 5% by writing "REVIEW" in Column F
Describing the data, the output columns, and the analysis together means you get the reporting workbook and the decision-support layer in one step.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook 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.