Nhận báo cáo hàng ngày từ Google Biểu mẫu hoặc Trang tính trong JANDI

function myFunction() {
    var form = FormApp.getActiveForm();
    var lastLine = FormApp.getActiveForm().getResponses().length;
    // latest
    var name = form.getResponses()[lastLine - 1].getItemResponses()[0].getResponse(); // name
    var dateOfSale = form.getResponses()[lastLine - 1].getItemResponses()[1].getResponse(); // dateOfSale
    var revlonSale = form.getResponses()[lastLine - 1].getItemResponses()[2].getResponse(); // revlonSale
    var RealTechniquesSales = form.getResponses()[lastLine - 1].getItemResponses()[3].getResponse(); // RealTechniquesSales
    var Location = form.getResponses()[lastLine - 1].getItemResponses()[4].getResponse(); // Location
  
    var message = 'Name : ' + name + '\n' + 'Date of Sale : ' + dateOfSale;
    // jandi setting

    var jandi_incoming_url = "https://wh.jandi.com/connect-api/webhook/279/b0c394c6ee6629f625679739d7c123rdf"; //change webhook url  
    var jandi_headers = {
        "Accept": "application/vnd.tosslab.jandi-v2+json",
        "Content-type": "application/json",
    };
    var jandi_formData = {
        "body": message,
        "connectColor": "#FAC11B",
        "connectInfo": [{
          "title": 'Revlon Sale : ' + revlonSale + ", Real Techniques Sale : " + RealTechniquesSales,
          'description': "Location : " + Location + "\n[Go to GoogleSheet](https://docs.google.com/spreadsheets/d/18FrpilB815hdQCm1r9ZdCk5_HV53Cv0XaeCtyeoRCHE/edit#gid=1211612343)"
        }]
    };
    var jandi_options = {
        "method": "POST",
        "payload": JSON.stringify(jandi_formData),
        "headers": jandi_headers,
    };
    response = UrlFetchApp.fetch(jandi_incoming_url, jandi_options);
 
}