以下应用程序脚本代码获得了最旧的电子邮件（从gmail），我该如何获得最新的电子邮件？

Question

以下代码是我当前用来将CSV文件导入Google表格的代码，一切都很好，除了代码始终在线程中获取最古老的电子邮件，我希望它始终选择最新的电子邮件。

function importCSVFromGmail() {

  var threads = GmailApp.search('subject:(Daily Scheduled Report Recruiting Metrics) AND newer_than:3h'); // enter search criteria here
  var message = threads[0].getMessages()[0];
  var attachment = message.getAttachments()[0];


  var sheet = SpreadsheetApp.openById('1mflZmtgChZOFGVdlnyNrlDmVOxKEw6Hk0RJzilTvnMo').getSheetByName('Sheet1');
  var csvData = Utilities.parseCsv(attachment.getDataAsString(), ",");

   sheet.clearContents().clearFormats(); // clears target sheet
   sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData); // adds data to the sheet
}

Answer 1

尝试替换var message = threads [0] .getMessages（）[0]; by

var message = threads[0].getMessages()[Number(threads[0].getMessageCount()-1)];