Help extracting gMail Data based on label

[biotechguy]

Hi Everyone,

I found this great macro from Ben Collins which will pull gmail data based on labels. His macro was more complicated than I needed with removing duplicates. Though his only had the name and email, whereas I need the date and subject as well. The error I am getting is the final line. I think it is because I cannot figure out the array name.


function extractEmails() {

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var label = sheet.getRange(1,2).getValue();

var threads = GmailApp.search ("label:" + label);

var messages = GmailApp.getMessagesForThreads (threads);

var emailArray = [];

messages.forEach(function(message) {
message.forEach(function(d) {
emailArray.push(d.getFrom(),d.getTo(),d.getDate(),d.getSubject);
});
});

sheet.getRange(4,1,sheet.getLastRow(),4).clearContent();

sheet.getRange(4,1,Array.length,4).setValues(Array).sort(3);

}