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())...