Unfortunately, Airtable’s conditionals are currently very weak, so what you want to do is not currently possible with Airtable’s Automations.
Please be sure to email support@airtable.com about improving conditionals in automations.
In the meantime, you only have 3 options:
-
Create multiple automations. Let’s say you have 5 different emails. You would need to create up to 5 different automations, one for each email. (Although technically, you could get away with only 3 automations for 5 emails.) It’s unfortunate that you are required to create multiple automations, though, because Airtable only gives you a limited number of automations to work with.
-
Write a custom JavaScript to handle this for you.
-
Use a professional automation tool like Make.com, which handles conditionals properly by giving you an unlimited amount of routers & filters to create an unlimited number of conditional paths. (Zapier also offers some conditional capabilities, but their conditionals are extremely limited in quantity and functionality and user-friendliness.)