We have featured apps like Boomerang which allow you to send scheduled email messages from Gmail before. However, it is possible to do the same thing just without any extra apps. Amit Agarwal of Digital Inspiration shows us that how to do this with a Google Sheets script.
The script requires you to write your Gmail messages firstly and save or mark it as a draft. Once that is done, here you can import your drafts into the script and schedule a date and time what you would like the email to go out. To set up the script–
- Just start here create a duplicate of the script here.
- Under “Gmail’s Scheduler” click “Step 1: Authorize” and Select the account you wish to authorize, and log in if necessary.
- Then Under “Gmail Scheduler” click “Step 2: Fetch messages” and This will pull in all in your Drafts folder and so this may be a better time to clean it out.
- Here should Double-click the “Scheduled Time” cell next to the email what you want to send. Now You can choose a date there or manually push the date and time in the following format: m/dd/yyyy h:mm:ss.
- Lastly you have chosen all the right date and times for your email messages then select “Schedule Messages” under “Gmail Scheduler.”
Finally you have got the script set up for the 1st time, you should only need to do steps 3-5 to schedule email messages. It may not be a one-click affair, and it must would be nice if Gmail had this feature built in, but in the meantime this script does its job well.