Mail forwarding based on mail Subject

Beginner Questions
1

Hi there,

I’m new to Make.com and I’m facing a challenge.

I’ve created a flow that allows me to forward emails based on their subject lines.

A Google Sheets spreadsheet contains several subject lines. If the subject line of an incoming email matches a rule in the Sheet (filter), the email is forwarded to an email address associated with it.

This works perfectly until a reply email arrives.

Then, a “Re:” is added to the subject line, and the subject line no longer matches the list in Google Sheets.

Can anyone help me? I think I need to configure the filter differently, but I can’t find a function that matches the subject line without a “Re:” to the subject lines in the Sheet.

3

Welcome to the Make community!

To do this, you can use the built-in function:

  • replace
    replace(text; search string; replacement string)

This function may have also been covered in the Make Academy tutorials — refer to the Make Academy Course Overview to learn more.

Here’s an example of how you can use this function:

{{ replace(1.subject; "Re: "; emptystring) }}
(copy-paste the above into the field, or type it exactly as shown)

Hope this helps! Let me know if there are any further questions or issues.

— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!

4

Hi @samliew , thanks for helping me out!

It took me a while to “translate” the function it the predefined Text Parser, but finally it works.

Note: I had to replace the search field (filter) for the spreadsheet loopup to the “Text” parser field, otherwise the lookup in the spreadsheet did not work (with the origional “Subject” field)

Thnx! Anton

2 Likes