Introduction to Spreadsheet Automation 101 Lesson 3

<div>0:00 Hello, welcome to the lesson of email yourself. In this section of modules, we're gonna be creating a list here of tasks.<br>0:10 We're gonna be emailing ourselves whatever tasks are not done. So we're gonna be using the for loop, we're gonna be applying the if of syntax .<br>0:18 We have bracket notation we're gonna use here. We're gonna use mail app, which is a fairly straightforward, at least the way that I use it, is fairly straightforward.<br>0:27 Three items. You gotta know who you're sending to. The subject of the email and the body of the email. Email Yourself a Cell from a Google Sheet, Every Day Quick Follow Up Email

We're just sending some texts.<br>0:33 We're not gonna go too deep into formatting html emails. We're just gonna get some data from our sheet into our inboxes or other people's inboxes.<br>0:42 Wait stick around. Sheet Stories / Video Notes + ADDED: Email Notifications Email Yourself a Cell from a Google Sheet, Every Day Email When Cell Changes

Gotta go to the end of the module here because we are not only emailing ourselves a lot of data , we are able to email a lot of other people.<br>0:52 So, I mean, if you have some dreams of, of running your own paid newsletter and you don't wanna deal with cking, you just want a list of emails or you need a report to a lot of people, maybe you're sending reports on a weekly basis to many people, we will put those emails into our Google sheet here and be able to email 'em so you can add those emails if you want later on after you automate this process.<br>1:13 Some very cool things. Build A Business: PR Agency in a Google Sheet 5 Ways To Use Google Sheets for Advanced Project Management OnlySheets Automatic Email Report from Google Sheets

We're gonna also get into the first time-based trigger , which pretty much is Aron job inside of Google Sheets.<br>1:22 I really like it. I think it's one of the most powerful things in all of Google Sheets and app scripts to be able to write a script and then execute that without us having to touch a single thing later.<br>1:34 Be able to email ourselves daily email ourselves weekly, monthly reports, and email other people. I think it's pretty awesome. I'm so excited you got to this stage of the course.<br>1:45 I'm really excited to keep going. Bye.</div> What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users Automatic Calculations Automatic Email Report from Google Sheets