时间戳

首页 > 解决方案 > 在当前时间之前 10 分钟使用 Google App Script 从 Gmail 获取电子邮件

javascript - 在当前时间之前 10 分钟使用 Google App Script 从 Gmail 获取电子邮件

问题描述

我想在当前时间之前 10 分钟使用 Google App Script 搜索电子邮件，我编写了以下脚本，但它不起作用，因为我有与查询中定义的主题相同的电子邮件，并且在 10 分钟之前（甚至在邮件之前 1 分钟）那里）但气体显示零线程。

function testforemails(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("Emails");
  var Gmail = GmailApp;
  var lasttime = sheet.getRange("Z1").getValue(); // it will use later as the time of last searched email.
  Logger.log(lasttime);
  var cdate = new Date();
  var ctime = cdate.getTime();
  var qDate = new Date(ctime - 600000); // less 10 minutes from current time.
  Utilities.formatDate(qDate, Session.getScriptTimeZone(), "dd-MMM-yy hh:mm a")
  Logger.log("QDATE IS " + qDate); //  perfectly displaying time less than 10 minutes
  var qtime = qDate.getTime();
  Logger.log("qtime is " + qtime);

  // SEARCH EMAIL
  var query = 'subject: defined subject of emails, after:' + (qDate);
  var threadsNew = Gmail.search(query);
  Logger.log(threadsNew.length);
  var folderid = 'define folder id'
  var folder = DriveApp.getFolderById(folderid);
  for(var n in threadsNew){
    var thdNew  = threadsNew[n]; 
    var msgsNew = thdNew.getMessages();　
    var msgNew = msgsNew[msgsNew.length-1];
  // GET ATTACHMENT
    var bodyNew = msgNew.getBody();
    var plainbody  = msgNew.getPlainBody();
    var subject = msgNew.getSubject();
    var Etime = msgNew.getDate();
    var attachments = msgNew.getAttachments();
    var attachment = attachments[0];
    
    Logger.log(Etime);
    Logger.log(subject);
  }
    
    Logger.log(threadsNew.length);
    
    
}

标签： javascriptgoogle-apps-scriptgoogle-sheetsautomationgmail

解决方案

更新

这是完全可以做到的，请参阅@Iamblichus 的说明。无论如何，我的方法也有效，所以我保留让用户选择更适合他需要的方法。

实现此目标的解决方法：

function testforemails(){
  // SEARCH EMAIL
  let now = new Date();
  let query = 'subject: YOUR_SUBJECT, after:' + now.toISOString().slice(0, 10); // find mails from today
  console.log(query);
  let threadsNew = GmailApp.search(query);
  console.log("threadsNew.length: " + threadsNew.length);

  for(let thread of threadsNew){
    let lastMsgTime = thread.getLastMessageDate();
    let tenMinutesAgo = new Date(now - 600000);

    if(lastMsgTime - tenMinutesAgo > 0) { // if the last message on the thread was less than 10 minutes ago
      // do your magic here
      console.log(thread.getLastMessageDate())
    }  
  }    
}

推荐阅读