Google Sheets + Mailchimp

Save new Mailchimp subscribers to rows in Google Sheets spreadsheets

When this happens
Step 1: New Subscriber
Then do this
Step 2: Create Spreadsheet Row

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

How It Works

A new subscriber is added to a Mailchimp list.
Zapier adds a new row to a Google Sheets spreadsheet.

What You Need

Mailchimp account
Google Sheets account

Try this template

Supported triggers and actions

What does this mean?

New Campaign
Triggers when a new campaign is created or sent.
Trigger
Scheduled
Email Opened
Triggers when a recipient opens an e-mail in a specific campaign.
Trigger
Scheduled
Link Clicked
Triggers when a recipient clicks a pre-specified link in your campaign.
Trigger
Scheduled
New Audience
Triggers when a new audience is added to your MailChimp accounts.
Trigger
Scheduled
New Customer
Triggers when a new customer is added to a selected store.
Trigger
Scheduled

New Subscriber
Triggers when a new subscriber is added to an audience.
Trigger
Instant
New Order
Triggers when a new order is created.
Trigger
Scheduled

New Unsubscriber
Triggers when any current subscriber unsubscribes from an audience.
Trigger
Instant

Mailchimp
Triggers when a subscriber is added to a segment or tag within an audience.
Scheduled
Trigger
Mailchimp
Triggers when a subscriber is added or updated in an audience.
Instant
Trigger
Mailchimp
Creates a campaign draft.
Scheduled
Action
Mailchimp
Creates a custom event for an existing subscriber.
Scheduled
Action
Mailchimp
Add a new subscriber to an audience of your choosing. Can be used to update an existing subscriber too.
Scheduled
Action
Mailchimp
Unsubscribe an email address from an audience of your choosing.
Scheduled
Action
Mailchimp
Removes an existing subscriber by email address from a tag within an audience. Note: the email address
Scheduled
Action
Mailchimp
Sends a campaign draft. PLEASE NOTE: This action sends an email to
Scheduled
Action
Mailchimp
Adds a new note to an existing subscriber.
Scheduled
Action
Mailchimp
Add an email address to a tag within an audience. Note: the email address
Scheduled
Action
Mailchimp
Finds an existing campaign.
Scheduled
Action
Mailchimp
Finds a customer by an email address.
Scheduled
Action
Mailchimp
Searches for a new subscriber on your MailChimp audience.
Scheduled
Action
Mailchimp
Finds an existing campaign.
Scheduled
Action
Mailchimp
Searches for a new subscriber on your MailChimp audience.
Scheduled
Action
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new spreadsheet.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action

About Google Sheets

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

Learn More

Related categories

Similar Apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

About Mailchimp

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.

Learn More