ConditionalVisibility

new-products-promo

integrate-google-sheets-with-mailchimp-01

integrate-google-sheets-with-mailchimp-02

integrate-google-sheets-with-mailchimp-03

integrate-google-sheets-with-mailchimp-04

integrate-google-sheets-with-mailchimp-05

integrate-google-sheets-with-mailchimp-06

integrate-google-sheets-with-mailchimp-07

integrate-google-sheets-with-mailchimp-08

integrate-google-sheets-with-mailchimp-09

integrate-google-sheets-with-mailchimp-10

integrate-google-sheets-with-mailchimp-11

integrate-google-sheets-with-mailchimp-12

Zapier tutorials

integrate-google-sheets-with-mailchimp-00-hero

Mailchimp

Google Sheets

Sometimes the info you need to use in Mailchimp might be stuck in Google Sheets. Instead of manually transferring data, automate the entire process.

How to integrate Google Sheets with Mailchimp

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.

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.

Triggers when a new campaign is created or sent.

New Campaign

Triggers when a recipient opens an email in a specific campaign.

Email Opened

Triggers when a recipient clicks a pre-specified link in your campaign.

Link Clicked

Triggers when a new audience is added to your MailChimp accounts.

New Audience

Triggers when a new customer is added to a selected store.

New Customer

Triggers when a new subscriber is added to an audience.

New Subscriber

New Order

Triggers when any current subscriber unsubscribes from an audience.

New Unsubscriber

Triggers when a subscriber is added to a Tag within a List.

New Subscriber With Tag

Triggers when a subscriber is added to a segment or tag within an audience.

New Subscriber in Segment or Tag

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

New or Updated Subscriber

Find a Campaign

Find Customer

Find Tag

Searches for a new subscriber on your MailChimp audience.

Find a Subscriber

Find or Create Campaign

Find or Create Tag

Find or Create Subscriber

Archive Subscriber

Create Campaign

Get report details for a specific sent campaign.

Campaign Report

Get report details for a specific link clicks.

Click Report

Create Tag

Creates a custom event for an existing subscriber.

Create Custom Event

Creates a new audience in your MailChimp account.

Create Audience

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

Add/Update Subscriber

Unsubscribe or delete a contact by email address within an audience.

Unsubscribe or Delete Contact action

Removes a subscriber by email address from a tag within an audience.

Remove Subscriber from Tag

Sends a campaign to all subscribers in an audience, segment, or tag.

Send Campaign

Adds a new note to an existing subscriber.

Add Note to Subscriber

Add an email address to a tag within an audience. Note: the email address **must already be subscribed to the audience**, or this will fail.

Add Subscriber to Tag

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

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

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

Triggers when a new row is added to the bottom of a spreadsheet.

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

Create one or more new rows in a specific spreadsheet (with line item support).

Create Multiple Spreadsheet Rows

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

Update one or more rows in a specific spreadsheet (with line item support).

Update Spreadsheet Row(s)

Save new Mailchimp subscribers to rows in Google Sheets spreadsheets

Knowing the latest customer information is essential, but the search for it can be time-consuming. Set up this Mailchimp-Google Sheets integration, however, and Zapier will keep a perfect record of it all. Once active, this Zap will add every newly updated Mailchimp subscriber to a new row on Google Sheets. You'll never have to wonder again!

Add Updated Mailchimp Subscribers as New Rows of Data in Google Sheets

After you set up this integration, Zapier will automatically add new subscribers to your Mailchimp list when they get added to a new row in a spreadsheet. 

Add subscribers to Mailchimp for new Google Sheets rows

Need an easy way to add subscribers to Mailchimp? This Google Sheets Mailchimp integration will automatically create new subscribers in Mailchimp when you add or update a row or column in a Google Sheets spreadsheet.

How to integrate Google Sheets with Mailchimp

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.