Untitled
unknown
plain_text
2 years ago
1.4 kB
5
Indexable
var ui = SpreadsheetApp.getUi(); function onOpen(){ ui.createMenu("Gmail Manager").addItem("Get Emails by Label", "getGmailEmails").addToUi(); } function getGmailEmails(){ var threads = GmailApp.search('subject:"New customer message"'); 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]; console.log(message.getDate()); if (message){ extractDetails(message); } } } } function extractDetails(message){ var emailData = { date: "Null", fullName: "Null", emailAddr: "Null", phoneNum: "Null", message: "Null" } emailData.date = message.getDate(); body = message.getPlainBody(); var splitted = body.split("\n"); emailData.fullName = splitted[14].trim(); console.log(emailData.fullName); emailData.phoneNum = splitted[18].trim(); emailData.emailAddr = splitted[22].trim(); emailData.message = splitted.slice(26).join("").replace(/(\r\n|\n|\r)/gm, "");; console.log(emailData); var activeSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var emailDataArr = []; for(var propName in emailData){ emailDataArr.push(emailData[propName]); } activeSheet.appendRow(emailDataArr); }
Editor is loading...