How to Schedule Gmail Messages with Google Sheets?
Learn how to schedule email messages in Gmail, including recurring emails with Google Sheets. Now write email and the sheet will send them automatically at the later date and time.
Do you ever want to write an email message in Gmail but send it later date and time? Perhaps you are sending birthday greetings and want to distribute email messages on the right day. Or you just wrote an email but want to schedule delivery in the time zone of the recipient when the message is more likely to be read.
Microsoft Outlook has a built-in scheduler that helps you delay the delivery of email messages. After writing an email message and pressing the Send button, the message is not immediately distributed – it stays in your Outbox and is sent automatically to the specified date and time.
Gmail does not allow you to schedule delivery after email messages but there are browser extensions – such as Boomerang, Sidekick and Right Inbox – which allow you to specify a future sending date for your outgoing email messages. These are subscription-based services that allow you to send only limited number of scheduled email messages for free per month. The second concern is privacy – to enable scheduling within Gmail, you must read and write your entire Gmail account in the third party.
Schedule and send Gmail messages later
If you are reluctant to grant access to any other service in your entire Gmail account, then Google Sheets is a good choice.
Whatever you can do, it writes all the emails that you want to distribute later in Gmail, leave them as drafts, and then specify the exact delivery date and time for these messages in Google Sheets. Messages will be automatically delivered to Google Scripts at the time you choose.
Gmail Scheduler is available in free and premium versions. Premium Edition lets you schedule more emails, you can schedule daily, weekly, or monthly recurring emails, allowing you to send mail from other nicknames associated with your Gmail account, and you can get one-to-one support.
You can purchase premium versions using your credit card or PayPal. It’s a flat one-time fee (not subscribed) and you can use the program for life. You get free technical support at email for 6 months.
Platinum Edition has all the features of Premium and includes 12+ support for phones, Skype or Google One-on-one support.
Refunds can be requested within 6 hours of purchase.
How to Set Up Gmail Scheduler
It’s easy to schedule Gmail messages with Google Sheets. Go to your Gmail mailbox and type some email messages that you want to send later. Do not press the send button, just leave these draft messages in the draft folder on your Gmail account.
Your draft messages can have rich formatting, you can also add attachments, signatures and even inline images. Make sure you include the recipient’s email address in the To field of draft email.
- Click here to copy Gmail scheduler sheet to your Google Drive.
- Go to File – Select your current timezone from the spreadsheet settings and dropdowns. Emails will be set in this timezone.
- Go to the Gmail scheduler menu, select the authorization and give the necessary permissions.
- Select the Gmail scheduler menu again and select Receive message to import all draft messages from your Gmail account into Google Sheets.
- Set the date and time for different messages in the column D of the sheet. You can double-click on the cell and use the date picker or you can manually enter the date and time mm / dd / yyyy h: mm: ss in 24 hour format.
- Go to Gmail Scheduler -> Schedule Message and Scheduler Run You can close the spreadsheet and it will send the message automatically at the specified time.
Please note that once the email message has been scheduled, you should not edit the related Gmail draft message or else it will be removed from the queue. If you want to edit the draft or after resolving messages, the delivery time
E has been determined, you can bring the draft again and start the queue again. The free edition of Gmail Scheduler lets you schedule up to 10-20 email messages at a time. If you want to schedule more messages, or if you are trying to schedule a recurring email with Gmail, please get the premium version.