The Scenario
You are a growth marketer. You launched an onboarding automation for 2,000 new subscribers three weeks ago. The automation has five steps. You want to know how many subscribers reached each step — but the MailerLite dashboard only shows aggregate counts for the whole automation, not step-by-step breakdown by individual subscriber.
The board meeting is in two days. You need step-by-step completion rates in a Google Sheet for the funnel slide.
The bad version:
- You open MailerLite's Automations section and look for an export
- There is no CSV export for individual subscriber activity within an automation
- You click through to the analytics view — it shows aggregate numbers, not per-subscriber step data
- You contact support and learn you need the API to get subscriber-level activity
- You put in a request for a developer to pull it
- The developer gets back to you after the board meeting.
The fast version is one prompt and the data is in the Sheet before lunch.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that pulls subscriber-level automation activity from MailerLite and writes it into the Sheet so you can calculate your own completion rates.
Open the SheetXAI sidebar and type:
Pull automation activity for MailerLite automation [ID] for all statuses and write subscriber email, status (active/completed/cancelled), and entry date into this sheet — then add a count row at the bottom broken down by status.
SheetXAI calls the MailerLite automation subscribers API, writes every subscriber and their status into the Sheet, and adds the summary count row. You have the raw data and the aggregate in one place.
What You Get
A Sheet with full automation activity for your funnel analysis:
- Subscriber email for every subscriber who entered the automation
- Status — active, completed, or cancelled — in a separate column
- Entry date — so you can see the cohort breakdown over time
- Count row at the bottom — broken down by status so the aggregate is right there
The count row is the board slide number. The per-subscriber rows are your safety net if anyone asks to dig into a specific cohort.
What If the Data Is Not Quite Ready
Funnel analyses always need more slicing than a simple status breakdown. SheetXAI handles it in the same prompt.
When you want only active subscribers and the step they are on
The board wants to know which step is the biggest drop-off point — how many subscribers are stuck at step 3 versus step 4.
Fetch all subscriber activity for MailerLite automation [ID] with status 'active' and write each subscriber's email and the step they are currently on into this sheet. Then add a count row at the bottom showing how many subscribers are on each step number.
When you want to compare completion rates across two automations
You ran a revised version of the onboarding automation starting last month. You want to compare completion rates between the old version and the new version.
Pull automation activity for MailerLite automation [ID1] and write subscriber email, status, and entry date into columns A, B, C with 'Automation 1' in column D. Then pull automation activity for MailerLite automation [ID2] and append the rows below with 'Automation 2' in column D. Add a summary section showing completion rate for each automation.
When you only want subscribers who entered in the past 30 days
You want a recent cohort, not all historical subscribers.
Fetch all subscriber activity for MailerLite automation [ID] where entry date is in the past 30 days. Write subscriber email, status, and entry date into this sheet. Add a count row broken down by status.
When you want the full funnel: entry, current step, time in automation, and completion flag
The VP of Growth wants a complete picture for each subscriber — not just whether they completed, but how long they took.
Pull all subscriber activity for MailerLite automation [ID]. Write subscriber email, status, entry date, and current step into this sheet. Add a column calculating the number of days since entry. Add a COMPLETED column that says TRUE if status is 'completed' and FALSE otherwise. Add a summary row at the bottom showing total count, completion rate, and average days to completion.
The pattern: start with the raw activity pull, then describe the analysis you need. SheetXAI writes the data and adds the derived columns in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to pull subscriber activity for the MailerLite automation you want to analyze. The MailerLite integration is included in every SheetXAI plan. For related workflows, see how to export campaign stats for a performance review or the MailerLite in Google Sheets overview.