问从Gmail导出表单数据-为电子邮件日期/时间添加列

EN

    function parseEmailMessages(start) {

    start = start || 0;

    var labelName = "Temp1"; //             <-------  SET THE LABEL NAME
    var labels = GmailApp.getUserLabels();
    var threads = [];
    for (var i = 0; i < labels.length; i++) {
    if (labels[i].getName() == labelName) {
    threads = labels[i].getThreads();
    break;
    }
    }
    var sheet = SpreadsheetApp.getActiveSheet();

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

    // Get the first email message of a threads
    var tmp,
    message = threads[i].getMessages()[0],
    subject = message.getSubject(),
    content = message.getPlainBody();

    // Get the plain text body of the email message
    // You may also use getRawContent() for parsing HTML

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

    tmp = content.match(/First:\s*([A-Za-z0-9!"?`?|äõüö’–_—žčâèçëıÅĂôà=ÚíšÃÉÁÇÃáéñãóú#&; 
    ()-,'@./\s\-]+)(\r?\n)/);
    var first = (tmp && tmp[1]) ? tmp[1].trim() : 'BLANK';

    tmp = content.match(/Last:\s*([A-Za-z0-9!"?`?|äõüö’–_—žčâèçëıÅĂôà=ÚíšÃÉÁÇÃáéñãóú#&; 
    ()-,'@./\s\-]+)(\r?\n)/);
    var last = (tmp && tmp[1]) ? tmp[1].trim() : 'BLANK';
  
    tmp = content.match(/Title:\s*([A-Za-z0-9!"?`?|äõüö’–_—žčâèçëıÅĂôà=ÚíšÃÉÁÇÃáéñãóú#&; 
    ()-,'@./\s\-]+)(\r?\n)/);
    var title = (tmp && tmp[1]) ? tmp[1].trim() : 'BLANK';
  
    tmp = content.match(/Organization:\s*([A-Za-z0-9!"?`?|äõüö’–_—žčâèçëıÅĂôà=ÚíšÃÉÁÇÃáéñãóú#&; 
    ()-,'@./\s\-]+)(\r?\n)/);
    var organization = (tmp && tmp[1]) ? tmp[1].trim() : 'BLANK';
  
    tmp = content.match(/City:\s*([A-Za-z0-9!"?`?|äõüö’–_—žčâèçëıÅĂôà=ÚíšÃÉÁÇÃáéñãóú#&; 
    ()-,'@./\s\-]+)(\r?\n)/);
    var city = (tmp && tmp[1]) ? tmp[1].trim() : 'BLANK';
   
    tmp = content.match(/State:\s*([A-Za-z0-9!"?`?|äõüö’–_—žčâèçëıÅĂôà=ÚíšÃÉÁÇÃáéñãóú#&; 
    ()-,'@./\s\-]+)(\r?\n)/);
    var state = (tmp && tmp[1]) ? tmp[1].trim() : 'BLANK';
  
    tmp = content.match(/Country:\s*([A-Za-z0-9!"?`?|äõüö’–_—žčâèçëıÅĂôà=ÚíšÃÉÁÇÃáéñãóú#&; 
    ()-,'@./\s\-]+)(\r?\n)/);
    var country = (tmp && tmp[1]) ? tmp[1].trim() : 'BLANK';
  
    tmp = content.match(/E-mail:\s*([A-Za-z0-9!"?`?|äõüö’–_—žčâèçëıÅĂôà=ÚíšÃÉÁÇÃáéñãóú#&; 
    ()-,'@_.\-]+)/);
    var email = (tmp && tmp[1]) ? tmp[1].trim() : 'BLANK';

    tmp = content.match(/BLANK:\s*([\s\S]+)/);
    var blank = (tmp && tmp[1]) ? tmp[1] : 'BLANK';

    sheet.appendRow([first, last, title, organization, city, state, country, email]);

    } // End if

    } // End for loop
    }