对于使用谷歌脚本阅读电子邮件的循环

Question

我们正在尝试创建一个脚本，根据电子邮件的标签来读取某些电子邮件，并将某些内容写入电子表格。在循环状态.getPlainBody()未定义之前，我们只能向电子表格中写入一封相当于电子邮件的数据。下面是我们的代码和我们得到的确切错误

TypeError: Cannot read property 'getPlainBody' of undefined
myFunction  @ Code.gs:12

如有任何帮助，我们将不胜感激！

function myFunction() {
var ss = SpreadsheetApp.openById("105dNWvYNTPzqw1YHHclu00vKLclyEi9UjQBoX0_JTYM");
var sheet = ss.getSheetByName("Daily Log Data");

var label =GmailApp.getUserLabelByName("Test");
var threads = label.getThreads();
Logger.log(threads);
for(var i = 0; i < threads.length; i++) {
var mess = threads[i].getMessages();
var pmsg = mess[i].getPlainBody();
Logger.log(mess);

// Mutual Aid
if (pmsg.includes("MutualAid: ")>0) {
var endMut = pmsg.substring(mess.indexOf("MutualAid: ")+11,pmsg.length);
var Mut = endMut.substring(0,endMut.indexOf("n"));
sheet.appendRow([Mut]);
}
}
}

Answer 1

这样试试：

function myFunction() {
var ss = SpreadsheetApp.openById("105dNWvYNTPzqw1YHHclu00vKLclyEi9UjQBoX0_JTYM");
var sh = ss.getSheetByName("Daily Log Data");
var lbl = GmailApp.getUserLabelByName("Test");
var threads = lbl.getThreads();
for (var i = 0; i < threads.length; i++) {
var mess = threads[i].getMessages();
for (var j = 0; j < mess.length; j++) {
var pmsg = mess[j].getPlainBody();
if (pmsg.includes("MutualAid: ") > 0) {
var endMut = pmsg.substring(mess.indexOf("MutualAid: ") + 11, pmsg.length);
var Mut = endMut.substring(0, endMut.indexOf("n"));
sh.appendRow([Mut]);
}
}
}
}