Keep a copy of your Mailchimp list in Google Sheets

Short answer: Use a free Google Apps Script that copies your Mailchimp audience into a Google Sheet every hour: email, status, name, signup date and tags. It runs in your own Google account; nothing is sent to us. Setup takes 4 steps: Make a Settings tab; Add your key; Paste the script; Run it.

How to set it up

1. Make a Settings tab. Open a new Google Sheet and add a tab called Settings. In Mailchimp, open Audience, Settings, Audience name and defaults, and paste the Audience ID into B1.
2. Add your key. In the Apps Script editor, open Project Settings and add the Script property MAILCHIMP_KEY. In Mailchimp, open your profile, Extras, API keys, and create a key. It ends in something like -us21, which the script uses to find your account. Keys stay in the script, never in the sheet.
3. Paste the script. Open Extensions, then Apps Script, paste in the code from our email, and save. Reload the sheet and a Mailchimp menu appears.
4. Run it. Choose Mailchimp, then Refresh subscribers. The Subscribers tab fills in with every contact's email, status, first and last name, signup date, last change and tags. Choose Refresh subscribers every hour to keep it up to date.

Want this set up for your business? Free written scope in 20 minutes

Get the script

Good to know

• The tab is rewritten on each run, so don't type notes into it; use another tab for that.
• Unsubscribed and cleaned contacts are included, with their status, so you can filter them.
• It reads up to 50,000 contacts.

Questions

What does this script do?

It is a free Google Apps Script that copies your Mailchimp audience into a Google Sheet every hour: email, status, name, signup date and tags.

How do I set it up?

In 4 steps: 1. Make a Settings tab; 2. Add your key; 3. Paste the script; 4. Run it. The full steps are on this page.

Is it free, and does it send my data anywhere?

It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.

Can you install it for me?

Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.

Want this connected to the rest of your tools? Send us a short brief.