CODEWITHSUNDEEP
javascriptformsgoogle-apps-scriptspreadsheet
TripleBritz
TripleBritz

Reputation: 35

Send Message to LINE Notify from Google Spreadsheets with Apps Script

So I am trying to send message to LINE Notify from Google Spreadsheets via google form responses, I already testing the API with Postman and it works, I got the Notification, however it doesn't works on the Apps Script Code. here's the error log:

enter image description here

function autoFillPendataanKontak(e) {
  var nama = e.values[1];
  var nim = e.values[2];
  var bidang = e.values[3];
  
  var file = DriveApp.getFileById('------');
  
  var doc = DocumentApp.openById(file.getId()); 
  
  var body = doc.getBody();

  function sendLineNotify(messageNama, messageBidang) {

    var token = ["------"];
    var options = {
        "method": "post",
        "payload": messageNama + " telah mendaftar di Bidang " + messageBidang,
        "headers": {
            "Authorization": "Bearer " + token
        }
    };
    UrlFetchApp.fetch("https://notify-api.line.me/api/notify", options);
  }

  function appendTable(variabel1, variabel2){
      var rangePSDI = null;
      var searchElement = body.findElement(DocumentApp.ElementType.TABLE, rangePSDI);
      element = searchElement.getElement();
      table = element.asTable();
      if (bidang == 'PSDI') {
          body.replaceText('{{a}}', variabel1);
          body.replaceText('{{b}}', variabel2);
          var tr = table.appendTableRow();
          var ukur = table.getNumRows();    
          ukur -= 3;
          tr.appendTableCell(ukur+1);
          tr.appendTableCell("{{a}}");
          tr.appendTableCell("{{b}}");
      } else if (bidang == 'PSDM') {
          body.replaceText('{{c}}', variabel1);
          body.replaceText('{{d}}', variabel2);
          var tr = table.appendTableRow();
          var ukur = table.getNumRows();
          ukur -= 3;
          tr.appendTableCell(ukur + 1);
          tr.appendTableCell("{{c}}");
          tr.appendTableCell("{{d}}");
      }
  }

  appendTable(nama, nim);
  sendLineNotify(nama, bidang);

  doc.saveAndClose(); 
}

Upvotes: 1

Views: 2033

Answers (1)

TripleBritz
TripleBritz

Reputation: 35

Solved the problem, I just forgot the "message=" on payload

"payload": "message=" + messageNama + " telah mendaftar di Bidang " + messageBidang,

Upvotes: 1

Related Questions