How To Schedule and Send Emails in Google Spreadsheet.

Schedule Emails.

If you get a work of sending email messages to a list of emails so they can receive the email together at a specific time then you can use Google Spreadsheet to schedule your emails for a particular date and time.    

You can use a script in Google Sheets to schedule sending as many different email messages as you like.

Go to drive.google.com and click New, then Google Sheets.

Google Sheets

Enter email addresses in the first column and the message body in the third column, so there is one email in each row - address, subject, and body.

Google Spreadsheet.


Go to Tools, ‘Script editor’ and replace what’s there with the following:

function SendIt() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  for(var i = 0; i < data.length; i++){
    MailApp.sendEmail(data[i][0], data[i][1], data[i][2]);
  }
}
Script editor

Click Save icon, Enter a new project name in the box and click on OK.

Script editor

Select Edit, then ‘Current project’s triggers’, from the drop-down menu. 

Current project’s triggers

You will get redirected to the Google App Script page, click Add Trigger in the lower right corner of the page. 

Add Trigger

Set the ‘Event source’ to ‘Time drive’ and set ‘Select type of time-based trigger’ to ‘Specific date and time’. Enter a time and date to send the emails, such as 2020-08-14 14:30, and click Save

Schedule Specific date and time

Several security messages and warnings appear asking if you trust the developer to access your email account-just click through them to authorize the script. 


That’s it. You can change the email messages in the spreadsheet, add more, delete old ones, and so on. New date triggers can be added to send the same or new emails. 

Follow Raveling Tech on Facebook and Twitter for more such technology related posts.  

Post a Comment

Previous Post Next Post