betasms API Integration with Google Forms - Step By Step Guide

This Video will explain you how to use betasms API and configure google App Scripts to send whats app messages to the numbers stored in google forms and spreadsheet.

Thank you for watching my video's, Please do Like, share and subscribe to my channel.

https://betasms.in/

https://wa.me/918600909992

Api Code :-


function processMessage(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");

var r = ss.getActiveRange();
var rownoBmessage ='E'+ r.getRow(); // TODO: replace here your messege cell
var rownoCdestnumber ='D'+ r.getRow(); // TODO: replace here your number cell
var logCell ='F'+ r.getRow(); // TODO: Create a new log cell and name it.

var message = ss.getRange(rownoBmessage).getValue()
var destNumber = ss.getRange(rownoCdestnumber).getValue(); //actual value

if(destNumber!=='phone number')
{
sendWhatsapp(destNumber,message);
var range =ss.getRange(logCell);
range.setValue('message sent');
Logger.log('sent '+destNumber);
}
}

function sendWhatsapp(destNumber, message) {
var instanceId = "63CF"; // TODO: Replace it with your gateway instance ID here
var access_token = "a27e1f9"; // TODO: Replace it with your Forever Green client ID here
Logger.log('sending '+message);


var url = "https://betasms.co.in/api/send.php?number=" + destNumber + "&type=text&message=" + message + "&instance_id=" + instanceId +"&access_token=" + access_token;

Logger.log(url);
var response = UrlFetchApp.fetch(url,{muteHttpExceptions:true});

Logger.log('api response :: ' + response);
}