You can
use Google sheets to schedule email messages in Gmail. Write the emails
now and the sheet will send them automatically at a later date and time.
Have you ever wanted to write an email now but send it a later
date and time? Maybe you are sending birthday greetings and would like
the email message to be delivered on the exact day.
One of the
Leading Online Email Providers Microsoft Outlook has a built-in
scheduler to help you schedule email messages to be sent at a later
date.
NOTE: After you are done with composing the email message
in Outlook and hit the Send button, the message will not be
automatically delivered to the recipient immediately — it resides in
your outbox and is sent at the specified time automatically.
Gmail
doesn’t let you schedule a later delivery of email messages but there
are browser extensions — like Boomerang and Right Inbox — that let you
specify a future send date for your outgoing email messages.
How to Schedule & Send Gmail Messages Later with Google Sheets
If
you are reluctant to provide access to your Gmail account to another
service, there’s a better alternative – The Google Sheets.
With
Google sheet you can compose all your emails that you would like to be
delivered later in Gmail and then specify the exact delivery date and
time for these messages in the Google sheet. The messages would be
delivered automatically at the time chosen by you. Internally, there’s a
little Google Script that takes care of sending the messages at the
appropriate date and time.
Schedule your Gmail – Step by Step
Go
to your Gmail mailbox and compose a few test messages that you would
like to be delivered later. Your draft messages can have rich
formatting, you can add attachments, signatures and even inline images.
Make sure that you have included the recipient’s email address in the TO
field of the drafts.
1. Click here to make a copy of the Gmail Scheduler sheet (v2.0) in your Google Drive.
2. Change the default timezone of your Google spreadsheet. The emails will get scheduled in this timezone.
3.
Inside the sheet, choose Authorize under the Gmail Scheduler menu and
grant the necessary permissions. This script is running in your own
Google Drive and none of your data is accessible to anyone else.
4. Choose Gmail Scheduler | Fetch Messages to import all the draft messages from your Gmail account into the Google Sheet.
5.
Set the scheduled date and time for individual messages in column D of
the sheet. You can double-click a cell and use the date picker or you
can manually enter the date and time as m/dd/yyyy h:mm:ss in 24 hour
format.
6. Go to Gmail Scheduler | Schedule Messages and run the
scheduler. You can close the spreadsheet and it will send messages at
the specified time automatically.
Scheduling Gmail messages with
Google sheets is easy. Please do note that once a message has been
scheduled, you should not edit the corresponding Gmail draft message
else that particular message would be removed from the queue.
If
you wish to edit the draft or need to change the delivery time once the
messages have been scheduled, you can repeat the steps #3 to #5 and
reinitialize the queue.