kousiknaga

var ui = SpreadsheetApp.getUi();
function onOpen(e){
  ui.createMenu("Gmail Manager").addItem("Get Emails", "getGmailEmails").addToUi();
}

function getGmailEmails(){
  var label = GmailApp.getUserLabelByName('test');
  var threads = label.getThreads();
  for(var i = threads.length - 1; i >=0; i--){
    var messages = threads[i].getMessages();