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 message in Gmail 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. Or you have written an email now but would like to schedule delivery in the recipient’s time zone when the message is more likely to get read .
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 isn’t delivered immediately â€" it stays in your outbox and is sent at the specified date and time automatically.
Gmail doesn’t let you schedule a later delivery of email m essages 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 Gmail account to a third-party to use scheduling emails inside Gmail.
If you are reluctant to provide access to your entire Gmail account to another service, there’s an alternative â€" Google Sheets.
What you can do is compose all the emails that you would like to be delivered later in Gmail, let them stay as drafts 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 with Google Scripts [1] .
The Gmail Scheduler is available in free and premium editions. The premium edition lets you schedule more emails, you can send mails from another alias associated with your Gmail account and you can also opt for one-on-one support.
| Features | Free | Premium |
|---|---|---|
| Supports Gmail & Google Apps | Yes | Yes |
| Number of emails that you can schedule | 20 | No limit |
| Change the sender’s email address (Gmail alias) | No | Yes |
| Preserve drafts and reschedule them later | No | Yes |
| Log scheduling activity for troubleshooting | No | Yes |
| Installation Manual (PDF) included | No | Yes |
| Support options | None | |
| Choose Edition | Forever Free | Premium [2] |
| Platinum includes all features of Premium plus one-on-one support over Skype, Google Hangouts and remote screen sharing | Platinum [3] | |
| You may make payments through PayPal or your credit and debit cards. Refunds can only be requested within 12 hours of purchase. | ||
Scheduling Gmail messages with Google sheets is easy. Here’s a detailed video tutorial [4] (download [5] ) that will walk you through the steps for using Gmail scheduler.
How to Setup Gmail Scheduler
Go to your Gmail mailbox and compose a few email messages that you would like to send 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 draft emails.
- Click here [6] to make a copy of the Gmail Scheduler sheet (v2.0) in your Google Drive.
- Change the default timezone of your Google spreadsheet. The emails will be scheduled in this timezone.
- 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.
- Choose Gmail Scheduler -> Fetch Messages to import all the draft messages from your Gmail account into the Google Sheet.
- 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.
- Go to Gmail Scheduler -> Schedule Messages and run the scheduler. You ca n close the spreadsheet and it will send messages at the specified time automatically.
Please do note that once an email message has been scheduled, you should not edit the corresponding Gmail draft message else it will 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 fetch the drafts again and reinitialize the queue.
How to Change the Spreadsheet Timezone
The scheduled date and time that you specify in the cells use the default timezone of the spreadsheet. If you wish to send mails in a different timezone, open the spreadsheet and pick a different timezone under File -> Spreadsheet Settings menu.
Links
- ^ Google Scripts (ctrlq.org)
- ^ Premium (www.paypal.com)
- ^ Platinum (www.paypal.com)
- ^ video tutorial (www.yout ube.com)
- ^ download (img.labnol.org)
- ^ Click here (docs.google.com)
No comments:
Post a Comment