How to Send Email Reminders when your Bills are Due on Google Sheet

[@trinityWSO]

THANK YOU!! I needed to be able to send automatic reminders for my work when contracts were due to expire. This helped wonderfully.

[@cristinapajarillo6956]

Hi! Can you please share how you did it?

[@cristinapajarillo6956]

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!

[@PatrickMuvunyi-j4u]

Thank youuuuuuuuuuuuuuuuuuuuuuuuuu!!!!!!!!!!!!!!!!!! Really helpful!

[@khaledawad6837]

Hi, Please Keep going 💯

[@PhichetTansakul]

Thx so much, very helpful

[@VikasSagar-h2i]

thank you, it worked. Now what about sending someone in cc or bcc?

[@user-op8mr9lf9o]

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!

[@joeltogado1387]

Good but what if the same duedates i tried it but only send 1 email only the others are missing

[@shelleyquinton2689]

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-ly1cu1wb7p]

I cannot get this code to email me All checks out but I do not receive emailc

[@ryanward499]

Same even tried switching to GmailApp.sendEmail no luck somthing has changed

[@nileshphalke2365]

Thanks a lot 👍

[@mattyule]

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

[@affanali645]

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

[@jeromerivera9397]

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-et1vm2xg9j]

if we want to add CC mail Please help

[@jjc6530]

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

[@CrimsonRed1990]

It doesn't work po.