dcorto · February 11, 2021 21:21 · Feb 11, 2021 · Jul 31, 2017 · Jul 31, 2017 · Jan 21, 2016
diff --git a/README.md b/README.md
@@ -7,8 +7,9 @@ Automatically deletes old emails that match the specified label.
 - Create a new Google Apps Script at [https://script.google.com](https://script.google.com)
 - Overwrite the placeholder with the javascript below
 - Update the following constants:
-  - `LABEL_TO_DELETE`: the label that should be have old messages deleted
+  - `LABELS_TO_DELETE`: the label that should be have old messages deleted
   - `DELETE_AFTER_DAYS`: the age of messsages after which they will be moved to trash
+  - `TIMEZONE`: list of valid timezones http://joda-time.sourceforge.net/timezones.html
 - Save the script, then run:
   - `Initialize`
   - `Install`
@@ -17,6 +18,10 @@ If you ever want to remove the script, run `Uninstall` to remove any left over t
 
 ## Changelog
 
+### 2020-02-11
+- Explicit TIMEZONE on triggers with 'after' N miliseconds
+- Improved this README.md
+
 ### 2017-07-31
 
 - Added support for multiple labels

diff --git a/delete-by-label.js b/delete-by-label.js
@@ -8,9 +8,9 @@ var LABELS_TO_DELETE = [
 var TRIGGER_NAME = "dailyDeleteGmail";
 
 // Purge messages in the above label automatically after how many days?
-var DELETE_AFTER_DAYS = "4";
+var DELETE_AFTER_DAYS = "30";
 
-var TIMEZONE = "AEST";
+var TIMEZONE = "Europe/Madrid";
 
 // Maximum number of threads to process per run
 var PAGE_SIZE = 150;
@@ -32,7 +32,8 @@ function Install() {
   // First run 2 mins after install
   ScriptApp.newTrigger(TRIGGER_NAME)
            .timeBased()
-           .at(new Date((new Date()).getTime() + 1000*60*2))
+           .after(2 * 60 * 1000)
+           .inTimezone(TIMEZONE)
            .create();
 
   // Run daily there after
@@ -69,7 +70,8 @@ function dailyDeleteGmail() {
       Logger.log("Scheduling follow up job...");
       ScriptApp.newTrigger(TRIGGER_NAME)
                .timeBased()
-               .at(new Date((new Date()).getTime() + 1000*60*RESUME_FREQUENCY))
+               .after(RESUME_FREQUENCY * 60 * 1000)
+               .inTimezone(TIMEZONE)
                .create();
     }
 
@@ -91,6 +93,8 @@ function dailyDeleteGmail() {
       }
     }
 
-  } catch (e) {}
+  } catch (e) {    
+    Logger.log('dailyDeleteGmail() error:' + e)
+  }
 
 }
diff --git a/README.md b/README.md
@@ -17,6 +17,15 @@ If you ever want to remove the script, run `Uninstall` to remove any left over t
 
 ## Changelog
 
+### 2017-07-31
+
+- Added support for multiple labels
+- Added configurable `TRIGGER_NAME`
+- Increased default page size
+- Decreased default delay between receipt and delete
+
+### 2016-01-21
+
 - Removed use of deprecated `Session.getTimeZone()`
 - Improved efficiency for long threads by checking `thread.getLastMessageDate()`
 

diff --git a/delete-by-label.js b/delete-by-label.js
@@ -1,13 +1,19 @@
 // The name of the Gmail Label that is to be checked for purging?
-var LABEL_TO_DELETE = "direct-dev";    
+var LABELS_TO_DELETE = [
+  "notifications-github",
+  "notifications-trello",
+  "notifications-hipchat"
+];
+
+var TRIGGER_NAME = "dailyDeleteGmail";
 
 // Purge messages in the above label automatically after how many days?
-var DELETE_AFTER_DAYS = "30";
+var DELETE_AFTER_DAYS = "4";
 
 var TIMEZONE = "AEST";
 
 // Maximum number of threads to process per run
-var PAGE_SIZE = 100;
+var PAGE_SIZE = 150;
 
 // If number of threads exceeds page size, resume job after X mins (max execution time is 6 mins)
 var RESUME_FREQUENCY = 10;
@@ -24,13 +30,13 @@ function Intialize() {
 function Install() {
 
   // First run 2 mins after install
-  ScriptApp.newTrigger("deleteGmail")
+  ScriptApp.newTrigger(TRIGGER_NAME)
            .timeBased()
            .at(new Date((new Date()).getTime() + 1000*60*2))
            .create();
 
   // Run daily there after
-  ScriptApp.newTrigger("deleteGmail")
+  ScriptApp.newTrigger(TRIGGER_NAME)
            .timeBased().everyDays(1).create();
 
 }
@@ -44,13 +50,13 @@ function Uninstall() {
 
 }
 
-function deleteGmail() {
+function dailyDeleteGmail() {
 
   var age = new Date();  
   age.setDate(age.getDate() - DELETE_AFTER_DAYS);    
 
   var purge  = Utilities.formatDate(age, TIMEZONE, "yyyy-MM-dd");
-  var search = "label:" + LABEL_TO_DELETE + " before:" + purge;
+  var search = "(label:" + LABELS_TO_DELETE.join(" OR label:") + ") before:" + purge;
   Logger.log("PURGE: " + purge);
   Logger.log("SEARCH: " + search);
 
@@ -61,7 +67,7 @@ function deleteGmail() {
     // Resume again in 10 minutes
     if (threads.length == PAGE_SIZE) {
       Logger.log("Scheduling follow up job...");
-      ScriptApp.newTrigger("deleteGmail")
+      ScriptApp.newTrigger(TRIGGER_NAME)
                .timeBased()
                .at(new Date((new Date()).getTime() + 1000*60*RESUME_FREQUENCY))
                .create();

diff --git a/README.md b/README.md
@@ -22,4 +22,4 @@ If you ever want to remove the script, run `Uninstall` to remove any left over t
 
 ## Acknowledgements
 
-Script orginally based on Arun's post [How to Auto Delete Old Emails In Any Gmail Label](http://www.skipser.com/p/2/p/auto-delete-email-in-any-gmail-label-.html)
+H/T: Arun's post [How to Auto Delete Old Emails In Any Gmail Label](http://www.skipser.com/p/2/p/auto-delete-email-in-any-gmail-label-.html)
diff --git a/README.md b/README.md
@@ -14,3 +14,12 @@ Automatically deletes old emails that match the specified label.
   - `Install`
 
 If you ever want to remove the script, run `Uninstall` to remove any left over triggers.
+
+## Changelog
+
+- Removed use of deprecated `Session.getTimeZone()`
+- Improved efficiency for long threads by checking `thread.getLastMessageDate()`
+
+## Acknowledgements
+
+Script orginally based on Arun's post [How to Auto Delete Old Emails In Any Gmail Label](http://www.skipser.com/p/2/p/auto-delete-email-in-any-gmail-label-.html)
diff --git a/README.md b/README.md
@@ -5,4 +5,12 @@ Automatically deletes old emails that match the specified label.
 ## Get started
 
 - Create a new Google Apps Script at [https://script.google.com](https://script.google.com)
-- Replace the empty script with the javascript below
+- Overwrite the placeholder with the javascript below
+- Update the following constants:
+  - `LABEL_TO_DELETE`: the label that should be have old messages deleted
+  - `DELETE_AFTER_DAYS`: the age of messsages after which they will be moved to trash
+- Save the script, then run:
+  - `Initialize`
+  - `Install`
+
+If you ever want to remove the script, run `Uninstall` to remove any left over triggers.
diff --git a/README.md b/README.md
@@ -0,0 +1,8 @@
+# Gmail: delete old emails automatically
+
+Automatically deletes old emails that match the specified label.
+
+## Get started
+
+- Create a new Google Apps Script at [https://script.google.com](https://script.google.com)
+- Replace the empty script with the javascript below
diff --git a/delete-by-label.js b/delete-by-label.js
@@ -0,0 +1,90 @@
+// The name of the Gmail Label that is to be checked for purging?
+var LABEL_TO_DELETE = "direct-dev";    
+
+// Purge messages in the above label automatically after how many days?
+var DELETE_AFTER_DAYS = "30";
+
+var TIMEZONE = "AEST";
+
+// Maximum number of threads to process per run
+var PAGE_SIZE = 100;
+
+// If number of threads exceeds page size, resume job after X mins (max execution time is 6 mins)
+var RESUME_FREQUENCY = 10;
+
+/*
+
+IMPLEMENTATION
+
+*/
+function Intialize() {
+  return;
+}
+
+function Install() {
+
+  // First run 2 mins after install
+  ScriptApp.newTrigger("deleteGmail")
+           .timeBased()
+           .at(new Date((new Date()).getTime() + 1000*60*2))
+           .create();
+
+  // Run daily there after
+  ScriptApp.newTrigger("deleteGmail")
+           .timeBased().everyDays(1).create();
+
+}
+
+function Uninstall() {
+
+  var triggers = ScriptApp.getProjectTriggers();
+  for (var i=0; i<triggers.length; i++) {
+    ScriptApp.deleteTrigger(triggers[i]);
+  }
+
+}
+
+function deleteGmail() {
+
+  var age = new Date();  
+  age.setDate(age.getDate() - DELETE_AFTER_DAYS);    
+
+  var purge  = Utilities.formatDate(age, TIMEZONE, "yyyy-MM-dd");
+  var search = "label:" + LABEL_TO_DELETE + " before:" + purge;
+  Logger.log("PURGE: " + purge);
+  Logger.log("SEARCH: " + search);
+
+  try {
+
+    var threads = GmailApp.search(search, 0, PAGE_SIZE);
+
+    // Resume again in 10 minutes
+    if (threads.length == PAGE_SIZE) {
+      Logger.log("Scheduling follow up job...");
+      ScriptApp.newTrigger("deleteGmail")
+               .timeBased()
+               .at(new Date((new Date()).getTime() + 1000*60*RESUME_FREQUENCY))
+               .create();
+    }
+
+    // Move threads/messages which meet age criteria to trash
+    Logger.log("Processing " + threads.length + " threads...");
+    for (var i=0; i<threads.length; i++) {
+      var thread = threads[i];
+
+      if (thread.getLastMessageDate() < age) {
+        thread.moveToTrash();
+      } else {
+        var messages = GmailApp.getMessagesForThread(threads[i]);
+        for (var j=0; j<messages.length; j++) {
+          var email = messages[j];       
+          if (email.getDate() < age) {
+            email.moveToTrash();
+          }
+        }
+      }
+    }
+
+  } catch (e) {}
+
+}