Gmail 脚本:获取特定标签 Google 脚本中话题的第一条消息主题

Question

        function Label () {
 var label = GmailApp.getUserLabelByName("Tools and Credentials");
 var threads = label.getThreads(0, 30);
 for (var i = 0; i < threads.length; i++) 
 {
   var firstmessagesubject = threads[i].getFirstMessageSubject();
   Logger.log(firstmessagesubject);
   SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Pull Thread variables").getRange(2+i,1,threads.length, 1).setValue(firstmessagesubject);
 }
}

以上是我编写的脚本，用于提取 GMail 上特定标签中线程的第一条消息的主题。标签有 11 个线程。但是，导出到电子表格的结果有 21 行，前 11 个正确条目，后 10 行是第 11 行的重复项。链接到我的结果表：https://docs.google.com/spreadsheets/d/1eVsBsduh63kL22iXUEKsdSqzrIyQGDOHP2y5Ddtmygc/edit#gid=998793935

Answer 1

由于每次迭代都在单个单元格中记录值，因此只需在设置值时指定行号和列号。

function Label () {
  var label = GmailApp.getUserLabelByName("Tools and Credentials");
  var threads = label.getThreads(0, 30);
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Pull Thread variables");
  for (var i = 0; i < threads.length; i++) {
    var firstmessagesubject = threads[i].getFirstMessageSubject();
    sheet.getRange(2+i,1).setValue(firstmessagesubject);
  }
}