Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Gmail automation with a lookup field as recipients

Topic Labels: Automations
Solved
Jump to Solution
359 6
cancel
Showing results for 
Search instead for 
Did you mean: 

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.
image

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

Some help, pls?

Many thanks

1 Solution

Accepted Solutions

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

See Solution in Thread

6 Replies 6

Instead of using a lookup, try a Rollup field.

With ARRAYJOIN(values) as the formula.

Thanks,
it is the same

some other idea?

image

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?

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

Many thanks!!
Now it works!