Installation

• Go to Mail Scheduler folder
• Copy 2 Mail Scheduler files (Google Spreadsheet & Form file) to your own Google Drive (You might rename the copied files). Please do not try on the template directly because it will send mail under my Gmail account.
• Open Mail Scheduler spreadsheet file
• The script will add an additional menu named Mail Scheduler in Google Spreadsheet app menu
• Click Mail Scheduler\Install script menu item

• You'll see one of the authorization dialogs shown here when it is run

Click Continue button to continue. On July 18, 2017 Google announced new security protections to reduce risk from unverified apps. This announcement came in response to continued work to prevent phishing attacks that have used Google Apps Script. As part of this newly created Apps Script projects in certain circumstances will present the user a This app isn’t verified screen. The user can take steps to dismiss the warning and authorize the app alternatively the developer can submit their app to Google to become verified.

Click Advanced

• Click Go to Mail Scheduler (unsafe)
• Confirm scopes and click Allow

Demo

• Create mail scheduler by filling the form at https://rebrand.ly/ms-form
• To view data after create scheduler, go to https://rebrand.ly/ms-sheet

Add new mail schedule

• Open data entry form by selecting Form\Go to live form in Google Spreadsheet app menu
• Input necessary information for scheduling/recurring emails

Update existing mail schedule

• Find the associated row in Google spreadsheet file then edit data. Do not update or delete Uid & Execution column values

Delete existing mail schedule

• Just delete the correspondent row in Google spreadsheet file

Change default timezone

The default timezone of the script is the same as the containing Google Spreadsheet. To change default timezone

• Open Google script editor by choosing Tools\Script editor in Google spreadsheet app
• Within Google script editor , choose File\Project properties then select Info tab

OR

• Open the Google Spreadsheet, go to File and then Spreadsheet settings to see/set your default timezone.