I need to update the app script to also capture Gmail attachments' name along with other details

Question

First of all, I am not familiar with coding. I have a code that I use to pull certain information from Gmail based on the labels. Now the problem is, the code does not include a line to have the name of attachment. It would be really helpful if someone can write an additional code for that.

Below is the code that I use.. I tried adding the code var attachment = messages[j].getAttachments().getName(); to it, but doesn't work.

  var label = GmailApp.getUserLabelByName("NAME OF LABEL");
  var threads = label.getThreads();
  
  for (var i = threads.length - 1; i >=0; i--){
    var messages = threads[i].getMessages();
    
    for (var j = 0; j <messages.length; j++){
      var message = messages[j];
        extractDetails(message);
      }
   }
  

function extractDetails(message){
  var dateTime = message.getDate();
  var subjectText = message.getSubject();
  var senderDetails = message.getFrom();
  var bodyContents = message.getPlainBody();
  
  var activeSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  activeSheet.appendRow([dateTime, senderDetails, subjectText, bodyContents]);
}

Answer 1

As noted in the comments, getAttachments() returns an array. So you need to loop through to get any/all of the attachment details.

• for (var k = 0; k < attachments.length; k++) { is taken from the documentation.
• var messagedetails=[] - this is a blank array created to accept message details (including attachment details).
• messagedetails.push(attachments[k].getName(),attachments[k].getSize()) This line adds the attachment Name and Size to the message details
• activeSheet.appendRow(messagedetails) - this line appends a new row. the details come from the "messagedetails" array.

---

function getmessagedetails(){
  //var label = GmailApp.getUserLabelByName("NAME OF LABEL");
  var label = GmailApp.getUserLabelByName("[email protected]/164538")
  var threads = label.getThreads()

  for (var i = threads.length - 1; i >=0; i--){
    var messages = threads[i].getMessages();
    for (var j = 0; j <messages.length; j++){
      var message = messages[j]
      extractDetails(message)
    }
  }
} 

function extractDetails(message){

  var messagedetails=[]
  messagedetails.push(message.getDate(),message.getSubject(),message.getFrom(),message.getPlainBody())
  var attachments = message.getAttachments()
    for (var k = 0; k < attachments.length; k++) {
      Logger.log('Message "%s" contains the attachment "%s" (%s bytes)',
        message.getSubject(), attachments[k].getName(), attachments[k].getSize());
      messagedetails.push(attachments[k].getName(),attachments[k].getSize())
    }
  var activeSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  activeSheet.appendRow(messagedetails)
}

---