Google Apps Script – Label Email Based On Email Body [Optimize Code]

by

One method of improving performance in nested loop situations – especially duplicate identification – is to store a record of traversed content, rather than repeatedly comparing. For example, you could hash the message body (given the right hash function) and store the hashes as object properties. Note that there is no formal limit on the length of an object property so you may be able to skip hashing it yourself (to obtain a fixed length property) and just let Google Apps Script do it for you. It’s probably wise to test how large a message can be before using such an assumption in production, naturally.

function updateEmailLabels() {
  // Use an Object to associate a message's plaintext body with the
  // associated thread/message IDs (or other data as desired).
  var seenBodies = {}, // When a message is read, its plaintext body is stored.
      DUPLICATE = _getLabel("SO_Duplicates"),
      ORIGINAL = _getLabel("SO_Original");

  // getThreads() returns newest first. Start with the oldest by reversing it.
  ORIGINAL.getThreads().reverse().forEach(function (thread) {
    thread.getMessages().forEach(function (message, messageIndex) {
      // Use this message's body for fast lookups.
      // Assumption: Apps Script has no reachable limit on Object property length.
      var body = message.getPlainBody();

      // Compare this message to all previously seen messages:
      if (!seenBodies[body]) {
        seenBodies[body] = {
          count: 1,
          msgIndices: [ messageIndex ],
          threads: [ thread ],
          threadIds: [ thread.getId() ]
        };
      } else {
        // This exact message body has been observed previously.
        // Update information about where the body has been seen (or perform
        // more intricate checks, i.e. compare threadIds and message indices,
        // before treating this thread and message as a duplicate).
        seenBodies[body].count += 1;
        seenBodies[body].msgIndices.push(messageIndex);
        seenBodies[body].threads.push(thread);
        seenBodies[body].threadIds.push(thread.getId());
      }
    }); // End for-each-message. 
  }); // End for-each-thread.

  // All messages in all threads have now been read and checked against each other.
  // Determine the unique threads to be modified.
  var threadsToChange = {};
  for (var body in seenBodies) {
    if (seenBodies[body].count === 1)
      continue;
    var data = seenBodies[body];
    for (var threadIndex = 1; threadIndex < data.threads.length; ++threadIndex)
      threadsToChange[data.threadIds[threadIndex]] = data.threads[threadIndex];
  }
  // Update their labels and archive status.
  for (var id in threadsToChange) {
    var thread = threadsToChange[id];
    DUPLICATE.addToThread(thread);
    ORIGINAL.removeFromThread(thread);
    GmailApp.moveThreadToArchive(thread);
  }
}

function _getLabel(labelText) {
  var label = GmailApp.getUserLabelByName(labelText);
  return label ? label : GmailApp.createLabel(labelText);
}

You’ll definitely want to tweak the duplicate detection bits, since I don’t exactly have qualifying emails just laying around 😉 I suspect what I’ve written will classify a thread as duplicate if at least 2 messages are the same, even if that thread is the only thread with that particular message body.

More Related Contents:

  1. How many times does a (for) loop iterate? [closed]
  2. Difference between pre-increment and post-increment in a loop?
  3. Is it a bad practice to use break in a for loop? [closed]
  4. Using Pointers in a for loop
  5. What does it mean to pass in a vector into a `for` loop versus a reference to a vector?
  6. What is the pythonic way to detect the last element in a ‘for’ loop?
  7. Register multiple routes using range for loop slices/map
  8. How to make a reverse ordered for loop?
  9. How to use the Gmail API, OAuth2 for Apps Script, and Domain-Wide Delegation to set email signatures for users in a G Suite domain
  10. Batch script for loop won’t set variable
  11. Print a triangular pattern of asterisks
  12. GmailApp – Add label to specific message, not the thread
  13. How to loop through array in batch?
  14. What is the difference between pairs() and ipairs() in Lua?
  15. How can I do a mutable borrow in a for loop?
  16. Captured Closure (for Loop Variable) in Go
  17. How to print out the letters of a word, one on each line, with three asterisks before and after the word
  18. Where does GOTO :EOF return to?
  19. Java for loop syntax: “for (T obj : objects)”
  20. Function with varying number of For Loops (python)
  21. Apps Script: how to get hyperlink from a cell where there is no formula
  22. Create a post in Blogger with Google Apps Script
  23. Google Apps Script date format issue (Utilities.formatDate)
  24. Why do I get an IndexError (or TypeError, or just wrong results) from “ar[i]” inside “for i in ar”?
  25. How to Populate HTML Service Select Options from Range in Google Sheet?
  26. How do I search Google Spreadsheets?
  27. What does “[Ljava.lang.Object;@” mean?
  28. Google Sheet use Importxml error could not fetch url [duplicate]
  29. Determine current user in Apps Script
  30. inject external javascript file in google app script(Google Docs) [closed]

Leave a Comment