You can check out the SendGrid extension or the MailerSend extension to see if either of those do what you want!
Otherwise, for anything more advanced, you would need to choose a mass email mailing service that you like (which could be SendGrid or MailerSend), and then you can automate the entire process with Make's advanced automations & integrations.
One of my favorite mass email mailing services is MailGun, but there are many to choose from.
If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is how you would instantly trigger a Make automation from Airtable.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld