We’ve featured apps 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 you would like the email to go out. To set up the script:
- Create a duplicate of the script here.
2. 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).
3. 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: m/dd/yyyy h:mm:ss.
4. When you’ve chosen all the correct date and times for your emails, select “Schedule Messages” under “Gmail Scheduler.”
5. Once you’ve got the script set 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.
Source – lifehacker.com