THANK YOU!! I needed to be able to send automatic reminders for my work when contracts were due to expire. This helped wonderfully.
@cristinapajarillo69565 ай бұрын
Hi! Can you please share how you did it?
@cristinapajarillo69565 ай бұрын
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?
@user-op8mr9lf9o9 ай бұрын
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?
@marcosmrjrbr Жыл бұрын
Thank you so much!
@joeltogado13876 ай бұрын
Good but what if the same duedates i tried it but only send 1 email only the others are missing
@shelleyquinton26895 ай бұрын
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!!
@user-ze3sg5pn3q Жыл бұрын
What would be the possible problem if I get an Error Exception: Failed to send email: no recipient at payReminder(Code:19:11)
@user-ly1cu1wb7p6 ай бұрын
I cannot get this code to email me All checks out but I do not receive emailc
@ryanward49926 күн бұрын
Same even tried switching to GmailApp.sendEmail no luck somthing has changed
@nileshphalke236510 ай бұрын
Thanks a lot 👍
@mattyule9 ай бұрын
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
@affanali64511 ай бұрын
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
@jeromerivera93978 ай бұрын
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?
@user-et1vm2xg9j11 ай бұрын
if we want to add CC mail Please help
@jjc653018 күн бұрын
Code don’t work
@user-hi4ui7in5e Жыл бұрын
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)
@user-hi4ui7in5e Жыл бұрын
Just found the answer, used another loop to push them into an array
@davidmcnulty6681 Жыл бұрын
@@user-hi4ui7in5e do you have a sample sheet of this working ?
@user-ze3sg5pn3q Жыл бұрын
Can you show us where did you insert the loop code you use to push into an array?
@user-hi4ui7in5e Жыл бұрын
@@user-ze3sg5pn3q 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("")
@user-hi4ui7in5e Жыл бұрын
@@davidmcnulty6681 Sorry for the late response, I didn't get a notification. Sadly I don't, I'm sorry
@alejandrorenedo7718 Жыл бұрын
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?
@vaggelis_best Жыл бұрын
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!
@marsescobin Жыл бұрын
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
@vaggelis_best Жыл бұрын
@@marsescobin OK thanks
@naving5972 Жыл бұрын
what does it cost to setup?
@vaggelis_best Жыл бұрын
what do you mean? its free. How much time and effort? Very little!
@marsescobin Жыл бұрын
your time and energy :-) You can also do this without coding it yourself. Check out solutions like Zapier