Unless you use Make (which offers built-in sorting) for your automations, there is only one way to do it in Airtable: You will need to find your records "by view" instead of "by condition", and your view can NOT be grouped in any way. Also note that Airtable's "find records" action has a limit of 100 records (which can also be worked around by using Make).
Thank you @ScottWorld. I know about "find records based on view" rather than on condition, but can not figure out how to select only those records that have to enter the view when I need that automation to run - the conditions for filtering into the view become very complex as well as the automation itself - after running and sending email it has to remove the records from that view so it could run next time with other records... I've read somewhere there are workarounds with scripting, allowing to avoid integration with 3rd party apps like Make.
Also a limit of 100 is not critical, normally our Find record returns much less records.