CODEWITHSUNDEEP
regexemailgoogle-sheetsgmail
Jaco Crafford
Jaco Crafford

Reputation: 71

Extract info from email body with Google Scripts

I am trying to extract specific info from email in one of my labels in Gmail. I've hacked (my scripting knowledge is very limited) the following together based on a script from https://gist.github.com/Ferrari/9678772. I am getting an error though: "Cannot convert Array to Gmail Thread - Line 5"

Any help will be greatly appreciated.

/* Based on https://gist.github.com/Ferrari/9678772 */
function parseEmailMessages(start) {

  /* var threads = GmailApp.getInboxThreads(start, 100); */
  var threads = GmailApp.getMessagesForThread(GmailApp.search("label:labelname"));
  var sheet = SpreadsheetApp.getActiveSheet();

  var tmp, result = [];

  for (var i = 0; i < threads.length; i++) {

   // Get the first email message of a threads
    var message = threads[i].getMessages()[0];

   // Get the plain text body of the email message
   // You may also use getRawContent() for parsing HTML
    var content = messages[0].getPlainBody();


   // Implement Parsing rules using regular expressions
    if (content) {

      tmp = content.match(/Name and Surname:\n([A-Za-z0-9\s]+)(\r?\n)/);
      var username = (tmp && tmp[1]) ? tmp[1].trim() : 'No username';

      tmp = content.match(/Phone Number:\n([\s\S]+)/);
      var phone = (tmp && tmp[1]) ? tmp[1] : 'No phone';

      tmp = content.match(/Email Address:\n([A-Za-z0-9@.]+)/);
      var email = (tmp && tmp[1]) ? tmp[1].trim() : 'No email';

      tmp = content.match(/Prefered contact office:\n([\s\S]+)/);
      var comment = (tmp && tmp[1]) ? tmp[1] : 'No office';



      sheet.appendRow([username, phone, email, comment]);

    }
  }
};

Upvotes: 4

Views: 7693

Answers (2)

Jaco Crafford
Jaco Crafford

Reputation: 71

Thanks folks.. This did the trick:

// Adapted from https://gist.github.com/Ferrari/9678772
function processInboxToSheet() {

  // Have to get data separate to avoid google app script limit!

  var start = 0;
  var label = GmailApp.getUserLabelByName("yourLabelName");
  var threads = label.getThreads();

  var sheet = SpreadsheetApp.getActiveSheet();
  var result = [];



  for (var i = 0; i < threads.length; i++) {
    var messages = threads[i].getMessages();

    var content = messages[0].getPlainBody();

    // implement your own parsing rule inside
    if (content) {
      var tmp;
      tmp = content.match(/Name and Surname:\n([A-Za-z0-9\s]+)(\r?\n)/);
      var username = (tmp && tmp[1]) ? tmp[1].trim() : 'No username';

      tmp = content.match(/Phone Number:\n([\s\S]+)/);
      var phone = (tmp && tmp[1]) ? tmp[1] : 'No phone';

      tmp = content.match(/Email Address:\n([A-Za-z0-9@.]+)/);
      var email = (tmp && tmp[1]) ? tmp[1].trim() : 'No email';

      tmp = content.match(/Prefered contact office:\n([\s\S]+)/);
      var comment = (tmp && tmp[1]) ? tmp[1] : 'No office';



      sheet.appendRow([username, phone, email, comment]);

      Utilities.sleep(500);
    }
  }
};

Upvotes: 3

bob0the0mighty
bob0the0mighty

Reputation: 782

var threads = GmailApp.getMessagesForThread(GmailApp.search("label:labelname"));

should include an array index since GmailApp.search returns an array, even if only one item is found.

var threads = GmailApp.getMessagesForThread(GmailApp.search("label:labelname")[0]);

would work but is wordy.

var thread_list = GmailApp.search("label:labelname");
var threads = GmailApp.getMessagesForThread(thread_list[0]);

IMO, the above is clearer in meaning.

Upvotes: 0

Related Questions