Selective Mail Forwarding | Google Developer Community | Page 1

cursive jay Sep 23, 2024, 2:21 PM

#

Detailed steps listed below

#

Go to all settings in your mail

#

This in the top right

#

then this thing

#

In this ribbon you should see the "Forwarding and POP/IMAP" section

#

Under that you have the first option as \

#

under that you should have a creating a filter option

#

so create the filter you should get this

#

Leave things blank that doesnt matter

#

you can list all of the emails you want to forward to under "TO" and the specific email adress you want to recieve messages from.

#

I however would add some keywords just in case you want to avoid specific details being forwarded

barren thorn Oct 2, 2024, 4:13 AM

#

Thanks for your help!

#

Hmm...I'm not sure how this would work with the emails I get. I'll show you an example

#

#

You can see here that this email is sent to the student, and I get a copy of it sent directly to me as well. In this example, the student's email is: aaron.refreshwaterco@gmail.com

#

So I have to manually forward this email to that email address.

#

That email address will change every time, since it's sent to different people. But the format of the email will remain identical

#

So I wanted something that automates this process of forwarding the email address that's found on that first line of the email

#

#

Here is another example

#

@cursive jay

cursive jay Oct 2, 2024, 3:17 PM

#

yup im here!

#

sorry I was on Robotics for the time

barren thorn Oct 3, 2024, 4:24 AM

#

No problem

#

I just got home lol

#

did you see the examples I pasted?

cursive jay Oct 3, 2024, 4:26 AM

#

Yeah

#

Ive been so god damn busy i havent replied

cursive jay Oct 3, 2024, 4:28 AM

#

cursive jay so create the filter you should get this

Try to find a common word specific to these mails

#

And then add then in the list

barren thorn Oct 3, 2024, 5:29 AM

#

ok, that part is easy. But how do I get it to forward to the email address in each email?

cursive jay Oct 3, 2024, 5:03 PM

#

barren thorn ok, that part is easy. But how do I get it to forward to the email address in ea...

Yeah the field To:

#

You list the emails there

barren thorn Oct 4, 2024, 4:13 AM

#

Yeah, but how do I pull the correct email address from the body of the email and set it to the To field?

cursive jay Oct 4, 2024, 6:11 AM

#

barren thorn Yeah, but how do I pull the correct email address from the body of the email and...

Oh I see you want to send it to a mail SPECIFIC in the mail

#

Oh ok

#

then its more complex

#

hm

#

Let me think about it for a minute or two

barren thorn Oct 4, 2024, 6:11 AM

#

Yeah I want to forward each email to the email address listed in the email.

#

Thanks

cursive jay Oct 4, 2024, 6:11 AM

#

Ill come back to you

#

Ok most likely you will have to create a Google Script

#

if that is fine with you

barren thorn Oct 4, 2024, 6:14 AM

#

Yeah that seems ok

cursive jay Oct 4, 2024, 6:15 AM

#

mk

barren thorn Oct 4, 2024, 6:15 AM

#

I've never used Google script though. Is it hard?

cursive jay Oct 4, 2024, 6:16 AM

#

It might be a little overwhelming

barren thorn Oct 4, 2024, 6:16 AM

#

Lovely

cursive jay Oct 4, 2024, 6:16 AM

#

Of course Ill help you

barren thorn Oct 4, 2024, 6:16 AM

#

Nice thanks 😄

cursive jay Oct 4, 2024, 6:16 AM

#

Are the emails labeled?

barren thorn Oct 4, 2024, 6:16 AM

#

Yes

#

You can see it in the examples I showed

cursive jay Oct 4, 2024, 6:16 AM

#

I believe its labelled only for that sort of email right

#

can you create a custom label just for the ones to be forwarded?

barren thorn Oct 4, 2024, 6:17 AM

#

Classroom/Access Email

ALL of these emails I want forwarded to the people its sent to.

cursive jay Oct 4, 2024, 6:17 AM

#

I see

#

mk

#

no issues

#

I also believe its auto labeled?

barren thorn Oct 4, 2024, 6:18 AM

#

Yep

cursive jay Oct 4, 2024, 6:18 AM

#

Sick

barren thorn Oct 4, 2024, 6:18 AM

#

And auto sorted into the folder

#

I keep my work email organized

#

All regular emails are sorted into labels and their respective folder.

cursive jay Oct 4, 2024, 6:19 AM

#

real nice

#

Could you do me a favour if youre fine with it, for all the mails forwarded, could you give all of them a form of "Sent" or "Forwarded" Label? that makes it easier for the code

#

it makes the process much much faster too

barren thorn Oct 4, 2024, 6:21 AM

#

So just an extra label called "Forwarded"?

cursive jay Oct 4, 2024, 6:21 AM

#

barren thorn So just an extra label called "Forwarded"?

Yeah pretty much

#

just the ones you have sent out already

barren thorn Oct 4, 2024, 6:21 AM

#

Yeah I can do that

cursive jay Oct 4, 2024, 6:21 AM

#

it makes life easier for the code so it doesnt take it hours to search

#

Yeah thanks

barren thorn Oct 4, 2024, 6:23 AM

#

I'll do that in the morning since I'm in bed now and it's almost 12:30 am 😂 I gotta wake up at 5 am

cursive jay Oct 4, 2024, 6:23 AM

#

Ah ok

#

take rest

barren thorn Oct 4, 2024, 6:23 AM

#

Thanks for your help. Night!

cursive jay Oct 4, 2024, 6:23 AM

#

Ill get your code done with

#

Classroom/Access Email

this is the label I should look forward too right?

#

to*

#

This should be it!

#

function checkNewEmails() {
  var label = GmailApp.getUserLabelByName("Classroom/Access Email");  // Label before forwarding
  var forwardedLabel = GmailApp.getUserLabelByName("Forwarded");  // Label after forwarding
  var threads = label.getThreads(0, 10);  // Get the 10 most recent threads with the "Classroom/Access Email" label
  
  threads.forEach(function(thread) {
    var messages = thread.getMessages();
    
    messages.forEach(function(message) {
      if (!message.isInLabel(forwardedLabel)) {  // Only process emails without the "Forwarded" label
        var body = message.getBody();  // Get the email body
        
        // Regex to find the first email in the body
        var emailMatch = body.match(/[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}/);
        
        if (emailMatch) {
          var recipientEmail = emailMatch[0];  // Extract the first email found
          
          // Forward the email to the recipient found
          GmailApp.sendEmail(recipientEmail, message.getSubject(), message.getBody(), {
            attachments: message.getAttachments()  // Forward any attachments
          });

          // Add the "Forwarded" label after forwarding
          message.addLabel(forwardedLabel);
        }
      }
    });
  });
}

#

ill let you know how to set it up

#

once your up ofc

cursive jay Oct 4, 2024, 3:50 PM

#

Ok looking back at my code it just rewitres the email and does not forward it let me try to get an actual forward system

#

I made it much more complex there for no reason

#

function checkNewEmails() {
  var label = GmailApp.getUserLabelByName("Classroom/Access Email");  // Label before forwarding
  var forwardedLabel = GmailApp.getUserLabelByName("Forwarded");  // Label after forwarding
  var threads = label.getThreads(0, 10);  // Get the 10 most recent threads with the "Classroom/Access Email" label
  
  threads.forEach(function(thread) {
    var messages = thread.getMessages();
    
    messages.forEach(function(message) {
      if (!message.isInLabel(forwardedLabel)) {  // Only process emails without the "Forwarded" label
        var body = message.getBody();  // Get the email body
        
        // Regex to find the first email in the body
        var emailMatch = body.match(/[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}/);
        
        if (emailMatch) {
          var recipientEmail = emailMatch[0];  // Extract the first email found
          
          // Forward the email to the recipient found
          message.forward(recipientEmail);
          
          // Add the "Forwarded" label after forwarding
          message.addLabel(forwardedLabel);
        }
      }
    });
  });
}

#

this should be MUCH easier

barren thorn Oct 5, 2024, 4:45 AM

#

Nice, thanks!

#

I've created the new label

#

#

I've added it to all of the emails in the Access Email folder

#

Is it possible to add in "Please see below" as text for the email that is forwarded to them? Like what I do:

#

cursive jay Oct 5, 2024, 5:30 AM

#

Hm

#

I think you can send another email in the same thread

#

I cant much today though i have a quick exam tonight so gotta study

#

Ill look into it

barren thorn Oct 6, 2024, 6:42 PM

#

Thanks

cursive jay Oct 10, 2024, 5:18 AM

#

Yo so sorry ive been inactive

#

My exams were going on

#

Yeah ill get them done

barren thorn Oct 12, 2024, 3:55 AM

#

Sorry, I forgot to check this lol

cursive jay Oct 17, 2024, 4:51 PM

#

Im trying to get my exams done with

#

DAMN

barren thorn Oct 19, 2024, 5:53 PM

#

Nice

#

What exams are they?

cursive jay Oct 21, 2024, 12:12 PM

#

My exams just ended

cursive jay Oct 21, 2024, 12:12 PM

#

barren thorn What exams are they?

Terminals

#

They suck

barren thorn Oct 22, 2024, 5:25 AM

#

Are you in computer science?

cursive jay Oct 29, 2024, 7:10 AM

#

Yeah

#

So many exams

#

Its ho estly frustrating

#

Ends next week though

cursive jay Nov 3, 2024, 4:05 AM

#

Im finally free

cursive jay Nov 4, 2024, 1:47 PM

#

lets get through your things now

#

function checkNewEmails() {
  var label = GmailApp.getUserLabelByName("Classroom/Access Email");  // Label before forwarding
  var forwardedLabel = GmailApp.getUserLabelByName("Classroom/Access Email/Forwarded");  // Label after forwarding
  var threads = label.getThreads(0, 10);  // Get the 10 most recent threads with the "Classroom/Access Email" label
  
  threads.forEach(function(thread) {
    var messages = thread.getMessages();
    
    messages.forEach(function(message) {
      if (!message.isInLabel(forwardedLabel)) {  // Only process emails without the "Forwarded" label
        var body = message.getBody();  // Get the email body
        
        // Regex to find the first email in the body
        var emailMatch = body.match(/[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}/);
        
        if (emailMatch) {
          var recipientEmail = emailMatch[0];  // Extract the first email found
          
          // Forward the email to the recipient found
          message.forward(recipientEmail);
          
          // Add the "Forwarded" label after forwarding
          message.addLabel(forwardedLabel);
        }
      }
    });
  });
}

this is the final code i believe

#

function checkNewEmails() {
  var label = GmailApp.getUserLabelByName("Classroom/Access Email");  // Label before forwarding
  var forwardedLabel = GmailApp.getUserLabelByName("Classroom/Access Email/Forwarded");  // Label after forwarding
  var threads = label.getThreads(0, 10);  // Get the 10 most recent threads with the "Classroom/Access Email" label
  
  threads.forEach(function(thread) {
    var messages = thread.getMessages();
    
    messages.forEach(function(message) {
      if (!message.isInLabel(forwardedLabel)) {  // Only process emails without the "Forwarded" label
        var body = message.getBody();  // Get the email body
        
        // Regex to find the first email in the body
        var emailMatch = body.match(/[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}/);
        
        if (emailMatch) {
          var recipientEmail = emailMatch[0];  // Extract the first email found
          
          // Forward the email to the recipient found
          message.forward(recipientEmail);
          
          // Send a follow-up message in the same thread
          thread.reply("Please see below \n\nRegards,\n\nCDS Admin");
          
          // Add the "Forwarded" label after forwarding
          message.addLabel(forwardedLabel);
        }
      }
    });
  });
}

#

This should be it

#

@barren thorn Could you confirm if this does what you need?

barren thorn Nov 4, 2024, 2:12 PM

#

Thanks, so where do I enter all of that?

cursive jay Nov 5, 2024, 1:31 AM

#

In google scripts

#

You can create a new project there and just add it in

barren thorn Nov 6, 2024, 3:27 PM

#

Ok I'll check

#Selective Mail Forwarding