Add new MailChimp list subscribers to Google Sheets

Rather than waiting for a one-time download of subscribers and importing the data into Google Sheets, use Zapier to start automatically adding new subscribers to a spreadsheet. Once you set up this MailChimp-Google Sheets integration, new subscribers from that point forward are individually added as spreadsheet rows.

Note: This Zapier integration doesn't import previous MailChimp subscribers into a Google Sheets spreadsheet—only new subscribers after you've set it up.

How It Works

  1. A new MailChimp subscriber is added to your list
  2. Zapier adds that subscriber to Google Sheets as a new spreadsheet row

What You Need

  • MailChimp account
  • Google account
Add new MailChimp list subscribers to Google Sheets
MailChimp integration logo

Share your ideas with MailChimp email newsletters—then use its landing page and form builders to grow your lists and take marketing further with drip and transactional emails.

Google Sheets integration logo

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

What Is Zapier?

Get Help