//API url:
//1. Send message: "[Link] + token + "/sendMessage?text=" +
encodeURIComponent(message) + "&chat_id=" + chatId + "&parse_mode=HTML";
//2. Send image: "[Link] + token + "/sendPhoto?caption=" +
encodeURIComponent(caption) + "&chat_id=" + chatId + "&parse_mode=HTML";
//3. Send Document: "[Link] + token + "/sendDocument?
chat_id=" + chatId + "&caption=" + encodeURIComponent(caption)
//Telegram info
var token = "6339377366:AAGj_xn8rhATL2AntOwsaw0DgM8eEKFh52M";
var telegramUrl = "[Link] + token;
var chatId = "-1001456563703"
//Sheet info
var ss = [Link]();
var sh_sendMessage = [Link]("Gửi tin nhắn")
function sendOption() {
var option = sh_sendMessage.getRange("E1").getValue();
if (option == "Send message") {
sendNotify()
} else if (option == "Send image") {
sendImage()
} else if (option == "Send document") {
sendDocument()
}else{
[Link]("Lựa chọn không tồn tại")
}
}
function sendImage() {
var caption = sh_sendMessage.getRange("A3").getValue()
var file = sh_sendMessage.getRange("A7").getValue().split("/")
[Link](file)
[Link](file[5])
var blob = [Link](file[5]).getBlob();
var url = telegramUrl + "/sendPhoto?caption=" + encodeURIComponent(caption) +
"&chat_id=" + chatId + "&parse_mode=HTML";
[Link](url, { method: "post", payload: { photo: blob } })
}
function sendDocument() {
var caption = sh_sendMessage.getRange("A3").getValue()
var file = sh_sendMessage.getRange("A7").getValue().split("/")
[Link](file)
[Link](file[5])
var blob = [Link](file[5]).getBlob();
var url = telegramUrl + "/sendDocument?chat_id=" + chatId + "&caption=" +
encodeURIComponent(caption);
[Link](url, { method: "post", payload: { document: blob } })
}
function getUpdateGrpInfo() {
var response = [Link](telegramUrl + "/getUpdates");
var data = [Link](response);
var sh_group = [Link]('Group List');
var arrayData = [];
[Link](function (result) {
if ([Link]) {
chatID = [Link]();
if ([Link] == 'private') {
name = [Link].first_name;
} else {
name = [Link];
}
[Link]([name, chatID]);
} else if (result.my_chat_member) {
chatID = result.my_chat_member.[Link]();
name = result.my_chat_member.[Link];
[Link]([name, chatID]);
}
});
[Link]("Array: ", arrayData);
sh_group.getRange(sh_group.getLastRow() + 1, 6, [Link],
2).setValues(arrayData);
}