this is very useful instruction for me - a nonTechnical knowledge to follow and build my own reminder. I am apriciated you so much for the tutorial as well as the google sheet file. Wish you health and have more useful clips for community.
Hi! Thanks for explaining line per line you really made it easier for me as a beginnner! Qq - what if I have multiple conditions, say I’d like to receive an email when it’s 30 days (also 60 days 😅) before the due date (like in contracts), and that condition would have a customized email template within the script? Would that be multiple IF statements, and/or multiple loop function? Thanks very much in advance and more power!
Hi there, thanks for making the tutorials. very helpful. The source code link doesn't display the functions code correctly. Could you add it to the description or update that page?
Hi - I've taken a copy of the template and followed your instructions. I've run a test but not receiving a reminder even though the date is due for the items - would you be able to help if I send you a copy of the sheet? I'd be very appreciative if you could? Many thanks - Matt
Hi, may I ask. I use my sheets on my mobile and I hope the code sends me reminders on specific hours of the day. I have tested it and it works fine. However when it is time for the trigger to work, it does not send email notifs. May I know if this should work even my googlesheets is not open? Will the code continue to send me email notifs even if it is not activated?
Hey, thank you so much for this little tutorial. It's easy to follow and almost exactly what I was looking for. I only have one slight problem: If I were to have more than one bill having to be paid on the same day. Let's say House and Phone Bill for example, what can I do for the script to output me both, instead of only the last one (that's currently happening in my script. I use it send reminders to different people, but when more than one has to be reminded, the script only gives me the last one in the list)
@@RyanMan-h1k Hi. My script is far from being elegant or very efficient, but its doing what it’s supposed to do. Don’t know if this helps you. I put in another variable for the script to push the clients in the clients-array : var clients = [] for (i=0; i< dueDates.length; i++) { if (dueDates[i] == currentDate) { clients.push(Kundendaten.getRange(i+2,3).getValue()) Later on when it comes to whether or not a reminder should be send, I have this simple condition. The clients-array only gets filled with a value when the due date matches the current date. And only if there is anything in the array at all, the reminder gets send to the mail recipient whom it concerns. There might be another and more elegant way to do this with strings instead of an array, but I didn’t have the time to try everything out. if (clients.length > 0) { MailApp.sendEmail("")
Amazing video... there is only one thing; Althogh I pasted the code, when i clicked on 'run' in the Execution log it said; Error Exception: The parameters (String,String,String) don't match the method signature for Utilities.formatDate. I presume google scripts thinks dueColumn[i] is a string and not a number/ date? I'd reeeeally appriciate any kind of help!
THANK YOU!! I needed to be able to send automatic reminders for my work when contracts were due to expire. This helped wonderfully.
Hi! Can you please share how you did it?
this is very useful instruction for me - a nonTechnical knowledge to follow and build my own reminder. I am apriciated you so much for the tutorial as well as the google sheet file. Wish you health and have more useful clips for community.
Hi! Thanks for explaining line per line you really made it easier for me as a beginnner!
Qq - what if I have multiple conditions, say I’d like to receive an email when it’s 30 days (also 60 days 😅) before the due date (like in contracts), and that condition would have a customized email template within the script? Would that be multiple IF statements, and/or multiple loop function?
Thanks very much in advance and more power!
thank you, it worked. Now what about sending someone in cc or bcc?
Thank you so much!
Thx so much, very helpful
Hi there, thanks for making the tutorials. very helpful. The source code link doesn't display the functions code correctly. Could you add it to the description or update that page?
I want to get birthday reminder prior one 1 day before birthday using Data from google sheet on email can you help using google script
Thank youuuuuuuuuuuuuuuuuuuuuuuuuu!!!!!!!!!!!!!!!!!! Really helpful!
Good but what if the same duedates i tried it but only send 1 email only the others are missing
How can I just change the script if I need a reminder one week prior to due date and to a specific email of the person that needs to pay it?
Hi - I've taken a copy of the template and followed your instructions. I've run a test but not receiving a reminder even though the date is due for the items - would you be able to help if I send you a copy of the sheet? I'd be very appreciative if you could? Many thanks - Matt
Hi, may I ask. I use my sheets on my mobile and I hope the code sends me reminders on specific hours of the day. I have tested it and it works fine. However when it is time for the trigger to work, it does not send email notifs. May I know if this should work even my googlesheets is not open? Will the code continue to send me email notifs even if it is not activated?
It did send the email but in a test I ran it sent 2 emails with the same body and message, any reason why this is happening? Thanks for info on this!!
What would be the possible problem if I get an Error Exception: Failed to send email: no recipient
at payReminder(Code:19:11)
Hi, Please Keep going 💯
Thanks a lot 👍
I cannot get this code to email me
All checks out but I do not receive emailc
Same even tried switching to GmailApp.sendEmail no luck somthing has changed
if we want to add CC mail Please help
Hey, thank you so much for this little tutorial. It's easy to follow and almost exactly what I was looking for. I only have one slight problem:
If I were to have more than one bill having to be paid on the same day. Let's say House and Phone Bill for example, what can I do for the script to output me both, instead of only the last one (that's currently happening in my script. I use it send reminders to different people, but when more than one has to be reminded, the script only gives me the last one in the list)
Just found the answer, used another loop to push them into an array
@@backoffice-b1e do you have a sample sheet of this working ?
Can you show us where did you insert the loop code you use to push into an array?
@@RyanMan-h1k Hi. My script is far from being elegant or very efficient, but its doing what it’s supposed to do. Don’t know if this helps you.
I put in another variable for the script to push the clients in the clients-array :
var clients = []
for (i=0; i< dueDates.length; i++) {
if (dueDates[i] == currentDate) {
clients.push(Kundendaten.getRange(i+2,3).getValue())
Later on when it comes to whether or not a reminder should be send, I have this simple condition.
The clients-array only gets filled with a value when the due date matches the current date. And only if there is anything in the array at all, the reminder gets send to the mail recipient whom it concerns.
There might be another and more elegant way to do this with strings instead of an array, but I didn’t have the time to try everything out.
if (clients.length > 0) {
MailApp.sendEmail("")
@@davidmcnulty6681 Sorry for the late response, I didn't get a notification. Sadly I don't, I'm sorry
Hi there, i need some help! the source code I copy in the description doesn’t match the code you use in the video! Am I doing something wrong?
Amazing video... there is only one thing; Althogh I pasted the code, when i clicked on 'run' in the Execution log it said; Error
Exception: The parameters (String,String,String) don't match the method signature for Utilities.formatDate. I presume google scripts thinks dueColumn[i] is a string and not a number/ date?
I'd reeeeally appriciate any kind of help!
thats very likely it. Make sure your dueColumn is formatted to a number in Google Sheets. I think its tool > format number if I remember correctly
@@marsescobin OK thanks
what does it cost to setup?
what do you mean? its free. How much time and effort? Very little!
your time and energy :-) You can also do this without coding it yourself. Check out solutions like Zapier
Code don’t work
It doesn't work po.