Using redash to send sms to users

We want to use redash for sending SMS based on the query/specific condition met results.
Actually we are using for sending SMS to the users manually.

The objective is to send whitelisted SMS to users when they fall in specific condition e.g. if user not bought any item in last 30 days(which I can work on SQL query).

How can I get this objective through redash or should I create another solution for this activity
Please suggest the way forward

Maybe you can use alerts to do this? You can set up generic webhook alert notification destinations. But it could be cumbersome since you would need to make an alert for every customer.

Maybe just use the Redash API to run your query but use a separate script in Javascript or Python that sends the SMS?