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:
101K+
Overview
**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. 

Features:
+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

INSTRUCTIONS
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
Developer
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
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Chelsea Koby
July 24, 2023
Is there another way to add to more than one sheet? I really need to use this app on more than one because I have multiple sheets with dates for different things. Please help....
Is this review helpful?
Yes
No
Profile Picture
Mildred Osicos
August 7, 2023
This app is not working for my sheet. Can anyone help me?
Is this review helpful?
Yes
No
Profile Picture
Keila Mulero
September 17, 2023
I have found the tool I needed for reminders. It does work !
Is this review helpful?
Yes
No
Profile Picture
Saurabh Sharma
July 6, 2021
Very good Add-on for sending out the first reminder. However, it is not taking the second reminder message, just send the same first message in the email of second reminder. I don't know how it will read the Second Reminder (optional) message to be sent with Second Reminder. Very easy to use and quick. Saved me a lot of time. Happy to rate you 5.
Is this review helpful?
Yes
No
Profile Picture
Edubamo Akrah
January 31, 2023
Sure addon.
Is this review helpful?
Yes
No
Profile Picture
Zwelethu Bindiza
November 18, 2021
The Add-on works just fine. But can't get it to work on a different sheet in a different location except for the one I originally deployed on.
Is this review helpful?
Yes
No
Profile Picture
A User of Schedule Reminders
May 31, 2021
Not bad, but I see nowhere the cap on the number of emails that can be sent.
Is this review helpful?
Yes
No
1-7 of 7
Search
Clear search
Close search
Google apps
Main menu