Tracking email RESPONDED status using apps script

82 views
Skip to first unread message

Darren D'Mello

unread,
Feb 6, 2021, 9:17:23 AMFeb 6
to Google Apps Script Community
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

unread,
Feb 6, 2021, 11:48:49 AMFeb 6
to google-apps-sc...@googlegroups.com
--
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

unread,
Feb 6, 2021, 3:54:30 PMFeb 6
to google-apps-sc...@googlegroups.com
Yet Another Mail Merge (YAMM) is widely used and excellent. Will probably do all you need it to do.

Darren D'Mello

unread,
Feb 6, 2021, 8:30:11 PMFeb 6
to google-apps-sc...@googlegroups.com
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.


Faustino Rodriguez

unread,
Feb 7, 2021, 3:18:23 PMFeb 7
to Google Apps Script Community
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

unread,
Feb 7, 2021, 10:06:36 PMFeb 7
to google-apps-sc...@googlegroups.com
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



--
Best,
Darren

Romain Vialard

unread,
Feb 8, 2021, 7:38:22 AMFeb 8
to Google Apps Script Community
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.

Faustino Rodriguez

unread,
Feb 8, 2021, 9:37:50 AMFeb 8
to Google Apps Script Community
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

unread,
Feb 18, 2021, 4:31:02 PMFeb 18
to Google Apps Script Community
Reply all
Reply to author
Forward
0 new messages