Daily Countdown Email from Google Sheets

0:00 we wanna send an email every day that says, Hey, this date is coming closer, one day at a time. We really just need the date. We need who we're sending that email to, and we could use another formula here equals date diff. We're gonna get the start date , which is today, which is with parentheses. End date is gonna be this date that we're counting down to, and the unit is in quotes, D and that's. Going to change every single day. So we need to send an email today and then tomorrow, and then the next day, and each day, this formula is going to change. So we just real need to remember that B one on sheet one is going to have the number of days until this event. How Many Days Between Two Dates? Email Yourself a Cell from a Google Sheet, Every Day How To Email Reminders Before a Deadline in Google Sheets

0:45 Maybe it's a vacation, maybe it's an anniversary, birthday, whatever it is. So let's go to Extensions app script . And here, let's create a function called email. We need just three things. Variable two, who it's to and for me, I'm gonna send it to myself so we could write an email here. Actually, I'm going to go spreadsheet app, get active spreadsheet , get owner , get email, and that's me. But maybe it's the owner of the sheet that you are creating or adding this to variable subject. That's gonna be one more day done and the body is going to be. Hey, it's only, and then we're gonna add a plus, and we're gonna have days plus until that event. Create an Automated Task List Email Yourself a Cell from a Google Sheet, Every Day Automatic Calculations Email When Cell Changes

1:34 Now, here's the hard part. Variable days equals spreadsheet app. Get active spreadsheet , that's the entire file. Get sheet by name, which is sheet one. Get range . Which is B one? Get value. Just get value with parentheses. Save this. And now, right at this moment, we could click run. It'll ask us to authorize and it'll actually send an email. Let's click continue. We actually have to send the email. We'll use mail app dot, send email to subject body. Save that, and now it will actually send an email. We have an email here called One More Day. Spreadsheet Automation for Beginners Email Yourself a Cell from a Google Sheet, Every Day Automatic Calculations Automatic Email Report from Google Sheets

2:20 Done. Hey, it's only 15, huh? Wait, we missed actually writing the word days here, so save that. Run it again. And now it says, Hey, it's only 15 days until that event, and you can write whatever you want here. So how do we send this actually every day? Well, we're gonna go over here to triggers. On the left side, we're going to go to the bottom right corner, say add trigger . We're gonna select email From this function we're going to. Send event source, time driven daytimer, and we're gonna pick a day, maybe, uh, pick a time of day, sorry, maybe in the morning. And now when this runs its course and it's still sending you an email and it just says. It's only blank days until that event. We can come to the triggers and on the far right click the three Send Daily Email Updates Email Yourself a Cell from a Google Sheet, Every Day Automatic Calculations Create Reminders Daily to Check Sheet EMAIL CALENDAR TASK

3:10 buttons and click delete trigger , and that will delete it forever. Hopefully that was super fun and interesting for you. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet. Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5 Automate Row Deletion in Google Sheets with Apps Script Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet Button Styles