The Scenario
You are the email marketing manager at a media company. The monthly marketing review is Thursday. Your director wants a Google Sheet showing every campaign sent in the past 60 days — name, send date, open rate, click rate, and unsubscribe count — ready for the deck.
You have forty-three campaigns in MailerLite from the past two months.
The bad version:
- You open MailerLite and go to Campaigns
- You click into the first campaign, find the stats tab, note down the numbers
- You switch to Google Sheets, find the right row, paste them in
- You go back to MailerLite, click into the second campaign
- You do this forty-three times
- You transpose a number on campaign 31 and spend ten minutes at the review explaining why open rates went negative
- Your director stops trusting the data and asks for the raw CSV next time anyway.
The fast version is one prompt and the Sheet populates itself.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads campaign data from MailerLite and writes it into the Sheet so you never click through individual campaigns.
Open the SheetXAI sidebar and type:
List all sent MailerLite campaigns from the past 60 days and write campaign name, send date, sent count, open rate, click rate, and unsubscribe count into this sheet — one row per campaign, newest first.
SheetXAI calls the MailerLite campaigns API, retrieves all 43 campaigns, and writes them into the Sheet. Every number comes from the API directly, not from your memory of clicking through 43 tabs.
What You Get
A populated Sheet ready for the monthly review:
- Campaign name — exactly as named in MailerLite
- Send date — formatted as a date, not a timestamp
- Sent count, open rate, click rate, unsubscribe count — one row per campaign
- Newest campaign first — so the most recent performance is at the top
No manual entry. No transposition errors. If the director wants to sort by click rate instead, they can do it in the Sheet — the data is already there.
Want to add a formula column for click-to-open rate? Tell SheetXAI: "Add a CTOR formula in column G dividing click rate by open rate." It adds the formula to every row.
What If the Data Is Not Quite Ready
Campaign datasets rarely arrive in the format a review needs. SheetXAI handles reformatting and analysis in the same prompt.
When the date format needs to match the existing dashboard
Your ops dashboard uses MM/DD/YYYY and MailerLite returns ISO dates.
Fetch all sent MailerLite campaigns from the past 60 days and write them into this sheet with the send date formatted as MM/DD/YYYY in column B. Use campaign name, sent count, open rate, click rate, and unsubscribe count in columns A and C–F.
When you only want campaigns above a certain send volume
The review focuses on campaigns with more than 1,000 recipients. Smaller sends are internal tests that clutter the table.
List all sent MailerLite campaigns from the past 60 days with a sent count above 1,000. Write campaign name, send date, open rate, click rate, and unsubscribe count into this sheet — one row per campaign.
When you need a summary row at the bottom
The director wants totals and averages across the period, not just row-level data.
Fetch all sent MailerLite campaigns from the past 60 days and write them into this sheet. Then add a summary row at the bottom showing total sent count, average open rate, average click rate, and total unsubscribes across the period.
When you want bounce counts added and a performance flag column
The full audit needs bounce data, and you want a quick visual flag for underperforming campaigns.
Fetch all sent MailerLite campaigns from the past 90 days. Write campaign name, send date, opens, unique opens, clicks, unsubscribes, and bounce count into this sheet — one row per campaign. Then add a column H that says 'Review' if open rate is below 20% or unsubscribes exceed 50, and 'OK' otherwise.
The pattern: describe the shape of the output you need, not just the fetch. SheetXAI formats and annotates in the same prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to pull your MailerLite campaign stats for whatever date range you need. The MailerLite integration is included in every SheetXAI plan. For related workflows, see how to pull a MailerLite account health snapshot or the MailerLite in Google Sheets overview.