The Scenario
You are the email programme manager at a media company. Every Monday morning you update the ops workbook. One tab is the MailerLite health row — total subscribers, active, unsubscribed, bounced, unconfirmed, and junk — for the weekly stakeholder update.
Every Monday you open MailerLite, navigate to the Subscribers overview, read the six numbers off the screen, and type them into the workbook. It takes four minutes. It is mind-numbing. And two Mondays ago you transposed two digits in the bounced count and nobody caught it for three weeks.
The fast version is one prompt and the numbers are in the workbook before you have finished your coffee.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that pulls the MailerLite account stats and writes them directly into the cells you specify.
Open the SheetXAI sidebar and type:
Fetch MailerLite subscriber stats for this account and write total subscribers, active, unsubscribed, unconfirmed, bounced, and junk counts into cells B2 through G2 of this workbook.
SheetXAI calls the MailerLite account stats API and writes the six numbers into the specified cells. The dashboard updates in seconds.
What You Get
The ops workbook row, populated from the API:
- Total subscribers in B2
- Active in C2
- Unsubscribed in D2
- Unconfirmed in E2
- Bounced in F2
- Junk in G2
No manual reading, no transposition errors. The numbers come from the API. If the cells already have last week's numbers, SheetXAI overwrites them with the current values.
What If the Data Is Not Quite Ready
Ops workbooks always need more than a single summary row. SheetXAI adds the layers you need in the same prompt.
When you also want group-level subscriber counts
The stakeholder update includes counts for three key groups: Prospects, Customers, and Re-Engagement.
Fetch MailerLite subscriber stats for this account and write total, active, unsubscribed, unconfirmed, bounced, and junk counts into cells B2 through G2. Then fetch the subscriber count for each group and write the group name and count as additional rows starting at row 4, sorted by count descending.
When you want a rolling history, not just the current snapshot
The workbook tracks week-over-week trends. Each Monday's numbers should be appended as a new row.
Fetch MailerLite subscriber stats for this account. Append a new row at the bottom of this workbook with today's date in column A, and total, active, unsubscribed, unconfirmed, bounced, and junk counts in columns B through G.
When you want the health snapshot plus bounce rate as a derived metric
The compliance team tracks bounce rate as a percentage of total and wants a flag if it exceeds 2%.
Fetch MailerLite subscriber stats and write total, active, unsubscribed, unconfirmed, bounced, and junk into cells B2 through G2. In cell H2, calculate the bounce rate as bounced divided by total, formatted as a percentage. In cell I2, write 'ACTION REQUIRED' if the bounce rate exceeds 2%, otherwise write 'OK'.
When you want the full account snapshot plus the last 7 days of campaign performance
The weekly update combines the subscriber health row and the most recent campaign stats.
Fetch MailerLite subscriber stats and write total, active, unsubscribed, unconfirmed, bounced, and junk into cells B2 through G2. Then fetch all campaigns sent in the past 7 days and write campaign name, send date, open rate, and click rate into this workbook starting at row 5 — one row per campaign.
The pattern: describe the cells you want populated and the shape of any additional data. SheetXAI writes it all in one pass.
Try It
Get the 7-day free trial of SheetXAI and open your ops workbook, then ask it to pull the MailerLite account health stats and write them into the cells you specify. The MailerLite integration is included in every SheetXAI plan. For related workflows, see how to export campaign stats to an Excel workbook or the MailerLite in Excel overview.