Skip to content

Instantly share code, notes, and snippets.

@simecek
Created January 10, 2012 08:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save simecek/1587954 to your computer and use it in GitHub Desktop.
Save simecek/1587954 to your computer and use it in GitHub Desktop.
Gmail Analysis
function SearchEmail() {
var mySheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var EmailName = Browser.inputBox("Search", "Type from:email@address.cz", 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);
}
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment