使用Google Scripts从电子邮件正文中提取信息

问题描述

限时删除！！

我正在尝试从Gmail中的一个标签中的电子邮件中提取特定信息。根据。我收到一个错误：无法将数组转换为Gmail线程 - 第5行

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"

任何帮助将不胜感激。

/* 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]);

    }
  }
};

推荐答案

谢谢你们..这样做的技巧： p>

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);
    }
  }
};

这篇关于使用Google Scripts从电子邮件正文中提取信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

1403页，肝出来的..