Personally, I think the easiest & best way to set this up is with Integromat, which lets you schedule your automations, so you could set your emails to go out every morning at 7am. Integromat has much more functionality & flexibility than Zapier does.
Just schedule it to search your records for the appropriate records every morning at 7am, then send out the emails.
I can’t talk you through the entire process of setting this up in Integromat, because it takes several hours to set it all up. But if you have a budget for this project and need to hire an expert Airtable consultant to help you with this, feel free to send me a private message!