/* * Kirim Pesan WhatsApp Sekali Klik dengan Check Box di Google Spreadsheet - Google Apps Script * ******************************************************************************************** * Code by : Agus Adiyanto * Contact me : whacenter@gmail.com * Website : https://whacenter.my.id * Date : 9 Februari 2024 * Revisi : 23 Januari 2025 * License : Tidak untuk diperjualbelikan kembali (non-commercial). * Hak cipta dilindungi Undang-undang */ function onClickCheck(e) { var range = e.range; var row = range.getRow(); var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1"); //Ganti dengan nama sheet aktif Anda var hp = ss.getRange(row,3).getValue(); //Sesuaikan kolom no hp/WA di spreadsheet Anda var message = ss.getRange(row,6).getValue(); //Sesuaikan kolom pesan/message di spreadsheet Anda var kirim = ss.getRange(row,7).getValue(); //Sesuaikan kolom ceklis/checkbox di spreadsheet Anda var status = ss.getRange(row,8).getValue(); //Sesuaikan kolom status di spreadsheet Anda if(kirim == true && status == '') { const result = sendWaText(hp,message); const json = result.getContentText(); const obj = JSON.parse(json); if(obj.status == false) { ss.getRange(row,8).setValue("FAILED : "+obj.message); } else { ss.getRange(row,8).setValue("SUCCESS : "+obj.message+" with ID "+obj.data.id); } } } function sendWaText(number,message){ var idDevice = "xxx"; //Ganti dengan device id Anda var formdata = { "device_id" : ""+idDevice, "number" : ""+number, "message" : ""+message } var requestOptions = { method: 'POST', 'contentType':'application/json', 'payload':JSON.stringify(formdata), redirect: 'follow' }; var response = UrlFetchApp.fetch("https://app.whacenter.com/api/send", requestOptions); Logger.log(response) return response; }