I want to send a sms with dedicated name per message to different numbers this is my code.
var deviceId = "95";
var sheetName = "Barcode Registration";
var orderStatusColumn = 3;
var OrderStatusUpdate = "SEND";
var NewOrderStatus = "";
var CustomerPhoneCol = 2;
var smsSentColumn = 8;
var msgNewOrder = encodeURIComponent('Magandang araw <<NAME>>, mula kay Mark Anthony Halili!nn Makiki-kumpirma sa staff kung natanggap mo ang mensaheng itonn Maraming salamat!');
var msgConfirmedOrder = encodeURIComponent('Magandang araw <<NAME>>, mula kay Mark Anthony Halili!nn Makiki-kumpirma sa staff kung natanggap mo ang mensaheng itonn Maraming salamat!');
function OrderUpdated(e) {
var sheet = e.source.getActiveSheet();
var range = e.range;
var row = range.getRow();
var col = range.getColumn();
if (col == orderStatusColumn) {
var status = sheet.getRange(row, col).getValue();
if (status === OrderStatusUpdate) {
var PhoneNumber = sheet.getRange(row, CustomerPhoneCol).getValue();
var link = "https://app.sms8.io/services/send.php?key="+ApiKey+"&number="+PhoneNumber+"&message="+msgConfirmedOrder+"&devices="+deviceId+"&type=sms&prioritize=0";
if (msgConfirmedOrder !== "") {
try {
var response = UrlFetchApp.fetch(link);
Logger.log("Response Code: " + response.getResponseCode());
} catch (error) {
Logger.log("Error fetching URL: " + error);
SpreadsheetApp.getUi().alert("Message not sent", error, SpreadsheetApp.getUi().ButtonSet.OK);
}
}
}
}
}
Please help me with my codes. I want to send a message with the name of the owner of the number I have it in my sheet.
here is the copy of my google sheet
https://docs.google.com/spreadsheets/d/1a_xlmEZbUT3a3lgB2N0v98adCyE2BT_7ODw1hHoF5lk/copy