How to add subscribers to Mailchimp from Google Sheets

SEO and General Business tutorials and tips.

This post was sourced from by MOZ.

Hooray! You’ve added a new lead to your Google Sheet. Now you just need to figure out how to easily add them to Mailchimp.

You can manually enter each new lead, but that can take forever and makes it easy to add in errors. But with a Zap—our word for the automated workflows you can create with Zapier—you can automatically add new subscribers to your Mailchimp list when they’re added to a new row in Google Sheets with no extra work.

Push new Google Sheet rows to Mailchimp as subscribers

Zapier lets you create automated workflows called Zaps, which send your information from one app to another. You can create your own Zap from scratch without any coding knowledge, but we also offer quick templates to get you started.

If you’d like to start with a template, click on it to get started, and you’ll be taken to the Zapier editor. You’ll need to create a Zapier account if you don’t already have one. Then follow the directions below to set up your Zap.

Add subscribers to Mailchimp for new Google Sheets rows

Add subscribers to Mailchimp for new Google Sheets rows

  • Google Sheets logo
  • Mailchimp logo
Google Sheets + Mailchimp

Set up your Google Sheet trigger

First, set up your trigger—the event that starts your Zap. If you’re using the Zap template, Google Sheets will already be selected as the trigger app and New Spreadsheet Row as the trigger event. Click Continue.

The Google Sheets app logo next to the text "New Spreadsheet Row in Google Sheets"

Next, connect your Google Sheets account. Click on Choose an account… and either select an account from the dropdown menu (if you’ve connected Google Sheets to Zapier before) or click + Connect a new account.

In a field labeled "Google Sheets account" a Google Sheets account is selected in a dropdown menu with the Google Sheets logo next to the account name.

For each app you connect, Zapier will ask for a general set of permissions which allows you to be flexible with your Zaps. The only actions Zapier takes on your app accounts are those a given Zap needs to accomplish what you’ve set up.

Once you’ve connected your account, click Continue.

Next, select which spreadsheet you’d like your Zap to trigger on. Once you select your spreadsheet, you’ll choose a specific page or worksheet within the spreadsheet if you have more than one.

Note: For your action step to accurately save emails to Mailchimp, you’ll need to have one column in your spreadsheet for the lead emails, one column for first name, and one column for last name.

Spreadsheet and Worksheet fields with specific Google Sheets spreadsheets and worksheets selected in the dropdown menus.

Click Continue.

Now you need to test your trigger. Zapier will find a recent row in your selected spreadsheet that you choose. This will be used to set up the rest of your Zap. Click Test trigger.

A test screen with the Google Sheets app logo connected to the Zapier app logo with an arrow.

Once you confirm your trigger is working correctly, click Continue.

Set up your Mailchimp action

Now let’s set up the action—the event your Zap will perform once triggered. If you’re using the Zap template, Mailchimp will already be selected as your action app and Add/Update Subscriber as your action event. Click Continue.

The Mailchimp app logo next to the text "Add/Update Subscriber in Mailchimp"

Connect or add your Mailchimp account to Zapier and click Continue.

Now it’s time to set up the details of your Zap. Start by selecting the audience in Mailchimp you want your new subscribers to be added to. Then, click in the Subscriber Email field and choose the column in your spreadsheet that’s tracking the new lead emails from the dropdown menu.

A dropdown menu underneath the "Subscriber Email" field that shows Google Sheets columns.

If you want your subscribers to double opt-in to your newsletter list, select True under Double Opt-In.

Next, choose if you want to update existing subscribers. If you select yes, the new subscriber data in your spreadsheet will overwrite your existing customer data in Mailchimp if this user’s email already exists. If you select no, this new lead will not be added at all. That way, you won’t get duplicate subscribers.

Mailchimp options for subscribers, including a Double Opt-in field with a dropdown to select options.

Next, choose if you want to add or replace subscribers in a Mailchimp group. Then, select which group you want to add or replace them into.

Mailchimp options including a Replace Groups fields with a description of what the changes mean.

If you’re not working in English, help make it easier to reference whatever language you’re working in by adding in the language code.

A field labeled "Language Code".

To add tags to your new subscribers, click in the Choose value dropdown under Tag(s) to select from existing tags in your Mailchimp account.

A field labeled Tag(s).

Now you need to add the first and last name of your subscribers from the relevant columns in your Google Sheet to the right fields in Mailchimp. To map this data from your Google Sheets trigger step, click in the First Name or Last Name fields and select the relevant first or last name columns from your Google Sheet in the dropdown menu.

Fields labeled "First Name" and "Last Name".

Lastly, select the Subscription status of your new subscriber from the dropdown under Subscription status. The options in the dropdown will match whatever you have set up in your Mailchimp account.

A field labeled "Subscription status".

Once selected, click Continue.

Now it’s time to test your action. When you click Test & Review or Test & Continue, Zapier will send a subscriber to Mailchimp from the Google Sheet you selected. It’s a good idea to test your Zap so you can check if your subscriber gets added correctly.

If you’d rather skip the test, just click Skip Test in the top-right corner.

A test screen with a blue Test & Continue button.

If your test looks good, don’t forget to turn on your Zap. If something looks off, go back and tweak things until you get it just right.

Want more workflows like this? Explore more Google Sheets and Mailchimp Zaps.

I hope that you find the above useful or interesting. You can find similar content on our blog: https://rankmysite1st.com//blog/

Please let me have your feedback below in the comments section.

Let us know what topics we should cover for you in future.