Twilio+GAS Auto Caller

App Guides for Sheets and GAS

https://developers.google.com/apps-script/guides/menus
https://developers.google.com/apps-script/guides/sheets/functions
https://support.google.com/docs/table/25273?hl=en&rd=2
https://support.google.com/docs/answer/3094246
https://support.google.com/docs/table/25273?hl=en&rd=2
https://developers.google.com/apps-script/quickstart/macros.js
https://developers.google.com/apps-script/guides/sheets/functions#optimization
https://developers.google.com/apps-script/guides/web
https://github.com/entaq/GoogleAppsScript/blob/master/Twilio/MakePhoneCall/twiml.html
https://www.youtube.com/watch?v=j0wjM1Ds3lc
https://www.twilio.com/user/account/phone-numbers/PNb7bd8a5de7390de43f30dee96c79141b?showApps=sms&applicationSid=AP512e13b657b54191654e10152db0dd52

send-sms-gas-js

function sendSms(e) {
  var itemResponses = e.response.getItemResponses();
  var message = '';
  // Parse resopnse
  for (var i = 0; i < itemResponses.length; i++) {
    var itemResponse = itemResponses[i];
    var question = itemResponse.getItem().getTitle();
    var answer = itemResponse.getResponse();
    
    // form name
    if(question=="<Ex. name>"){
      var name=answer;
    }else if(question=="<Ex. phone number>"){
      var tel=answer;
    }else if(question=="<Ex. mail>"){
      var mail=answer;
    }
  }
  var accountSid = "<AccountSID>";
  var authToken = "<AuthToken>";
  var url = "https://api.twilio.com/2010-04-01/Accounts/" + accountSid + "/SMS/Messages.json";
  var options = {
    method: "post",
    headers: {
      Authorization: "Basic " + Utilities.base64Encode(accountSid + ":" + authToken)
    },
    payload: {
      // From is one of your Twilio phone numbers
      From: "<from phone number>",
      To: tel,
      Body: "Test from Google Apps Script " + name + ": " + mail
    }
  };
  try {
    var response = UrlFetchApp.fetch(url, options);
    Logger.log(response);
  } catch(e){
    var error = e;
    Logger.log("message:" + error.message + "\nfileName:" + error.fileName + "\nlineNumber:" + error.lineNumber + "\nstack:" + error.stack);
  }
}

Twilio Guides

https://www.twilio.com/user/account/phone-numbers/PNb7bd8a5de7390de43f30dee96c79141b?showApps=sms&applicationSid=AP512e13b657b54191654e10152db0dd52
https://www.twilio.com/docs/api/client
https://www.twilio.com/user/account/ip-messaging/getting-started
https://www.twilio.com/docs/api/twiml