Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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

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!

Hi @Pap1ll0n 

Good question.

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

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!

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!

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.

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

oLooping] 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! 

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.

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