Trying to send multiple SMS via twilio in Google Appscript but keep getting errors

Trying to send multiple SMS via twilio in Google Appscript but keep getting errors

Tried this, but the steps are not so clear : https://www.twilio.com/blog/2016/02/send-sms-from-a-google-spreadsheet.html

The author said to define "to" and "body" under Myfunction but the example doesn't show that.

Perhaps i understand it wrongly.

function sendSms(to, body) {    var ACCOUNT_SID = "#########################";  var ACCOUNT_TOKEN = "#########################";  var messages_url = "https://api.twilio.com/2010-04-01/Accounts/" + ACCOUNT_SID + "/Messages.json";      var payload = {      "To": "+60168522468",      "Body" : "RM0.00 Test",      "From" : "+12014313278"    };      var options = {      "method" : "post",      "payload" : payload    };      options.headers = {       "Authorization" : "Basic " + Utilities.base64Encode(ACCOUNT_SID + ":" + ACCOUNT_TOKEN)    };      UrlFetchApp.fetch(messages_url, options);  }    function sendAll() {    var sheet = SpreadsheetApp.getActiveSheet();    var startRow = 2;     var numRows = sheet.getLastRow() - 1;     var dataRange = sheet.getRange(startRow, 1, numRows, 31)     var data = dataRange.getValues();      for (i in data) {      var row = data[i];      try {        response_data = sendSms(row[29], row[30]);        status = "Msg Sent";      } catch(err) {        Logger.log(err);        status = "Error";      }      sheet.getRange(startRow + Number(i), 31).setValue(status);    }  }    function specialFunction() {  //var to = "";  //var body = "Tender"  //sendSms(to,body);  sendAll();  }  

Error:

1. 30008 - Unknown error
2. The "Error" or "Msg_Sent" always exceeds my current number of rows(11 rows) but goes upto 18 rows where there isnt a corresponding data to sms.

https://stackoverflow.com/questions/66932741/trying-to-send-multiple-sms-via-twilio-in-google-appscript-but-keep-getting-erro April 03, 2021 at 11:20PM