Mailchimp campaign reports in Google Sheets, refreshed on a schedule
Your Mailchimp campaign results, current before you open the file.
30 days of Plus, free from sign-up. No card needed.
What you can pull from Mailchimp
One row for each campaign sent in your date range, with the fields you choose. Data comes out of Mailchimp into your spreadsheet, and nothing is ever written into Mailchimp.
Dates are in your Mailchimp account's time zone.
Last week's campaigns, already in the tab
Mailchimp, written to Campaign results
- Each report owns a tab, and everything in it is replaced on every refresh. Nothing else in the spreadsheet is touched.
Setting up the Mailchimp Google Sheets integration
- In Mailchimp, create an API key. On the Sources page, choose Add key on the Mailchimp card, paste it and choose Check and save.
- Pick the fields you want and a date range.
- Choose the tab, worksheet or table it writes to, and how often it refreshes.
Try it with your own Mailchimp data.
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 the Sources 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.
Fresh Sheets never changes anything you did not ask it to.
Your data is never sold and never used to train anything.
How we handle your dataStart on Plus, and decide later
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.
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.
Are subscriber details included?
No. Reports are one row per campaign. Nothing about individual subscribers is read.
How often can it refresh?
Daily on Plus, every 6 hours on Pro and every hour on Max. On Free, one report refreshes weekly.
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 a report have?
Up to 1,000 campaigns a run. A report that would return more doesn't run, and tells you how to bring it under.
Set up your first Mailchimp report
Add your API key, pick your fields and a tab, and leave it running.
30 days of Plus, free from sign-up. No card needed.