# Automate Mailchimp subscriber lists with Zapier

> To automate Mailchimp subscriber lists with Google Sheets, log in to Zapier and create a new Zap. Set Mailchimp as the trigger app with the New Subscriber event, connect your account, select an audience, and run a test. Then, add Google Sheets as the action app, choose Create Spreadsheet Row, connect your account, fill in the fields, test, and publish the Zap.

Canonical: https://livedemo.ai/tutorials/automate-mailchimp-subscriber-lists-with-zapier/
Apps: Zapier, Mailchimp, Automation
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/6929fe9b7dd0e157abed83b0/preview?step=1

## Steps

1. Log in to Zapier, click on "Create" and select "Zaps" to start the automation process.
2. Click "Trigger."
3. Search for and select Mailchimp as the trigger app.
4. Choose "New Subscriber" as the trigger event to detect when a new subscriber is added.
5. Connect your Mailchimp account to Zapier.
6. Select the Mailchimp audience/list from which you want to pull subscriber data.
7. Run a test to ensure Zapier detects a new subscriber.
8. Add Google Sheets as the Action App.
9. Choose "Create Spreadsheet Row" as the action event, then connect to you Google account.
10. Fill in the necessary fields.
11. Run a test to ensure that new Mailchimp subscribers' data is correctly passed to your Google Sheet.
12. Click "Publish" to activate your Zap.