Quy trình: tạo web app -> lấy email thông qua script kết nối đến web app.

// 1. THAY URL WEB APP SAU KHI DEPLOY PHIEN BAN MOI

var WEB_APP_URL = "URL_WEB_APP_CUA_BAN";

// 2. THAY ID CUA SPREADSHEET

var SPREADSHEET_ID = "ID_SPREADSHEET_CUA_BAN";

// 3. TEN TRANG TINH

var SHEET_NAME = "myalphastyles";

  

function onOpen() {

  var ui = SpreadsheetApp.getUi();

  ui.createMenu('Công cụ Gmail')

      .addItem('Lấy 10 email của Host', 'triggerHostScript')

      .addToUi();

}

  

/**

 * Ham kich hoat chay duoi quyen Host

 */

function triggerHostScript() {

  if (WEB_APP_URL.includes("URL_WEB_APP")) {

    SpreadsheetApp.getUi().alert("Ban chua cau hinh URL Web App.");

    return;

  }

  try {

    var response = UrlFetchApp.fetch(WEB_APP_URL + "?t=" + new Date().getTime(), {

      "muteHttpExceptions": true

    });

    if (response.getResponseCode() == 200) {

      SpreadsheetApp.getUi().alert("Dang cap nhat du lieu cho sheet: " + SHEET_NAME);

    } else {

      SpreadsheetApp.getUi().alert("Loi: " + response.getContentText());

    }

  } catch (e) {

    SpreadsheetApp.getUi().alert("Loi ket noi: " + e.toString());

  }

}

  

function doGet() {

  try {

    getRecentEmails();

    return ContentService.createTextOutput("Success");

  } catch (e) {

    return ContentService.createTextOutput("Error: " + e.toString());

  }

}

  

/**

 * Ham thuc thi chinh

 */

function getRecentEmails() {

  var ss = SpreadsheetApp.openById(SPREADSHEET_ID);

  var sheet = ss.getSheetByName(SHEET_NAME);

  if (!sheet) throw new Error("Khong tim thay sheet: " + SHEET_NAME);

  var searchTerm = sheet.getRange("A1").getValue();

  var query = (!searchTerm || searchTerm.toString().trim() === "") ? "" : searchTerm;

  // Xoa du lieu cu

  var lastRow = sheet.getLastRow();

  if (lastRow >= 3) {

    sheet.getRange(3, 1, lastRow - 2, 4).clearContent();

  }

  var threads = GmailApp.search(query, 0, 10);

  var results = [];

  for (var i = 0; i < threads.length; i++) {

    var messages = threads[i].getMessages();

    var lastMessage = messages[messages.length - 1];

    var rawSnippet = lastMessage.getPlainBody().substring(0, 200);

    // Xu ly fix link neu co dau cach trong snippet

    var cleanSnippet = fixLinksInText(rawSnippet);

    results.push([

      lastMessage.getDate(),

      lastMessage.getFrom(),

      lastMessage.getSubject(),

      cleanSnippet

    ]);

  }

  if (results.length > 0) {

    sheet.getRange(2, 1, 1, 4).setValues([["Ngày", "Người gửi", "Tiêu đề", "Nội dung (Đã fix link)"]]);

    sheet.getRange(2, 1, 1, 4).setFontWeight("bold").setBackground("#f3f3f3");

    sheet.getRange(3, 1, results.length, 4).setValues(results);

    sheet.autoResizeColumns(1, 4);

  }

}

  

/**

 * Ham ho tro tim va thay the khoang trong trong link bang %20

 */

function fixLinksInText(text) {

  if (!text) return "";

  // Regex tim cac chuoi giong URL (bat dau bang http hoac https)

  var urlRegex = /(https?:\/\/[^\s]+)/g;

  // Luu y: Neu link co dau cach, regex thong thuong se bi ngat o dau cach do.

  // Neu link cua ban bi loi do dau cach, ta can dung encodeURI cho toan bo text

  // hoac xu ly rieng neu ban co mot cot link rieng biet.

  // Cach don gian nhat de fix link co dau cach la dung replace

  return text.replace(/ /g, "%20");

  // Neu ban chi muon fix rieng phan URL ma khong anh huong den van ban:

  // (Cach nay phuc tap hon mot chut, nen dung neu snippet co ca chu va link)

}