I have an automation that is triggered from a schedule, finds records in a view and then needs to email address using one of the values found in the view.
The problem is that the email address in the view may appear many times (Multiple rows) so that using that field in the automation will mean the TO: filed looks like this: firstname.lastname@example.org, email@example.com, firstname.lastname@example.org, email@example.com This means they get the email multiple times.
How can I get the unique values from the rows and use that for the sending on emails?
The find records action in Airtable automations is rather limited. There is no built-in method of obtaining unique values from a find action.
You can use a scripting action that can find the records and filter out duplicate email addresses.
If you are interest in a script, but do not code, and have budget to hire someone to write a script, you can book an appointment with me.