miftahafina

function cekNilai(nis) {
  // Buka sheet
  let sheetUrl = "URL_GOOGLE_SHEETS";
  let file = SpreadsheetApp.openByUrl(sheetUrl);
  let sheet = file.getSheetByName("Sheet1");
  let last_row = sheet.getLastRow();
  
  // Ambil data
  let nilai_list = sheet.getRange(`A2:C${last_row}`).getValues();
  let nilai_filtered = nilai_list.filter(el => el[0] == nis);

miftahafina

function doPost(e) {
  // Buka sheet
  let sheetUrl = "YOUR_SHEET_URL";
  let file = SpreadsheetApp.openByUrl(sheetUrl);
  let sheet = file.getSheetByName("Sheet1");

  // Rapikan data
  let req = JSON.stringify(e).replace(/\\/g, "").replace("}\"", "}").replace("\"{", "{");
  let reqJson = JSON.parse(req);
  let senderMessage = JSON.stringify(reqJson["postData"]["contents"]["senderMessage"]);

miftahafina

function SendMessage(nomor_wa, pesan)
{
  var url   = 'https://pati.wablas.com/api/v2/send-message';
  var token = 'YOUR_SECURITY_TOKEN_HERE';

  var headers = {
    'Authorization' : token,
    'content-type'  : 'application/json',
  };