Schedule & Send G-mail Messages Later with Google Sheets

How to Schedule & Send G-mail Messages Later with Google Sheets

Microsoft Outlook has a built-in scheduler to help you delay the delivery of email messages. After you are finished writing an email message and hit the Send button, the message is not delivered immediately — it stays in your outbox and is sent at the specified time automatically.

G-mail does not 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.

These are however subscription based services that allow you to send only a limited number of scheduled email messages for free per month. The other concern is privacy – you will have to grant read and write access to your entire G-mail account to a third-party to use scheduling inside G-mail.

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 in your Google Drive and change the default timezone.
2. Open the sheet from google drive, 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.
3. Choose Gmail Scheduler -> Fetch Messages to import all the draft messages from your Gmail account into the Google Sheet.
4. 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.

1. 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.