Gmail automation with a lookup field as recipients

Instead of using a lookup, try a Rollup field.

With ARRAYJOIN(values) as the formula.

Thanks,
it is the same

some other idea?

Did you re-test your trigger step?

yes, i build a new automation, but is the same problem

the field is just emails with commas…

Some idea, sirs?

Many thanks!!
Now it works!

Any way someone can let me know how to do this. The above links AND image is not working

I also followed this solution and works for me.

First you need to add field as rollup field. you can find it when you scroll it down when adding a field.

check the table you want to lookup from.

choose the field you want to bring in to the table.

write the formula to the aggregation formula box as ARRAYJOIN(values) 

and then, you can go to automation and trigger as you want the conditions to be.

for 'send an email' action choose your newly added rollup field for "To"

I hope you'd already have found the way out.

Does this only work if the field is the original “Email” formatted field/in the original table the email is stored? I am trying to do this in a table where the “email” field is a lookup field from a separate table/list of people being pulled in, and it’s not working. 

Hm, the setup you mentioned seems to be working fine for me, I was able to send a successful email with the following.  Could you provide some screenshots of your data and automation set up?  Or if you could DM me a link to an example base that would be much easier too