Skip to content

Instantly share code, notes, and snippets.

@LeetCodes
Forked from simecek/gist:1587954
Created December 25, 2017 22:17
Show Gist options
  • Save LeetCodes/b53a4b0c56b296e5436c3620c4ad40d2 to your computer and use it in GitHub Desktop.
Save LeetCodes/b53a4b0c56b296e5436c3620c4ad40d2 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