The Scenario
You are a sales ops manager and your VP wants a pipeline review slide ready by 9 AM Tuesday. One of the inputs is the activity log for "Enterprise Fall" — the last 100 events: what happened, to which lead, when. This is the data that shows whether the campaign is alive or stalling. You need it in an Excel workbook before Monday evening so you can format it for the slide.
The bad version:
- Open Lemlist, navigate to the "Enterprise Fall" campaign, click the activity log.
- The log shows 25 events per page. Click through four pages, copying data from each.
- Open Excel, paste page one, notice the column order changed on page three, fix the paste manually.
- Realize you are missing actual timestamps because Lemlist's log shows relative dates in the UI.
The review is 12 hours away. You are troubleshooting a format problem instead of building a slide.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects directly to Lemlist's API and writes activity log data into your workbook with real timestamps — no pagination, no copy-paste, no format guessing.
Fetch the last 100 activity events from Lemlist campaign "Enterprise Fall" and write lead email, activity type, and timestamp into columns A through C
What You Get
- Up to 100 rows, one per activity event, written into columns A through C.
- Column A: the lead's email. Column B: the activity type (email sent, opened, clicked, replied, etc.). Column C: the exact timestamp.
- Results ordered from most recent to oldest unless you ask otherwise.
- No pagination gaps — SheetXAI handles multi-page responses in one pass.
What If the Data Is Not Quite Ready
The campaign ID is in a cell rather than typed by name
Pull all activities from the Lemlist campaign ID in cell A1 and list them in this workbook — one row per event — with activity type in Column A, lead email in Column B, and date in Column C
You only care about a specific activity type
Fetch all reply events from Lemlist campaign "Enterprise Fall" and write lead email, activity type, and timestamp into columns A through C
You want to see activities for multiple campaigns side by side
Fetch the last 50 activity events from each of the Lemlist campaign IDs in Column A — write campaign name, lead email, activity type, and timestamp into columns B through E — one row per event, all campaigns combined
Full activity audit in one shot
Pull the last 100 events from Lemlist campaign "Enterprise Fall," write lead email, activity type, and timestamp into columns A through C — then add a Column D that flags any lead who appears more than once as "MULTIPLE TOUCHES," and add a summary row at the bottom counting total events by activity type
The pattern: pull the raw log, add the calculated flags, and get the summary count in the same prompt. Your review slide data is ready before you would have finished page two of the manual export.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook you use for pipeline reporting, then ask SheetXAI to pull the activity log for any Lemlist campaign. Also see: how to export campaign performance stats across all active campaigns, or the hub overview.