Mailchimp06:30
Written to Campaign results
Mailchimp campaign reports in Google Sheets, refreshed on a schedule
Your Mailchimp campaign results, written into a tab you choose, and current before you open the file.
30 days of Plus, free, no card. Then one report keeps refreshing weekly.
MailchimpMailchimp06:31
Written to Opens and clicks
Mailchimp06:32
Written to Sends by audience
Fields
What you can pull from Mailchimp
One row for each campaign sent in your date range, with the fields you choose.
Send dateCampaignSubject lineAudienceCampaign typeCampaign ID
Emails sentUnique opensTotal opensOpen rateUnique clicksTotal clicksUnsubscribesHard bouncesSoft bouncesSpam complaintsForwards
Dates are in your Mailchimp account's time zone.
What lands
Last week's campaigns, already in the tab
06:30
Mailchimp, written to Campaign results
September newsletter4,812
Autumn sale preview3,540
New arrivals2,406
Last call: autumn sale1,288
- Each report owns a tab, and everything in it is replaced on every refresh. Nothing else in the spreadsheet is touched.
- It runs whether the spreadsheet is open or not. Refreshes happen on our servers, so the numbers are current when you open the file, not when you remember to.
Setting it up
Three things to choose, once
- 01Add Fresh Sheets to a spreadsheet and connect your Google account, then add a Mailchimp API key on your connections page.
- 02Pick the fields you want and a date range.
- 03Say which tab it writes to and how often it refreshes.
Access
What it can see, and what it cannot
Fresh Sheets connects to Mailchimp with an API key you create in your own Mailchimp account, under your profile, then Extras, then API keys.
Mailchimp does not offer read-only API keys. A key can do anything through Mailchimp's API that the user who created it is allowed to do, which can include sending campaigns and changing audiences.
Our code only ever reads from Mailchimp. It sends Mailchimp nothing but read requests, and refuses anything else before the request is sent. It never sends a campaign, changes an audience or edits anything in your account.
Fresh Sheets checks the key with Mailchimp before saving it. A key Mailchimp will not accept, or one that cannot read your campaign reports, is refused and nothing is stored.
It never asks Mailchimp for your subscribers' names or email addresses.
Your Mailchimp API key is stored encrypted and is never shown back to you. You can replace or remove it at any time on your connections page. Removing it stops the reports that read through it and leaves what they already wrote in your spreadsheets. It does not delete the key in Mailchimp, which you can do there.
Writing into your spreadsheet still goes through your Google account. Fresh Sheets asks for its Google data permissions in one consent screen, so you will see Google Analytics, Google Ads and Search Console listed there even if you only report on Mailchimp. Every scope is set out in full on our privacy page.
Writing happens only in the spreadsheets you pick, one at a time, through Google's own file picker. Fresh Sheets never sees the rest of your Drive. Fresh Sheets never changes anything you did not ask it to.
Your data is never sold and never used to train anything.
Pricing
Start on Plus, and decide later
30 days of Plus, free, no card. Then one report keeps refreshing weekly.
How often depends on your plan: every day on Plus, every 6 hours on Pro and every hour on Max.
FAQ
Questions
Can you export Mailchimp campaign reports to Google Sheets?
Yes. Fresh Sheets writes your Mailchimp campaign results into a spreadsheet you already have, in a tab you choose, on a schedule, without the file being open.
Which campaigns are included?
Every campaign sent in the report's date range, one row each, dated by when it was sent in your Mailchimp account's time zone. Campaigns that have not been sent do not appear.
How often can it refresh?
Choose the schedule when you build the report, and it runs on our servers from then on. How often depends on your plan: every day on Plus, every 6 hours on Pro and every hour on Max.
Does it change anything in Mailchimp?
No. Fresh Sheets only reads from Mailchimp. Mailchimp's API keys cannot be limited to reading, so this is a promise about our code rather than about the key.
How many campaigns can one report read?
Up to 1,000 in its date range. If a range holds more, the refresh stops and says so rather than writing part of the list, so choose a shorter range.
Set up your first Mailchimp report
Add your API key, pick your fields and a tab, and leave it running.