Tracking email RESPONDED status using apps script

[Darren D'Mello]

I wanted to track a email RESPONDED status, is that possible?

The email OPENED status is straightforward by introducing a web beacon 1x1 gif. 

How about the tracking whether the email is RESPONDED?

[Mario Rossi]

Tracking Email Opens with Gmail, Sheets, and Apps Script | by Lee-on Pedahzur | The Startup | Medium

Sender notified by Mailtrack 06/02/21, 17:48:31

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/e0c2f501-a7ac-4893-9595-99f5eca4472cn%40googlegroups.com.

[Brian Pugh]

Yet Another Mail Merge (YAMM) is widely used and excellent. Will probably do all you need it to do.

[Darren D'Mello]

Thanks Brian,

Mr. Mario Rossi, for your kind information the link shared by you is of no use to me, since I specifically intend to track an email with the RESPONDED status and not OPEN status. I have seen plenty of resources online with explanations of tracking an email Open status but not "responded" status.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAJBn2DTs3DFGx5TJ4koNKQ214P44ehn9yycOiBfkdrcjM-oa9g%40mail.gmail.com.

[Faustino Rodriguez]

What is the type of question you want an answer to?

Like for example,

- emails I sent in the last 7 days that have not been responded?

- or emails already responded with how many messages in the conversation, etc?
- or something else?

[Darren D'Mello]

Thanks Fausto. 

What I wish is, When A sends an email to B from spreadsheet, the status will be EMAIL_SENT

B when opens the email the status in A 's spreadsheet will be EMAIL_OPENED

When B forwards or he replies to A OR when B forwards to C or B replies A,C then the status in A 's spreadsheet turns as EMAIL_RESPONDED

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/c3d60c91-c10a-4112-ae41-e28e9131baecn%40googlegroups.com.

--

Best,

Darren

[Romain Vialard]

The only solution is to watch the mailbox of your user (A) and check, when new emails are received, if they are responses to emails sent with your mail merge tool.

This means you need full read access on the user mailbox, and thus you need to pay for a security assessment.

https://developers.google.com/gmail/api/auth/scopes

[Faustino Rodriguez]

I see no other ways than Romain explained

I believe, you can avoid the security assessment if the script that watches for responses is owned by user A (like embedded in the merging spreadsheet)

[iBO • App Service]

This might be an option: https://dev.to/ravsamhq/how-to-track-email-opens-with-google-apps-script-2lah