The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Feb 13, 2025 10:38 AM
Hey there -
I'm building an Airtable automation that extracts email addresses from multiple fields in my Contacts table and creates individual records in a Master Email List table. Each email should be stored as a separate record, along with the corresponding Contact Name and an "Email Type" field (Primary, Partner, Referral, or Connection).
This will allow me to export clean, deduplicated email data into HubSpot for email campaigns.
Table: Contacts (source table)
Table: Master Email List (destination table)
1️⃣ Trigger: "When a Record Matches Conditions"
2️⃣ Find Records Action:
3️⃣ Repeat for Each (Loop):
4️⃣ Create Record Action (Master Email List):
✅ Ensuring each email is processed separately as an individual record.
✅ Making sure "Repeat for Each" correctly references Current Item instead of pulling the full list.
✅ Verifying that Find Records outputs the correct data structure for looping.
Has anyone successfully built a similar automation? Would love insight on how to correctly structure the loop and data references to get individual records in my Master Email List.
Thanks in advance for any help!
Feb 13, 2025 10:57 AM
Hmm, I was trying to think through doing this with conditionality, when the real solution is to just create a linked record relationship between your contact and email tables. Instead of your 4 email fields in contact, you just have 1 field linking to the email table, which can link multiple times to express various email types. Then you can use lookup/rollups in contact as necessary if you need to display only the email address instead of the linked object.
Feb 13, 2025 11:02 AM
Hey @p_finder25!
Do remember that repeating group block will iterate through each of the records found on the find record action block, and not each of the fields for each of such records. There is a big difference to it!
E.g. If Contact A has both Partner Email and Referral email, that is still one record on the list of the find record block: Contact A.
Given that you cannot iterate through the different emails found in different fields, I would probably suggest either:
(i) including a script on your automation that will get the trick done, or
(ii) building as many automations as email fields you have, where each automation would focus on only one email field.
Given that you would just need to duplicate the automation, and change the condition and the mapping, I would probably go with option (ii) above.
Does this make sense?
Please let me know if this is not clear, or of if this does not answer your question :D. I'd be happy to help out.
Mike, Consultant @ Automatic Nation
Feb 13, 2025 11:10 AM
Hey there thank you. That is what I was trying to do (one automation for each) cant seem to get it to work.
Feb 13, 2025 11:41 AM
Thank you - ill try it this way and let you know
Feb 13, 2025 06:25 PM
Hey @p_finder25. I'm not fully getting the combination of trigger and find records that you are using on the latest screenshots shared. Would you mind further explaining?
With the right information this should be pretty easy to solve. Keep your hopes up!
Mike, Consultant @ Automatic Nation
Feb 14, 2025 11:39 AM
Hey Mike - took some trial and error but came up with a script - and it works great now. thx for the advice (
Feb 14, 2025 12:41 PM
Great! The script might be overbuilding, but if it works it works!!!
Glad to help out. If anything else comes up, feel free to schedule a call with me using this link.
Mike, Consultant @ Automatic Nation