Script experts?

[gvalero]

Ok!

I think this script and info can help you to start

Scripts, scripts, scripts!

A Script to send SMS notifications via Twilio or Email via your gmail account in case phone number is not available function Twilio() { var ss = SpreadsheetApp.getActive().getSheetByName("Notifications"); var values = ss.getRange("A2:H").getValues(); for (var i in values) { var row=i; var r = +row + 2; if (values[i][5] != '' && values[i][7] == '' ) { var number = values[i][5] var message = values[i][6] function sendSms(to, body) { …

Of course, you will have to integrate several external services to get SMS task/functionality you desire (e.g. Make/Zapier).