We’ve featured tools like Boomerang that allow you to send scheduled emails from Gmail before. However, it’s possible to do the same thing without any additional apps. Amit Agarwal of Digital Inspiration shows us how to do this with a Google Sheets script.
The script requires you to write your message in Gmail first and save it as a draft. Once that’s done, you can import your drafts into the script and schedule a date and time when you would like the email to go out. To set up the script:
- Create a duplicate of the script found here.
- Under “Gmail Scheduler” click “Step 1: Authorise”. Select the account you wish to authorise, and log in if necessary.
- Under “Gmail Scheduler” click “Step 2: Fetch messages”. This will pull in everything in your Drafts folder (so this may be a good time to clean it out).
- Double-click the “Scheduled Time” cell next to the email you want to send. You can choose a date there or manually enter the date and time in the following format: mm/dd/yyyy h:mm:ss.
- When you’ve chosen all the correct date and times for your emails, select “Schedule Messages” under “Gmail Scheduler.”
Once you’ve set the script up for the first time, you should only need to do steps 3-5 to schedule new messages. It may not be a one-click affair, and it sure would be nice if Gmail had this feature built in, but in the meantime this script does its job well.
How to Schedule your Email Messages in Gmail with a Google Sheet [Digital Inspiration]