Skip to content

Instantly share code, notes, and snippets.

@kousiknaga
Last active October 15, 2022 14:51
Show Gist options
  • Save kousiknaga/ca165e8f3fd1ce2c6fc19655f087b5a3 to your computer and use it in GitHub Desktop.
Save kousiknaga/ca165e8f3fd1ce2c6fc19655f087b5a3 to your computer and use it in GitHub Desktop.
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();
for (var j = 0; j <messages.length; j++){
var message = messages[j];
extractDetails(message);
}
threads[i].removeLabel(label);
}
}
function extractDetails(message){
var dateTime = message.getDate();
var subjectText = message.getSubject();
var senderDetails = message.getFrom();
var activeSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
activeSheet.appendRow([dateTime, senderDetails, subjectText]);
}
@kousiknaga
Copy link
Author

  1. How can I get emails automatically instead of the manual button clicking whenever new emails arrive?
  2. Also help to get a unique email with a unique subject line that arrived first in the labeled.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment