Segmenting a base into a master email list.

Hey there - 

What I'm Trying to Accomplish:

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.

My Setup:

• Table: Contacts (source table)

  • Fields:
    • Contact Name
    • First Name
    • Last Name
    • Email (Primary Email)
    • Partner Email
    • Referral Email
    • Connection Email

• Table: Master Email List (destination table)

  • Fields:
    • Email
    • Contact Name
    • Email Type (Primary, Partner, Referral, Connection)

Automation Steps (Attempted):

1️⃣ Trigger: "When a Record Matches Conditions"

• If any of the email fields (Primary, Partner, Referral, or Connection) is not empty, trigger the automation.

2️⃣ Find Records Action:

• Find all records in Contacts where Email, Partner Email, Referral Email, or Connection Email is not empty.

3️⃣ Repeat for Each (Loop):

• Process each found record individually to prevent data from being lumped together.
• Ensuring the loop references Current Item rather than the entire list.

4️⃣ Create Record Action (Master Email List):

• Create a new record for each email found in the Contacts table.
• Assign the corresponding Contact Name and Email Type.

The Issue I'm Facing:

• The automation only creates one record instead of processing all found emails.
• Some emails and contact names are getting merged into a single field instead of being split into separate records.
• The Repeat for Each loop doesn’t seem to be functioning properly, even though it's set to process "List of Records" from Find Records.
• Testing is limited because Airtable doesn’t support "Test Input List" with repeating groups.

What I Need Help With:

✅ 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!