Pass Mailchimp Subscriber Data to Google Sheets with Zapier

Quick summary

This tutorial shows you how to use Zapier to automatically pass Mailchimp subscriber data to a Google Sheets spreadsheet every time a new subscriber joins your list. By connecting these two apps with a Zap, you eliminate manual data exports and keep your subscriber records updated in real time.

Steps

1. Log in to Zapier, click Create, and select Zaps to start the automation process.
2. Click Trigger to begin setting up the trigger step of your Zap.
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 by authorizing access.
6. Select the Mailchimp audience or list from which you want to pull subscriber data.
7. Run a test to ensure Zapier successfully detects a new subscriber.
8. Add Google Sheets as the Action App in your Zap.
9. Choose Create Spreadsheet Row as the action event, then connect your Google account.
10. Fill in the necessary fields to map Mailchimp subscriber data to the correct spreadsheet columns.
11. Run a test to confirm that new Mailchimp subscribers' data is correctly passed to your Google Sheet.
12. Click Publish to activate your Zap and start the automation.