Untitled

 avatar
unknown
plain_text
2 years ago
1.4 kB
5
Indexable
var ui = SpreadsheetApp.getUi();
function onOpen(){
  ui.createMenu("Gmail Manager").addItem("Get Emails by Label", "getGmailEmails").addToUi();  
}

function getGmailEmails(){
  var threads = GmailApp.search('subject:"New customer message"');

  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];
      console.log(message.getDate());
      if (message){
        extractDetails(message);
        }
    }

  }
  
}

function extractDetails(message){
  
  var emailData = {
    date: "Null",
    fullName: "Null",
    emailAddr: "Null",
    phoneNum: "Null",
    message: "Null"
  }
  
  emailData.date = message.getDate();
  body = message.getPlainBody();

  var splitted = body.split("\n");

  emailData.fullName = splitted[14].trim();
  console.log(emailData.fullName);
  
  emailData.phoneNum = splitted[18].trim();
  
  emailData.emailAddr = splitted[22].trim();

  emailData.message = splitted.slice(26).join("").replace(/(\r\n|\n|\r)/gm, "");;

  console.log(emailData);
  
  
  var activeSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  
  var emailDataArr = [];
  
  for(var propName in emailData){
    emailDataArr.push(emailData[propName]);
  }
  activeSheet.appendRow(emailDataArr);
}
Editor is loading...