About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • Add subscribers to Mailchimp from Airtable, when column in Airtable contains multiple emails
Best answer

Add subscribers to Mailchimp from Airtable, when column in Airtable contains multiple emails

  • 16 August 2022
  • 7 replies
  • 37 views
P
Userlevel 1

Someone told me I could use Zapier to automate this task. I attempted, but quickly got lost.

 

I have an Airtable tab that has one column for Event, another column for team names (separated by commas) and a third column for member emails (separated by commas).

 

I think I can figure it out if the record has only one name and email in it, but not sure how to navigate with multiple information. Can Zapier be configured to look in specific columns and create new lines for each email (separate them itself)? Will I need another Zapier to first convert AT to Sheets, then from Sheets to MailChimp?

 

Is this making sense?

For example:

 

[Airtable]

Column 1 (Event) = Wok this Way

Column 2 (Members) = John Doe, Jane Doe

Column 3 (Emails) = johndoe@gmail.com, jane.doe@forest.io

 

I want to be able to add/update two subscribers in Mailchimp:

 

Sub 1

johndoe@gmail.com John Doe [tag: Wok this Way]

 

Sub 2

jane.doe@forest.io Jane Doe [tag: Wok this Way]

 

Thanks!

icon

Best answer by christina.d 6 September 2022, 21:27

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Pap1ll0n 

Good question.

Try using the Looping app to handle 1+ data values for a single field: https://zapier.com/apps/looping/integrations

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Danvers
Userlevel 7
Badge +12

Hi @Pap1ll0n!

Were you able to take a look at the Looping by Zapier app? If so how did you get on? It can be a little tricky the first time you use it; it’s a very useful tool but it can take a bit of time to understand the logic behind how it works. If you’ve not found it yet, there is a help guide on Looping.

Let us know if you need any help!

P
Userlevel 1

Hi @Pap1ll0n 

Good question.

Try using the Looping app to handle 1+ data values for a single field: https://zapier.com/apps/looping/integrations

Thank you! I will try this!

P
Userlevel 1

Hi @Pap1ll0n!

Were you able to take a look at the Looping by Zapier app? If so how did you get on? It can be a little tricky the first time you use it; it’s a very useful tool but it can take a bit of time to understand the logic behind how it works. If you’ve not found it yet, there is a help guide on Looping.

Let us know if you need any help!

Not yet.. I actually just saw these responses, but I am excited to try it. I’ll let you know in the best couple of days.

christina.d
Userlevel 7
Badge +9

Hey friends! 👋🏽 Popping in to consolidate some of the resources offered by @Troy Tessalone and @Danvers into one reply. 🤗

Try using the Looping app to handle 1+ data values for a single field: https://zapier.com/apps/looping/integrations

[Looping] can be a little tricky the first time you use it; it’s a very useful tool but it can take a bit of time to understand the logic behind how it works. If you’ve not found it yet, there is a help guide on Looping.

I also wanted to share the Looping FAQ as well. It’s a Community Hub for all things Looping by Zapier. Check it out here:

I hope this helps! 

P
Userlevel 1

Thanks. So I couldn’t get very far. Super confusing! Also, trying to follow steps here and I couldn’t even get passed step 3 because nothing shows up in Events.

 

 

Also, if I go back and try to create from scratch, it won’t even let me choose this option (grayed out):

 

Not sure why I am not getting the drop down options for Event.

P
Userlevel 1

Wish you has a phone or chat option, it would solve this is less than 15min, versus back and forth posts and time delays 😫

Terms & Conditions