Code Gửi Email (Đơn Đặt Hàng)

 function guiBieuMau(e) {
    var email = "gmailcuaban@gmail.com";
    var subject = "Đơn đặt hàng";
    var s = SpreadsheetApp.getActiveSheet();
    var columns = s.getRange(1, 1, 1, s.getLastColumn()).getValues()[0];
    var message = "";
    for (var keys in columns) {
        var key = columns[keys];
        if (e.namedValues[key] && (e.namedValues[key] != "")) {
            message += key + ' :: ' + e.namedValues[key] + "\n\n";
        }
    }
    MailApp.sendEmail(email, subject, message);
}