The Scenario
You are the email programme manager at a media company. Every Monday morning you update the ops dashboard. 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 Sheet. 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 Sheet before you have finished your coffee.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that pulls the MailerLite account stats and writes them directly into the cells you specify — so no reading numbers off a screen, no transposing, no second-guessing.
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 sheet.
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 dashboard 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, not from your memory of what you saw on screen two minutes ago. If the cells already have last week's numbers, SheetXAI overwrites them with the current values.
Want a timestamp next to the row? Tell SheetXAI: "Also write today's date into cell A2." Done.
What If the Data Is Not Quite Ready
Ops dashboards 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. You want those below the account-level summary.
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 dashboard tracks week-over-week trends. Each Monday's numbers should be appended as a new row, not overwrite the previous one.
Fetch MailerLite subscriber stats for this account. Append a new row at the bottom of this sheet 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 recent bounce rate as a derived metric
The compliance team tracks bounce rate as a percentage of total. You want it calculated and flagged 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 in one pull
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 sheet 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 dashboard sheet, 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 a Sheet or the MailerLite in Google Sheets overview.