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

Рет қаралды 17,037

Жыл бұрын

You can copy the Google sheet template here: marsescobin.gumroad.com/l/Bil...
See Medium tutorial here: medium.com/@mars_escobin/how-...
See source code here: gist.github.com/mariannetrizh...

Пікірлер: 38

@trinityWSO 9 ай бұрын

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

@cristinapajarillo6956 4 ай бұрын

Hi! Can you please share how you did it?

@PatrickMuvunyi-j4u 3 күн бұрын

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

@marcosmrjrbr Жыл бұрын

Thank you so much!

@affanali645 10 ай бұрын

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

@nileshphalke2365 9 ай бұрын

Thanks a lot 👍

@user-et1vm2xg9j 11 ай бұрын

if we want to add CC mail Please help

@PhichetTansakul Ай бұрын

Thx so much, very helpful

@cristinapajarillo6956 4 ай бұрын

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!

@joeltogado1387 6 ай бұрын

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

@VikasSagar-h2i 19 күн бұрын

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

@alejandrorenedo7718 11 ай бұрын

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?

@mattyule 9 ай бұрын

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

@jeromerivera9397 7 ай бұрын

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?

@shelleyquinton2689 4 ай бұрын

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 11 ай бұрын

What would be the possible problem if I get an Error Exception: Failed to send email: no recipient at payReminder(Code:19:11)

@user-op8mr9lf9o 8 ай бұрын

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?

@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

@khaledawad6837 Ай бұрын

Hi, Please Keep going 💯

@user-ly1cu1wb7p 5 ай бұрын

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

@ryanward499 5 күн бұрын

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

@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 11 ай бұрын

Can you show us where did you insert the loop code you use to push into an array?

@user-hi4ui7in5e 11 ай бұрын

@@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 11 ай бұрын

@@davidmcnulty6681 Sorry for the late response, I didn't get a notification. Sadly I don't, I'm sorry