This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Apps Script 101
Welcome
Meet the instructor (1:42)
Course Objectives (2:02)
What is Apps Script? (0:56)
Tips for Success (4:42)
PART 1: Building Blocks of Programming
Opening an Apps Script file (3:54)
Data Types (Numbers, Strings, and Booleans) & Variables (11:19)
Functions (18:38)
Codelab 1: Temperature Conversion Function [Prompt] (5:06)
Codelab 1: Temperature Conversion Function [Solution] (7:25)
PART 1 Recap (1:13)
PART 2: Build an Email-from-Spreadsheet App
Apps Script Developer Resources & SpreadsheetApp (16:53)
Grabbing Data From the Spreadsheet (and Checking Our Work) (8:54)
Codelab 2: Grab Data From the Spreadsheet [Prompt] (2:19)
Codelab 2: Grab Data From the Spreadsheet [Solution] (3:16)
Introducing GmailApp (4:18)
Sending Our First Email(!) (5:43)
PART 2 Recap (5:39)
PART 3: Build a USEFUL, automated email-from-spreadsheet App
Sending a batch of unique emails (using a For Loop) (15:33)
Sending a dynamic number of emails (using GetLastRow) (6:35)
Keeping track of who has been emailed (using SetValue) (6:43)
Not sending repeat emails (using an If Statement) (9:40)
Sending emails on auto-pilot (using Triggers) (3:18)
PART 3 Recap (0:45)
Wrap up
Course recap (4:28)
Your feedback (0:41)
BONUS CONTENT
Arrays - Update our auto-emailer with arrays
Spreadsheets - Dynamically look up column numbers based on headers
Spreadsheet - Create menus for non-technical users
Drive - Generate customized PDFs from templates
Calendar - Color-code based on event details
Calendar - Remove recurring events
Forms - Add responses to multiple-choice options
Codelab 2: Grab Data From the Spreadsheet [Solution]
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock