The Scenario
You are an email programme manager at a media company. The annual marketing review is in three weeks. You need to present 12 months of Mailchimp audience growth, net new subscribers, churn, and bounces per month, in a Google Sheet so the data team can build the charts for the deck.
You have been on Mailchimp for four years. The data is all there. Getting it out cleanly is the problem.
The bad version of the next few days:
- You go into Mailchimp's audience section and look for a growth history export
- You find the growth chart in the dashboard but there is no direct CSV export for monthly breakdowns
- You try the Reports section, find that growth history is buried under Audience Activity
- You export what you can, open it in Google Sheets, and discover the format needs significant cleanup before it is chart-ready
- You manually compile the monthly numbers from three separate exports
- The data team gets the file two days before the review with no time to validate it.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that calls the Mailchimp API's audience growth history endpoint and writes the monthly breakdown directly into the sheet.
Open the SheetXAI sidebar and type:
Fetch monthly growth history for Mailchimp audience ID in cell A1 for all of 2025 and write each month's new subscribers, opt-ins, unsubscribes, cleaned bounces, and net growth into this sheet. One row per month.
SheetXAI fetches the full year of monthly data from the Mailchimp API and writes one row per month into the sheet. No export wizard, no manual cleanup, no combining files.
What You Get
Twelve rows, one per month, with every growth metric you need:
- New subscribers — total new additions including imports
- Opt-ins — subscribers who confirmed double opt-in
- Unsubscribes — contacts who opted out
- Cleaned bounces — contacts Mailchimp automatically removed after hard bounces
- Net growth — calculated as new minus unsubscribed minus bounced
The data team has a chart-ready file the same day you ask. No reformatting, no pivot tables to build before they can even start.
Want a calculated column for net subscriber change? Ask SheetXAI to add it in the same prompt.
What If the Data Is Not Quite Ready
Growth history reports often need additional context or formatting for a presentation audience. SheetXAI handles enrichment in the same prompt.
When you want the net change calculated as a formula column
The data team prefers a column that auto-updates if you re-run the pull, not a static value.
Fetch monthly growth history for Mailchimp audience ID in cell A1 for 2025. Write new subscribers into column B, unsubscribes into column C, and cleaned bounces into column D for each month in column A. In column E, write a formula =B-C-D to calculate net change per month.
When you need to compare two audiences side by side
Your Mailchimp account has a main newsletter audience and a product updates audience. The review needs both in one sheet.
Fetch monthly growth history for Mailchimp audience ID in cell A1 for all of 2025 and write it into columns A through F. Then fetch monthly growth history for audience ID in cell H1 for the same period and write it into columns H through M, with the same month labels in column H.
When the presentation needs a running total column to show absolute list size over time
The exec team wants to see not just monthly change but where the total subscriber count stood at the end of each month.
Fetch monthly growth history for Mailchimp audience ID in cell A1 for all of 2025. Write month, new subscribers, unsubscribes, and cleaned bounces into columns A through D. In column E, write the cumulative net subscriber count starting from the value in cell G1 as the starting list size, adding each month's net change.
When you need three years of history for a long-range trend analysis
The marketing review wants to show growth over the full life of the programme, not just the last year.
Fetch monthly growth history for Mailchimp audience ID in cell A1 for 2023, 2024, and 2025 and write all months into this sheet in chronological order: month label, new subscribers, unsubscribes, cleaned bounces, and net growth. One row per month, 36 rows total.
The pattern: pull the raw growth data, then add calculated columns or multi-audience comparisons in the same prompt. The sheet is ready for the data team the same day.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to pull your Mailchimp audience growth history. The Mailchimp integration is included in every plan. For related workflows, see how to export a full audience health audit or the Mailchimp in Google Sheets overview.