Guide

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.