Connect Google Sheets to Mailchimp: Add Subscribers from New Rows

Use the Google Sheets to Mailchimp Zap from the video: zpr.io/gw5f6
***
- Give Zapier a try for free: zpr.io/g9rER
- Zapier's data & privacy policies: zpr.io/g9rEf & zpr.io/g9rEG
I want to connect Google Sheets and Mailchimp so that when a new row is added with a lead or contact, they're added as a subscriber in one of my Mailchimp lists. But there's no direct integration and I don't want to copy and paste.
With Zapier, I can connect Mailchimp to Google Sheets so that new rows create new subscribers.
If you don’t know Zapier, it’s an automation tool that makes connecting all your apps happen in a matter of clicks.
And Zapier’s going to help me create subscribers in Mailchimp from new rows in Google Sheets with a Zap-an automated workflow.
All I’ll need to do is connect my Mailchimp and Google Sheets accounts.
First things first, I’ll connect my Google Sheets account. We have links to our privacy and data policies in the description but basically, we keep your account information secure with bank-level encryption-we don’t take chances with your data.
My Google Sheets account is connected and tested. Now I have to select the spreadsheet and worksheet for the Zap to monitor. This down caret button means I have to select from a list, so let's find the right ones.
Now let's grab a sample row to use and we can get to connecting Mailchimp.
This gives Zapier permission to add a subscriber in Mailchimp.
We have another down caret button to select a specific audience to add this subscriber to.
When you see this button, that means you can grab information from the first step to populate this field. I’ll do that for the email address.
When I click test, we’re actually going to add the subscriber in MailChimp, so keep that in mind when you test your Zaps, too; Zapier is actually making the action happen.
Looks like a success, so let’s check out Mailchimp…and there it is. Just like that, we connected Mailchimp to Google Sheets.
Now, every time I add a row in Google Sheets, Zapier will add them as a subscriber in Mailchimp.
To set this Zap up, I used a Zap Template. They make it faster to create a workflow, and come with the apps and actions all ready to go. If you clicked on “Make A Zap” or your editor looks a little different, don’t worry, the principles are all the same.
For more information on Zapier, this Zap Template, and more resources, check out the description. We hope this helps you be more productive!

[@MJLourens]

But this doesn't pull in the user's name or surname?

[@Smalleganrealestate]

From the Mailchimp Add/Update Subscriber Action, open the "edit template" step. Scroll down to the bottom and click "Refresh Fields." It should expand the list of optional data to pull in. I'm not sure why this is not included as part of this tutorial...it's not very obvious where to add first name, last name, address, etc.

[@tumnus7556]

@@Smalleganrealestate Thanks! it worked!

[@mcmiked]

You cant use a template in the new editor to allow this to pull name and number etc, how do we fix this?

[@Zapier]

Hey Mike! If the "Refresh Fields" button at the bottom of the Mailchimp step didn't pull in those fields, we'd definitely recommend you contact Support: zapier.com/app/contact-us

[@mazenkadous8156]

Can I have Zapier add subscribers from sheets to a specific group that I created in Mailchimp?

[@jafarheyari504]

خوب

[@jafarheyari504]

خوب و عالی و خوب و بهتر