下面的代碼是我目前用來將 csv 檔案匯入谷歌表格的代碼，一切正常，除了代碼總是獲取執行緒中最舊的電子郵件并且我希望它總是選擇最新的電子郵件。
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
}
uj5u.com熱心網友回復：
嘗試替換var message = threads[0].getMessages()[0];為
var message = threads[0].getMessages()[Number(threads[0].getMessageCount()-1)];
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/473310.html