Hi. I created a Zap that automatically adds anyone that I message via Gmail to my Mailchimp subscriber list. Right now, it’s working well if there’s just one Gmail recipient. Here’s the current Zap flow.

Now, whenever I send a message in Gmail with multiple recipients, I receive this error. I’m guessing this is because it captures all the emails as one line or one entry (ex. email1@gmail.com, email2@gmail.com) and reading it as an invalid email address.

What I want to do now is to revise my workflow to make sure that all email address and corresponding first name and last name are captured by workflow. That means, whenever I send a Gmail message with multiple recipients, all recipients will automatically be added in my Mailchimp mailing list. Here’s what I tried:

Step 1: Trigger the Zap when there’s a new email sent in Gmail (working)
Step 2: Create a loop for email and name line items from Gmail. (I’m not sure if I did this correctly).

Step 3: Cleaning the name to remove (“) at the start and end of names (working)
Step 4: Splitting the names to first and last name (working)
Step 5: Add the email and names to Mailchimp (not working)
For the email - I referred to the preview loop values email loop from Step 2

For the first name and last names - I referred to the outputs from step 4 formatter

When I test this step though, I don’t think it’s capturing the emails and names as separate entries.

Can anyone help me fix this flow? Thanks!
This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing sensitive details.