Last active
October 15, 2022 14:51
-
-
Save kousiknaga/ca165e8f3fd1ce2c6fc19655f087b5a3 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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]); | |
} |
Author
kousiknaga
commented
Oct 15, 2022
- How can I get emails automatically instead of the manual button clicking whenever new emails arrive?
- 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