Skip to content

Instantly share code, notes, and snippets.

@kerenbir
Last active January 4, 2020 00:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kerenbir/7b3b732881dd4413c7b157a64d9ea8a0 to your computer and use it in GitHub Desktop.
Save kerenbir/7b3b732881dd4413c7b157a64d9ea8a0 to your computer and use it in GitHub Desktop.
only for
function slalu(e){
var ui = SpreadsheetApp.getUi();
ui.createMenu("slalu").addItem("get emails", "getGmailEmails").addToUi();
}
function getGmailEmails(){
var label = GmailApp.getUserLabelByName("slalu");
var threads = label.getThreads();
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];
extractDetails(message);
GmailApp.markMessageRead(message);
}
}
}
function extractDetails(message){
var dateTime = message.getDate();
var subjectText = message.getSubject();
var senderDetails = message.getFrom();
var receiverDetail = message.getTo();
var activeSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
activeSheet.appendRow([dateTime, senderDetails, subjectText, receiverDetail]);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment