When this happens...
MailchimpNew Subscriber
Then do this...
Google SheetsCreate Spreadsheet Row

Save your new MailChimp subscribers to a Google Sheets spreadsheet so that it's easier to share your list with teammates. This MailChimp Google Sheets integration will automatically add new MailChimp subscribers to a new row in a Google Spreadsheet.

Note: This Zapier integration only saves subscribers that are created in MailChimp after the integration is set up.

How It Works

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

What You Need

  • MailChimp account
  • Google Sheets account

Why Zapier?


Get started for free—14 day trial of premium features and apps.


No coding required—automate any of 1,000+ apps in minutes.


Enterprise-level security—connect mission-critical apps.

It's easy to connect Mailchimp + Google Sheets and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
New Subscriber

Triggers when a new subscriber is added to an audience.

Add/Update Subscriber

Add a new subscriber to an audience of your choosing. Can be used to update an existing subscriber too.

Updated Subscriber

Triggers when a subscriber is added or updated in an audience.

Create Worksheet

Create a blank worksheet with a title. Optionally, provide headers.

New Campaign

Triggers when a new campaign is created or sent.

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

New Spreadsheet Row

Notifies your Zap when a new row is added to the bottom of a spreadsheet.

Update Spreadsheet Row

Update a row in a specific spreadsheet.

New or Updated Spreadsheet Row

Notifies your Zap when a new row is added or modified in a spreadsheet.

Create Campaign

Creates a campaign draft.

Use our free platform to build a single Zapier integration and instantly connect your app with 1,400+ others.

Become a Zapier Integration Partner

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.

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

See Google Sheets Integrations