Gmail Analysis

gistfile1.js

function SearchEmail() {
  var mySheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var EmailName = Browser.inputBox("Search", "Type from:[email protected]", Browser.Buttons.OK_CANCEL);
  var maxthreads = 250;
  var searchedThreads= GmailApp.search("from:(<" + EmailName + ">)", 0, maxthreads);
  var regExp = new RegExp(".*<" + EmailName + ">$");
  var counter = 1;
  
  for(var i in searchedThreads){
    var messages = searchedThreads[i].getMessages();
    for(var k in messages){
      var messagefrom = messages[k].getFrom();
      var date = messages[k].getDate();
      var time = Utilities.formatDate(date, "Europe/Paris", "HH:mm:ss");
      if (regExp(messagefrom)) {
        counter += 1;
        mySheet.getRange(counter,1).setValue(time);
      }    
    }
  }
}