Thread ID/ Original Message id of a list of replies in emails

[Zach]

What is your goal?

My goal,
If an email comes through with no attachments, log and autoreply chasing attachments. if replied to my auto reply with attachments, log and autoreply confirming attachments have received. If further reply, do not log or reply.
If an email comes through with attachments, log and auto reply confirming they have been processed, if a reply comes through, do not auto reply or log.
I would rather not turn to a Gmail module using a threadID as not all emails coming through will be processed through Gmail.

What is the problem & what have you tried?

When logging emails (other user only), i can not find a way to keep the original thread ID / Message ID, i am not greatly knowledgeable with all functions however i have tried several suggestions while using ChatGpt to help me. I have spent absolute hours just trying to figure out how to find the original ID of the email that was first if a couple of email replies are inbetween.
Ps. new to this whole community so any guidance and direction about anything wouldn’t be disappointing.

Create public scenario page

Integration Email, OpenAI (ChatGPT, Sora - Make.com Automation Scenario

Screenshots (scenario flow, module settings, errors)

[damato]

Hi @Zach. Welcome to the Make community.

When someone replies to your message, their email client generally includes the Message-ID of the original email in the In-Reply-To or References headers.

Get the In-Reply-To or the first item in the References array and check it against your database of sent emails.

Then route the scenario according to your requirements (attachments/replies).

When using the Email > Send an Email module to reply, map the incoming Message-ID into the In-Reply-To field of the outgoing mail. This ensures the user’s mail client groups your response correctly.

I also suggest you use a data store instead of a Google sheet.

@damato

[Zach]

Wonderful, took a few tries but absolutely wonderful, thank you very much. About data store, is it just a more improved system?

[damato]

I’m glad it helped.

The Data Store is a proper database inside make, suitable for simple data models. Spreadsheets are good for calculations using formulas and are way slower.