App Icon
Receive email reminders before dates in a specific column of your Sheet are reached.
By:Awesome Gapps
Works with:
1,169,354
Overview
Google Sheets is very useful when it comes to listing tasks in a collaborative effort: personal to-do lists with friends and family or task lists as a project management interface requiring team-wide coordination.
Add Reminders will help you save time by automating a time-consuming process: sending reminders to your contacts and to yourself.

Set up notifications to be sent months, weeks, days or hours before / after each deadline. 
Choose who to notify for each task by adding email addresses in a designated column, separating addresses with a comma. Your contacts will get the notifications according to the settings you chose as well as a direct access to the spreadsheet.

Add Reminders is helpful for personal and / or professional use.
In your personal life
- Send reminders to yourself and your partner about bills to pay before a specific deadline
- In your collaborative blog, send reminders about a list of videos / articles to put online at a specific date by specific people
- Receive a reminder about books to return to the library (especially useful if return dates are different according to the books)
- When preparing a trip far ahead: get a reminder the day before tickets sale opens for a plane, a train…

At work
- Schedule reminders for coworkers to contact clients X days after their payment deadline is overdue
- On the day after each meeting, send automatic reminders to coworkers to write reports
- When working on a collaborative project, send reminders about tasks to accomplish before or after specific stepping stones.
- Send reminders to employees or members of an association when it’s time to renew annual fees

Education
- Send reminders to a whole class when papers are due in a few days
- Send reminders to parents a week before each teacher / parent meetings or any other important event at school
Additional information
DeveloperAwesome Gapps
SupportNot available
Privacy policyNot available
Terms of service
Add Reminders will ask for the permissions shown below. Learn more
Add Reminders will need access to your Google account
This will allow Add Reminders to :
See, edit, create, and delete all your Google Sheets spreadsheets
Connect to an external service
Allow this application to run when you are not present
Send email as you
View and manage data associated with the application
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
Kanti Panjatanasak
October 11, 2015
Not work for me, even I try it in manyway. I also try to create a new Sheet and put just only a date and use this add-on, but not work. It only have an error massage. :( pls fix.
Is this review helpful?
Yes
No
Profile Picture
A User of Add Reminders
April 3, 2018
It was working perfectly then suddenly stopped in Oct. Had to reset the reminders but again it stopped. Re-checked the reminder (7 days before date) was correct and all columns were correct, still not working. UPDATE: The Add Reminder has been working very well, and when it does stop, the Restart has worked. That being said, I got an email message today, "Add Reminders Google Sheets add-on is disabled in this sheet". I have no idea why. I've done a Restart but haven't noticed any difference.
Is this review helpful?
Yes
No
Profile Picture
A User of Add Reminders
March 11, 2016
Have been trying for days to figure out how to set this up and can't figure it out. I have added a column with the dates/times, but the first drop-down menu "Which Column Contains the Deadlines?" gives me no options regardless of how many of those cells are selected. I'm not super intuitive with these types of apps and read the help section for directions, but nothing. Am giving up.
Is this review helpful?
Yes
No
Profile Picture
Julie Koclanis
March 22, 2017
This app does not seem to be working anymore, which is very unfortunate considering that when it did work it worked very well. Please fix your app!
Is this review helpful?
Yes
No
Profile Picture
A User of Add Reminders
December 10, 2015
There is definitely a need for a good addon to manage ETA based notifications. But unfortunately this doesn't work perfect for me, because in my owner column, I have aliases (not emails). Aliases like John, Betty, Both, Children, etc. All of those aliases can be related to an array of email addresses. It would be great if you can modify this addon to allow mapping of aliases to email addresses. I can throw that mapping hidden in the sheet somewhere (or maybe on another sheet).
Is this review helpful?
Yes
No
Profile Picture
A User of Add Reminders
October 6, 2017
EDIT: 2017.10.06 - I just came back to check on this and it is working! If you "restart" your reminders, they should process again, mine did. +RomainVialard and +SureshbabuRamesh Thank you for the Reminders. There are some issues to fix. This does quit working. I did as someone else suggested, removed and reinstalled. That seems like that will fix the problem, however when I did, it started sending me EVERY reminder I have set up. That got blocked with a quota message. I use it in a sheet for managing when my clients software is going to expire. I have reminders set up for two months out so I have plenty of time to buy the new software(Mostly ESET NOD32 at a great discount from NewEgg). This saves us all a ton, and helps me keep up with a large number computers and various software. I very much appreciate when I get these reminders and hope you can sort out the bugs so it keeps working. Vic "Add Reminders Google Sheets couldn't send the reminders in the spreadsheet you have used. https://docs.google.com/spreadsheets/... Please check the following in the sheet "Form Responses 1": Gmail available quota excceeded today. Add Reminders will send the email once the quotas are available. Hence, some reminders will be sent with a delay. You will receive this setting failure message everyday until it's fixed."
Is this review helpful?
Yes
No
Profile Picture
A User of Add Reminders
January 10, 2017
Like others, I found this add-on very frustrating. Firstly, I could only get it to work on a freshly created worksheet built for the purposes; adding it to an existing sheet wouldn't work. That was not so bad, as I could easily enough create a dedicated sheet that pulled the necessary data from my existing sheets. Secondly it only seems capable of sending one reminder. Whenever I tried to set up a second reminder, the first stopped working. I even tried creating separating worksheets for each reminder, but no joy. Again, not critical - two reminders would be nice, but not essential. Thirdly, and most critically, like others, I found that it stops working after a few weeks. I can get it to work again by opening the sheet and add-on, editing the reminder and saving it (unchanged). This works again for a few weeks at which point it fails again. This makes it worse than useless, as the whole point of a reminder is to help you not forget something.
Is this review helpful?
Yes
No
Profile Picture
A User of Add Reminders
March 11, 2016
This app has a good idea to help one set up automatic reminder by means of a simple 3-column spreadsheet, but in my tests it exhibited inconsistent performance in a way that it delivers a reminder email to some email addresses and does not deliver to some other email addresses. Right now, I do not have a clear idea which email addresses are fortunate and which unfortunate. Additional thing that I don't like is that it attaches the whole spreadsheet to the email being delivered. I don't know if the author couldn't work it out without attaching the spreadsheet or he had found it as an appealing idea, but I don't think it should be automatically attached. Sometimes we don't want to share all the other items with the one who was supposed to received a reminder over a single item. At least, it should be offered as an option. But given the fact that Romain (the author) has already offered us a much more valuable tool - Yet Another Mail Merge - he is forgiven here no matter what he does next :) Romain, just keep up a good work with YAMM and don't worry about this :)
Is this review helpful?
Yes
No
Profile Picture
A User of Add Reminders
February 26, 2016
love it - reliability is not great yet, but hoping it gets more stable!
Is this review helpful?
Yes
No
Profile Picture
A User of Add Reminders
June 3, 2017
FRirstly it worked pretty fine, but it stoped. I would love to have a solution or alternative to it. Please fix it. We count on you! Google sheets is, by and large, amazing!
Is this review helpful?
Yes
No
1-10 of 152
Search
Clear search
Close search
Google apps
Main menu