Gmail automation with a lookup field as recipients

[Jose_C]

Hi all!

Im trying yo send a gmail with an automation, I want to send an email to a list fo mails which are in a lookup record separated with commas.

I try to do this but the test says that my To field is empty

Some help, pls?

Many thanks

[Zack_S]

Instead of using a lookup, try a Rollup field.

With ARRAYJOIN(values) as the formula.

[Jose_C]

Thanks,
it is the same

some other idea?

[ScottWorld]

Did you re-test your trigger step?

[Jose_C]

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

the field is just emails with commas…

Some idea, sirs?

[Zack_S · Accepted solution]

Here’s a template for you to review. Seems to be working for me with a Rollup and ArrayJoin as the formula.

Airtable

Email Recipients from Rollup - Airtable

Explore the "Email Recipients from Rollup" base on Airtable.

[Jose_C]

Many thanks!!
Now it works!