Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Introduction To Google Apps Script
Introduction
An introduction to Apps Script and this course (3:10)
Templates & Helpful Hints
November 2021 Update - Please Read!
Macros: Our Path into the Apps Script world (12:40)
Troubleshooting permissions!
The Apps Script Environment & Hello World (15:46)
Custom Functions (11:38)
Fundamentals of Apps Script
Variables and Data Types (19:56)
Operators and Conditionals (13:55)
Functions (16:13)
Arrays (10:35)
Objects (11:32)
Loops (20:57)
Apps Script + Google Sheets
The Spreadsheet Service and getting data out of Sheets (19:49)
Working with data from Sheets (10:02)
Inserting Data Back Into Sheets (10:15)
Adding custom menus to run programs (3:29)
Adding formulas with Apps Script (8:09)
Formatting data in Google Sheets with Apps Script (7:52)
Automatically adding charts with Apps Script (15:20)
Project
Project: Introduction (9:10)
Project: Setting up the Google Form (4:13)
Project: Connect to Google Forms with Apps Script (9:53)
Project: Passing data from Sheets into Forms (14:42)
Project: Automatically sending emails with Apps Script (18:39)
Project: Enhanced emails with Apps Script (19:36)
Project: Automatically updating Google Forms Part 1 (13:37)
Project: Automatically updating Google Forms Part 2 (18:30)
Project: Add Triggers (5:10)
Conclusion
A small ask from me...
Well Done and Next Steps
Working with data from Sheets
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock