Building the Gmail parser application
The parseEmail
function is able to check 10 latest inbox threads, extract the from field and body text from unread messages, and put the gathered data in the left-most tab of the Sheet. Create the parseEmail
function as listed here:
/** * Gets content of latest unread message in Gmail inbox * and puts gathered data in left most tab of Sheets. * */ function parseEmail(){ // Left most sheet/tab var emailSheet = SpreadsheetApp.getActiveSpreadsheet() .getSheets()[0]; // Clear the entire sheet. emailSheet.clear(); // Checks maximum 10 threads var thread = GmailApp.getInboxThreads(0,10); var row = 1; for(var thrd in thread){ var messages = thread[thrd].getMessages(); for (var msg in messages) { var message = messages[msg]; if(message && message.isUnread()) emailSheet.getRange(row,1).setValue(message.getFrom()); emailSheet.getRange(row++,2) .setValue(message.getPlainBody())...