Hey there stranger!

Sign up to get access.

Introduction to Spreadsheet Automation 101 Lesson 3

About this Tutorial

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.

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.

Courses

Spreadsheet Automation 101: Introduction to Pre-course Videos

Think Like a Programmer: Develop The Mindset of an Apps Script Coder

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