Yes, your best bet for doing all of this is to use Make’s advanced automations & integrations, which you can integrate with any email app or SMS app.
For emailing, I would highly recommend using either MailerSend or MailGun as your mailing service of choice. I do NOT recommend SendGrid, as it is very difficult to use.
For SMS, I like SimpleTexting the best, but there are many other ones to choose from as well, such as MessageBird or TextMagic.
If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.
I also give live demonstrations of how to use Make in many of my Airtable podcast appearances. For example, in this video, I show how to work with Airtable arrays in Make.
Hope this helps!
p.s. If you have a budget and 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