This lesson will teach you how to email yourself by sending some texts. Learn how to get some data from your sheet and send them into your inboxes or other people’s inboxes.
Academy ↓
Hey there stranger!
Introduction to Spreadsheet Automation 101 Lesson 3
About this Tutorial
Video Transcript
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.
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.
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.
0:27 Three items. You gotta know who you're sending to. The subject of the email and the body of the email. We're just sending some texts.
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.
0:42 Wait stick around. 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.
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.
1:13 Some very cool things. We're gonna also get into the first time-based trigger, which pretty much is Aron job inside of Google Sheets.
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.
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.
1:45 I'm really excited to keep going. Bye.
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.
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.
0:27 Three items. You gotta know who you're sending to. The subject of the email and the body of the email. We're just sending some texts.
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.
0:42 Wait stick around. 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.
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.
1:13 Some very cool things. We're gonna also get into the first time-based trigger, which pretty much is Aron job inside of Google Sheets.
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.
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.
1:45 I'm really excited to keep going. Bye.
Courses
Spreadsheet Automation 101: Introduction to Pre-course Videos
Breaking Through Errors In Apps Script
Think Like a Programmer: Develop The Mindset of an Apps Script Coder
Tips to Navigating Thousands of Lines of Code In Apps Script
Spreadsheet Automation 101: Functions
Spreadsheet Automation 101: Variables
Spreadsheet Automation 101: Dot Notation
Spreadsheet Automation 101: Camel Case
Spreadsheet Automation 101: Parentheses
Spreadsheet Automation 101 Lesson 1: GetValue - Introduction to SpreadsheetApp
Spreadsheet Automation 101 Lesson 1: Spreadsheet Taxonomy
Spreadsheet Automation 101 Lesson 1: A1 Notation vs Row,Column Syntax
Spreadsheet Automation 101 Lesson 1: getActiveSpreadsheet() vs getActiveSheet()
Spreadsheet Automation 101 Lesson 1: onOpen() Trigger - Custom Menu
This Seems Like Automation
Spreadsheet Automation 101 Lesson 2: Get Values - Introduction
Spreadsheet Automation 101 Lesson 2: Arrays
Spreadsheet Automation 101 Lesson 2: For Loop
Spreadsheet Automation 101 Lesson 2: Bracket Notation
Spreadsheet Automation 101 Lesson 2: Logger.log()
Spreadsheet Automation 101 Lesson 2: If ( ){ } and Checkboxes
Spreadsheet Automation 101 Lesson 2: onEdit() Trigger
Introduction to Spreadsheet Automation 101 Lesson 3
Spreadsheet Automation 101 Lesson 3: MailApp
Spreadsheet Automation 101 Lesson 3: Email Yourself For Loop
Spreadsheet Automation 101 Lesson 3: Send Email Every Week Trigger
Spreadsheet Automation 101 Lesson 3: Email Other People For Loop
Spreadsheet Automation 101 Lesson 4: Access APIs Introduction
Spreadsheet Automation 101 Lesson 4: UrlFetchApp
Spreadsheet Automation 101 Lesson 4: OmdbAPI get ApiKey, get Data in URL
Spreadsheet Automation 101 Lesson 4: OmdbAPI get data in Apps Script
Spreadsheet Automation 101 Lesson 4: JSON (beautifier) and OmdbAPI parameters
Spreadsheet Automation 101 Lesson 4: OmdbAPI Parameter Picker
Automatically Clear Content | Refresh Reuse Recycle Templates
Automate Google Sheets With Zero Experience
Automatically Uncheck A Daily Checklist
Activate A Certain Sheet When Opening a Spreadsheet
Scoping Functions in Apps Script