The Schedule Reminders Add-On allows you to set a schedule of dates on which to send email reminders to specific people. Set it up once and be done.
Listing updated:August 27, 2023
Works with:
**Usage Tips**
+This add-on is intended to be run on a single sheet at a time. Running across multiple sheets simultaneously is not supported.
+ Gmail quotas apply.  100 email recipients per day for free gmail accounts and 1500/day for Workspace accounts.
+ Stick to the provided template. Do not move around or delete template columns, as this will cause errors.  You can hide unused columns or , if you need to add in more data, you can do so after the last template column.
+ Make sure that you place only dates in the date fields and ensure that they are formatted as dates, formatted to align with your locale.   Example shows mm/dd/yyyy date format for USA. 
+ Do not delete the sheet that is automatically set up with the template.  If the sheet is deleted, you will need to rerun the setup to create a new one.
+When you are ready to stop using the Add-On, make sure that you Clear Settings first in order to remove all custom settings from your google sheets. 

+Enter one or more email addresses for the To: and CC: fields
+Define basic content for each email (NOTE: the column layout of the template should not be changed, since the Add-On needs those columns to function.  Additional columns can be added after column K)
+Include both an initial and follow up email for each event.
+Automatically send reminder the morning of the specified dates
+Ability to set Time of daily send
+"Run Now" Feature allows you to do a test run quickly  after setting up your sheet

Set Up Sheet
+Use the Settings menu item in the Add-On menu
+Select time you want the daily email check to happen.
+Click on the "Set Up This Sheet" button to activate the current sheet and set the reminders template.

Schedule Reminders
+The template includes Notes in each column header with specific suggestions. 
+ (NOTE: the column layout of the template should not be changed, since the Add-On needs those columns to function.  Additional columns can be added after column K)
+The example shows how one reminder entry can be set up.  
+Use native Googlesheet features like formulas to copy similar rows, for example when sending the reminder to a similar event to different people on different days.
+The Add-On will check your sheet at specified time each day and will send out emails for any row where the reminder dates are the same as the current date.

Update and Clear Settings
+Use Settings to verify that your sheet has been set up and is active.
+Use "Set Up This Sheet" button in a new sheet if you want to change the Googlesheet you are using.
+Clearing settings will stop the nightly email send.
Additional information
PricingFree of charge
Privacy policy
Terms of service
Schedule Reminders will ask for the permissions shown below. Learn more
Schedule Reminders will need access to your Google account
This will allow Schedule Reminders to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Allow this application to run when you are not present
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Clear search
Close search
Google apps
Main menu