Get A Read Receipt When Recipient Opens Your Gmail Message

Written on:October 17, 2012
Add One



A read receipt is an email notification delivered when a recipient opens (and presumably reads) an email you send. The receipt confirms that the recipient saw your message and records the time.But this feature is only available on Business accounts.

Here is a script that can do the same thing running in the background of a Google spreadsheet containing your message.This is very simple and can be easily done by following these steps…

Step 1 –

Create a Spreadsheet in Google Drive.

Step 2 –

Put Your Email Address on the First Cell ( Position Column 1 and Row 1 ) of the Spread Sheet.Put the Title of the Message on the next cell ( Position Column 2 and Row 1).


spreadsheet read reciept


Step 3 –

Give some space and start writing your massage in any cell you want.You can write any amount of message even format them according to your needs.


gmail read reciept


Step 4 –

Add the following code to the spreadsheet.

Go To Tools > Script Manager > Create New Script > Add the following code > Save


script read receipt gmail


//Read Receipt Code Start
//Read receipt Gmail Script Written By

function onOpen() {
var rr = SpreadsheetApp.getActiveSpreadsheet();
var mailadd = rr.getRange("A1").getValue();
var id = rr.getRange("B1").getValue();

var EMAIL_SENT = "File Opened on";
var msg = "This is to inform you that I have read your message titled " + id + " on " + Date();

if (mailadd != EMAIL_SENT) {

var emailAddress = mailadd; // First column
var message = msg; // Second column
var subject = id;

MailApp.sendEmail(emailAddress, subject, message);
// Make sure the cell is updated right away in case the script is interrupted
rr.toast("A read receipt has been sent to the Author of this Massage");

//Read Receipt Code End


Step 5 –

Set Trigger attributes by clicking on the Current Script’s Triggers Icon.


trigger mention


Click on Add a new trigger. Set Trigger Run = OnOpen and Trigger Events = From Spreadsheet and OnOpen. Click Save.


trigger setting


Step 6 –

Share the Spreadsheet via email or through Google Drive Sharing Options.

Step 7 –

When the receiver would open the spreadsheet a Notification will pop up stating “A read receipt has been sent to the Author of this Massage”:

Also, the Cells containing your email address and the Title of the message would be replaced with the date-stamp of when the message was first opened.


large send reciept


The Author of the message would get a confirmation message through email.


confirmation email recieved


This is a very good process to be assure that the recipient has received your important messages.Have fun and be creative…

Leave a Comment

Your email address will not be published. Required fields are marked *