Hey folks
I want to run this automation
When: trigger t
Action 1:
Find record from Table T
Table T has 2 fields:
Email field and text field
Then Action 2:
Send email:
To: email field from action 1
Text: text field from action 1
THE PROBLEM:
When action 1 retrieves multiple records from Table T like this:
Record 1:
Text field 1, email 1
Record 2:
Text Field 2, email 2
…
Record n:
Text Field n, email n
Result:
ONE email only is sent as follows:
To: email 1, email 2…email n
Text: text field 1 text field 2 … text field n
all concatenated in the same email body.
Which makes no sense in the scenario I want to accomplish, since each recipient needs to receive an email with the personalized text taken from text field n from its corresponding record from Table T.
Instead, I need airtable to do the following while performing action 2:
Send text field 1 to email 1
Send text field 2 to email 2
…
Send text field n to email n
Any idea how to achieve this? :face_with_monocle:
Thanks in advance.