Contacts lookup from multiple email addresses

In Airtable, you would likely need to write a Javascript to split up the email addresses by the comma.

It would probably be best to handle this on the Zapier end first, but I don't think that Zapier can handle this either. If you're not already too heavily invested in Zapier, I would strongly recommend switching to Make because Make can handle this natively for you. In Make, you would simply use the "split" function to split up the email addresses by the comma, which will then automatically give you an array of email addresses that you can put into your linked record field.

There can be a bit of a learning curve with Make, which is why I created this basic navigation video for Make, along with providing the link to Make’s free training courses.

Also, here are a few of the reasons why Make is superior to Zapier.

If you're willing to set your Contacts table to have a primary field with the emails then you can just make your Zap put the email address into the linked field to the Contacts table and that should automatically link stuff up I think

You could also try converting that field that takes the emails into a multiple select field? Pasting data into that should then create new options, and you could make an automation that'll take the values of that multiple select field and use it as a repeating group action to find the correct record in Contacts and link them as needed

(I'm not 100% on whether the Zap will be able to create new options; I vaguely recall having done this succesfully in the past heh)

Thanks - that makes sense.  Can you help me understand how to use the Airtable automation to connect an array of email addresses to linked contact records?  The lookup automation does not seem to be able to do this, at least how I've configured it.  I've tried manually separating email addresses with a comma and space, a semi-colon, semi-colon and space, etc. and the lookup fails each time.  (Lookup works fine with a single email address).