Simple Daily Reminder Email in Google Sheets

0:00 If you're like me and you use your inbox or your email as your to do list, but you also create to do lists inside of Google Sheets, we're going to create a simple daily reminder email that's going to remind us to check our tasks sheet. So we have our sheet, let's go up to extensions, Apps Script . Once here, we'll create a function called send reminder. We're going to send a reminder to someone, which is us. So we'll say variable email equals session. getActiveUser. getEmail. This gets email of me or my account. It will be sending emails from me to me. You could also hard code your own email address in quotes or use [email protected], Email Yourself a Cell from a Google Sheet, Every Day Why do I want to Email Myself Every Day? Automated Project Management in Google Sheets Weight Tracker with Automatic Email Reminder

0:45 anything like that. We're going to send an email using gmail app dot send email. We need one more variable, which is the URL of the sheet. We'll do spreadsheet app dot, get active spreadsheet , get URL. We're going to need three things. We're going to need to send the email to someone. We're going to need a subject. Check this sheet, comma, and a body. Check this tasks list, plus URL. Command S, or save. We can run this to test it right now, but we want to trigger it every day. So let's click run. We will have to authorize it at the moment or when we save it as a trigger . So I'll check my inbox and here it is. I have an email from me to me. Create an Automated Task List Simply Email Yourself From a Google Sheet Automated Project Management in Google Sheets Weight Tracker with Automatic Email Reminder

1:30 It says check this sheet, check this tasks list and has the URL of the sheet and nice little attachment here too. Very cool. So let's create this daily. Over on the left side in your Apps Script , click triggers. On the bottom right, add trigger . We're going to choose which function to run. If we have multiple functions , if not, it'll just be right here. Send reminder. Our event source, we're going to change to time driven. Once we do that, we have a couple of more options. We want to type to be day timer and we're going to select the time of day. Let's do it just before we get to work 5 to 6 AM. Click save. If you haven't authorized it yet, it will ask you to authorize at this moment. And now we have a trigger that will trigger every single day that Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5 What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users Create an Automated Task List Automated Daily Reminders

2:17 email to say, check this sheet. If you want to edit it, just click on the pencil icon. If you want to delete it, click on the three dots and click delete trigger to delete forever. You can always add it again. It takes just a few clicks to send a simple daily reminder email in Google Sheets. If you enjoyed this and want to get more automations, subscribe here to BetterSheets on YouTube. Send a Button from Google Sheets in an Email Simply Email Yourself From a Google Sheet Automated Project Management in Google Sheets Weight Tracker with Automatic Email Reminder