Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Gmail automation with a lookup field as recipients

Topic Labels: Automations
Solved
Jump to Solution
3580 8
cancel
Showing results for 
Search instead for 
Did you mean: 
Jose_C
6 - Interface Innovator
6 - Interface Innovator

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
Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

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

8 Replies 8
Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

Instead of using a lookup, try a Rollup field.

With ARRAYJOIN(values) as the formula.

Jose_C
6 - Interface Innovator
6 - Interface Innovator

Thanks,
it is the same

some other idea?

image

Did you re-test your trigger step?

Jose_C
6 - Interface Innovator
6 - Interface Innovator

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

the field is just emails with commas…

Some idea, sirs?

Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

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

Jose_C
6 - Interface Innovator
6 - Interface Innovator

Many thanks!!
Now it works!

leximaio
4 - Data Explorer
4 - Data Explorer

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.

OCC_SamaritansP_0-1681719720169.png

 

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) 

OCC_SamaritansP_3-1681719929582.png

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.