I’m new to the AirTable platform and community. We’re a digital agency and I’m looking to deploy AirTable as the central platform to manage all our client projects. I’ve set up a project tracker that is working nicely, but I would like to give our clients the option to receive automatic SMS and email alerts when their projects change status.
I have integrated with the Twillo API but can only see a way to send SMS messages to a batch of clients manually. Is there any way to achieve what I need (ie create a series of Templates in Twillo and SendGrid which then automatically trigger to the client once certain rules are met. Ie. when a project changes status to ‘in development’, AirTable checks if the client has ticked the SMS and Email alert field, then finds the SMS and Email template for the ‘status change’ and sends it to them?
Any help from the community on this would be amazing!
All the best,