Gmail – Google Apps Script to automatically send email

gmailgoogle-apps-script

I am trying to create a Google Apps Script that will send an email to our client's general inbox when we receive an email from one of their representatives containing an order. We are required by our contract to provide a receipt of order to a different team on the client side than the team that does the ordering.

I want the script to run every five minutes, and to take all of the new emails that have come in from a specific domain (let's call it @client.com) and forward those emails to a general inbox (let's call it geninbox@client.com).

I have the following script compiled, but as I am very, very new to this and have barely a cursory understanding, I have no idea why it does not work. Any help would be greatly appreciated.

function CLIENTreceipt() {

   var interval = 5; 
   var date = new Date();
   var timeFrom = Math.floor(date.valueOf()/1000) - 60 * interval;
   var threads = GmailApp.search(' from: @client.com is:inbox after:' + timeFrom);
   var msg = "";
   var subject = "";
   var attachment = "";
   for (var i = 0; i < threads.length; i++) {
      t = threads[i];
      c = t.getMessageCount() - 1;
      msg = t.getMessages()[c];
      subject = msg.getSubject();
      attachment = msg.getAttachments();
      msg.forward("geninbox@client.com", {
        subject: "The Following order has Been Received: [" + subject + "]",
        htmlBody: "Thank you!<br><br>"
        +
        "This message is confirm receipt of your order. Your order has been forwarded to our service team.<br><br>",
        attachments: attachment
    });
    t.markRead();
  }
}

Best Answer

It's very likely that the problem is timeFrom is not a string with YYYY/MM/dd format, but instead it's an integer.

To get the string in the required format use Utilities.formatDate()

Reference

Search operators that you can use with Gmail

Related Solutions

Google-apps-script – Automatically create a calendar document using Google Drive and Google Apps Script

Yes, it's possible.

On way is to place text markers as it's done on mail merge scripts.
Another way is to create the table programmatically by using Class Table

Gmail – Can You Conditionally Format Emails?

I now have a workaround that solves my particular use case. However, it does not address the overall question of conditionally formatting Gmail. As far as I can tell, there is no direct means to do that without editing the source code for the page and that stuff is a mess. I presume an addon could do it but it's way beyond my scope of knowledge.

In order to achieve the effect I wanted, I followed these steps:

Setup a label in Gmail called "Mgt" and color it gray.
- The text makes it a tiny label and the color makes it inconspicuous.
- Its purpose is so I can keep track of all management emails whether they're read or not.
- It looks like this:
Set Gmail Filters to automatically apply the label to all emails from certain people.
Setup a label in Gmail called "♒♒ Management Unread ♒♒" and color it red.
- The long text makes it a large label and the color makes it conspicuous.
- If the text is too long, it is truncated. This length was the max (on my system, at least).
- The squiggly lines are U+2652 Aquarius, chosen purely on appearance.
- Its purpose is to make the unread email from management "pop" visually.
- It looks like this:
Write Google Apps Script that searches my Gmail
- The script is saved on Drive for the same account that's using Gmail
- It performs the following two actions:
  1. Find all unread messages in and add the label .
  2. Find all read messages in and remove that label.
- The code is:

function addRemoveManagementLabelsInGmail() {

  // These labels MUST be setup in Gmail before running this script
  var basicLabelName = 'Mgt';
  var unreadLabelName = '♒♒ MANAGEMENT UNREAD ♒♒';

  // Get the label object
  var unreadLabel = GmailApp.getUserLabelByName(unreadLabelName);

  // Add the label to unread messages
  // You can't change more than 100 labels at a time so, if there are that many, we use the slower method
  var unreadThreads = GmailApp.search('label:' + basicLabelName + ' is:unread');
  if (unreadThreads.length < 100) {
    unreadLabel.addToThreads(unreadThreads);
  } else {
    for (i=0; i<unreadThreads.length; i++) {
      unreadThreads[i].addLabel(unreadLabel);
    } 
  }

  // Remove the label from read messages
  // You can't change more than 100 labels at a time so, if there are that many, we use the slower method
  var readThreads = GmailApp.search('label:' + unreadLabelName + ' is:read');
  if (readThreads.length < 100) {
    unreadLabel.removeFromThreads(readThreads);
  } else {
    for (i=0; i<readThreads.length; i++) {
      readThreads[i].removeLabel(unreadLabel);
    } 
  }

};

Setup an installable trigger on that script so that it runs once a minute.
- Edit menu > Current Project's Triggers
- I set these settings.

This is not a perfect system but it does create an obvious visual for me and has, thus far, been effective. My original attempt was just a long "MANAGEMENT" label on all of them but I quickly fatigued since the read messages had just as much apparent importance as the read messages.

Related Topic