function sendNotification() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
//Get Active cell
var mycell = ss.getActiveSelection();
var cellcol = mycell.getColumn();
var cellrow = mycell.getRow();
var range = sheet.getRange(cellrow,2);
var data = range.getValue();
var text = "Message:"+data;
var base = "https://api.telegram.org/Bot_NAME:Bot_APIKEY/sendMessage?text="+text+"&chat_id=";
var channel_id = "CHANNELID";
var column_no = XX;
if (cellcol == column_no && sheet.getName() == "Sheet_NAME" && mycell.getValue() == "GO")
{
var url = base+"-"+channel_id;
var response = UrlFetchApp.fetch(url);
mycell.setValue("");
}
//End sendNotification
}
function createSpreadsheetEditTrigger() {
var ssss = SpreadsheetApp.getActive();
ScriptApp.newTrigger('sendNotification')
.forSpreadsheet(ssss)
.onEdit()
.create();
}