The Scenario
You are a deliverability consultant. A client just brought you in because their MailerLite open rates dropped 8 percentage points in six weeks. Your working hypothesis is a list hygiene problem — too many hard bounces accumulating, too many unsubscribes happening in clusters after specific campaigns.
To test this you need every hard-bounce and unsubscribe event from the past 30 days in a spreadsheet. Your client's MailerLite account has ~14,000 active subscribers.
The bad version:
- You log into the client's MailerLite dashboard
- You navigate to Subscribers, filter by status: Bounced
- You export the CSV — 340 rows
- You do the same for Unsubscribed — 210 rows
- You open both CSVs in Google Sheets, merge them, add a Type column to distinguish them
- You realize the bounce export does not include bounce reason, just the subscriber record
- You go back to the MailerLite docs to find where bounce reason lives
- It is now 4 PM and you have not started the analysis.
The fast version is one prompt and you start the analysis before lunch.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that calls the MailerLite API for exactly the data you need and writes it into the Sheet in the shape you specify.
Open the SheetXAI sidebar and type:
Fetch all MailerLite subscribers with status 'bounced' and write their email, bounce reason, and the date their status changed into this sheet — one row per subscriber, newest first.
SheetXAI calls the MailerLite API, retrieves the bounce records, and writes them into the Sheet. Add a second prompt for unsubscribes, or include both in one instruction:
Fetch all MailerLite subscribers with status 'bounced' or 'unsubscribed' that changed status in the past 30 days. Write email, status, bounce reason (if applicable), and date of status change into this sheet — one row per subscriber.
What You Get
A Sheet ready for deliverability analysis:
- Email address for every bounced or unsubscribed subscriber
- Status type — bounced or unsubscribed — in a separate column
- Bounce reason — where available from the MailerLite API
- Date of status change — so you can correlate spikes with specific campaign sends
The date column is what makes the analysis possible. If 80 unsubscribes hit on the same day as a specific campaign, that is your signal. Without the date, it is just a list.
What If the Data Is Not Quite Ready
Deliverability audits often need more context than a status list. SheetXAI layers in additional data in the same prompt.
When you need per-subscriber activity history, not just current status
You want to know the sequence of events for the worst offenders — which campaigns they opened before bouncing, how long they were active.
Pull the activity log for each subscriber in column A with status 'bounced' and list every event type, campaign name, and event timestamp in this sheet — one event per row. Add a column for subscriber email so you can group by subscriber.
When you want to correlate bounces with specific campaigns
The working hypothesis is that one badly targeted campaign drove the bounce spike. You need bounces grouped by the campaign that triggered them.
Fetch all hard-bounce events from the past 30 days in MailerLite. Write subscriber email, bounce date, and the campaign name that triggered the bounce into this sheet. Then add a summary section at the bottom showing total bounces per campaign, sorted descending.
When you only want hard bounces, not soft bounces
Soft bounces are noise for a list hygiene audit. You want hard bounces only.
Fetch all MailerLite subscribers with status 'bounced' and bounce type 'hard' that changed status in the past 30 days. Write email, bounce reason, and date into this sheet.
When you want a full hygiene report: bounces, unsubscribes, and junk in one view
The client wants one document to share with their leadership showing the full picture of list decay.
Fetch all MailerLite subscribers with status 'bounced', 'unsubscribed', or 'junk' that changed status in the past 60 days. Write email, status, bounce reason (if applicable), and date into this sheet. Then add a summary row at the top broken down by status type with counts and the date range each covers.
The pattern: describe the shape of the audit you need. SheetXAI fetches, formats, and summarizes in the same prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to pull your MailerLite bounce and unsubscribe records for whatever date range you need. The MailerLite integration is included in every SheetXAI plan. For related workflows, see how to pull an account health snapshot or the MailerLite in Google Sheets overview.