MikelMosso · July 17, 2020 14:56 · May 19, 2016 · May 19, 2016 · Mar 21, 2014 · Mar 21, 2014
diff --git a/gistfile1.js b/gistfile1.js
@@ -50,7 +50,9 @@ function parseEmailMessages() {
         sender = message.getFrom(),
         someData = extractData(content,"the", "."),
         name = extractData(content,"Name: ", "\n"),
-        comment = extractData(content,"Comment: ", "\n");
+        comment = content.match(/Comment:\s([^]+?)\n/);
+        // You may prefer regex for parsing, then extra validation needed
+        comment = (comment && comment[1]) ? comment[1]: 'N/A';
         // Add extra item to parse
 
       sheet.appendRow([date, subject, sender, someData, name, comment]);

diff --git a/gistfile1.js b/gistfile1.js
@@ -1,34 +1,63 @@
-function processInboxToSheet() {
-  //var threads = GmailApp.getInboxThreads();
+function extractData(data, startStr, endStr) {
+  // This function extracts text between two strings
+  // i.e. extractData("Good_news,_everyone!", "Good_", ",_Everyone!") will return "News"
+  var startIndex, endIndex, text = 'N/A';
+
+  startIndex = data.indexOf(startStr);
+
+  if(startIndex != -1) {
+    startIndex += startStr.length;
+    text = data.substring(startIndex);
+
+    if(endStr) {
+      endIndex = text.indexOf(endStr);
+
+      if(endIndex != -1) {
+        text = text.substring(0, endIndex);
+      } else {
+        text = 'N/A';
+      }
+    }
+  }
+  return text;
+}
+
+function parseEmailMessages() {
+  // var threads = GmailApp.search();
   // Have to get data separate to avoid google app script limit!
   var start = 0;
-  var threads = GmailApp.getInboxThreads(start, 100);
-  var sheet = SpreadsheetApp.getActiveSheet();
-  var result = [];
+  var sheetId, sheet, threads, labelName, label;
+  // SheetId is your google spreadsheet id
+
+  labelName = 'Parsed';
+  sheetId = 'abc1234567';
+  label = GmailApp.getUserLabelByName(labelName)||GmailApp.createLabel(labelName);
+  sheet = SpreadsheetApp.openById(sheetId).getSheets()[0];
+  threads = GmailApp.search('in:inbox -label:'+labelName, start, 100);
+  // Search query for messages without specific label
 
   for (var i = 0; i < threads.length; i++) {
-    var messages = threads[i].getMessages();
-
-    var content = messages[0].getPlainBody();
+    // Get the first email message of a threads
+    var message = threads[i].getMessages()[0];
+    var content = message.getPlainBody();
+    // Get the plain text body of the email message
+    // Note that for some types of messages getPlainBody() method may return null
+    // in such cases consider using getRawContent() or getBody() methods and parse HTML
 
-    // implement your own parsing rule inside
     if (content) {
-      var tmp;
-      tmp = content.match(/Name:\s*([A-Za-z0-9\s]+)(\r?\n)/);
-      var username = (tmp && tmp[1]) ? tmp[1].trim() : 'No username';
-
-      tmp = content.match(/Email:\s*([A-Za-z0-9@.]+)/);
-      var email = (tmp && tmp[1]) ? tmp[1].trim() : 'No email';
-
-      tmp = content.match(/Subject:\s*([A-Za-z0-9\s]+)(\r?\n)/);
-      var subject = (tmp && tmp[1]) ? tmp[1].trim() : 'No subject';
+      var date = message.getDate(),
+        subject = message.getSubject(),
+        sender = message.getFrom(),
+        someData = extractData(content,"the", "."),
+        name = extractData(content,"Name: ", "\n"),
+        comment = extractData(content,"Comment: ", "\n");
+        // Add extra item to parse
 
-      tmp = content.match(/Comments:\s*([\s\S]+)/);
-      var comment = (tmp && tmp[1]) ? tmp[1] : 'No comment';
-
-      sheet.appendRow([username, email, subject, comment]);
+      sheet.appendRow([date, subject, sender, someData, name, comment]);
+      threads[i].addLabel(label);
+      //add your label for parsed messages 
 
       Utilities.sleep(500);
-    }
-  }
-};
+    }// End if
+  }// End for loop
+}
diff --git a/gistfile1.js b/gistfile1.js
@@ -11,6 +11,7 @@ function processInboxToSheet() {
 
     var content = messages[0].getPlainBody();
 
+    // implement your own parsing rule inside
     if (content) {
       var tmp;
       tmp = content.match(/Name:\s*([A-Za-z0-9\s]+)(\r?\n)/);

diff --git a/gistfile1.js b/gistfile1.js
@@ -0,0 +1,33 @@
+function processInboxToSheet() {
+  //var threads = GmailApp.getInboxThreads();
+  // Have to get data separate to avoid google app script limit!
+  var start = 0;
+  var threads = GmailApp.getInboxThreads(start, 100);
+  var sheet = SpreadsheetApp.getActiveSheet();
+  var result = [];
+
+  for (var i = 0; i < threads.length; i++) {
+    var messages = threads[i].getMessages();
+
+    var content = messages[0].getPlainBody();
+
+    if (content) {
+      var tmp;
+      tmp = content.match(/Name:\s*([A-Za-z0-9\s]+)(\r?\n)/);
+      var username = (tmp && tmp[1]) ? tmp[1].trim() : 'No username';
+
+      tmp = content.match(/Email:\s*([A-Za-z0-9@.]+)/);
+      var email = (tmp && tmp[1]) ? tmp[1].trim() : 'No email';
+
+      tmp = content.match(/Subject:\s*([A-Za-z0-9\s]+)(\r?\n)/);
+      var subject = (tmp && tmp[1]) ? tmp[1].trim() : 'No subject';
+
+      tmp = content.match(/Comments:\s*([\s\S]+)/);
+      var comment = (tmp && tmp[1]) ? tmp[1] : 'No comment';
+
+      sheet.appendRow([username, email, subject, comment]);
+
+      Utilities.sleep(500);
+    }
+  }
+};
No results found