Setting up a sequential waterfall enrichment process for contact emails and automating the addition of related columns

Hello, I have a list of several potential contacts at each company, all of whom are part of my target audience. Currently, when I use the 'find email' function, it only searches for the email of the first contact on the list. If it can't find this email, the entire company gets disregarded, even though there are up to 9 other contacts at the same company who could be suitable for outreach. Is there a method to set up a sequential waterfall enrichment process? This would mean that if the email for the first contact isn't found, the system automatically continues searching for the emails of the next 9 contacts. Additionally, how can I automate this process so that when a valid email is found, the system also automatically adds two new columns alongside it, showing the contact's first name and location? This would greatly assist in auto-filling the custom fields in my email sequences.