Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Automation with Apps Script
Introduction
Course Introduction
Access to the Course Q&A Group
Course Index
Apps Script Building Blocks
Overview of the Google Apps Script Ecosystem (20:31)
The New Apps Script IDE (December 2020) (10:53)
Solutions Gallery (11:02)
Adding Apps Script Files to Drive (1:08)
Understanding how Apps Script and Sheets work together (34:16)
Double Array Notation for Sheets Data in Apps Script (15:16)
Variables (32:34)
Operators (26:40)
Functions (31:22)
Arrays (21:30)
Objects (17:36)
JSON (23:22)
For Loop (7:29)
forEach Loop (16:26)
For In Loop (5:58)
Filter, Map and Reduce Loops (14:10)
Apps Script & Sheets Performance Considerations (29:32)
Errors (31:20)
Multiple Script Files (8:57)
Copying Data
Copying Data Setup and Append Row (25:24)
Adding a menu to Google Sheets (8:47)
Automate the process with a trigger (7:59)
Copying data to a different Google Sheet - Part I (29:44)
Copying data to a different Google Sheet - Part II (26:44)
Adding email confirmation (24:27)
Importing CSV Files
Import single CSV file into Google Sheets with Apps Script (11:39)
Importing CSV files from Drive folder (7:57)
Using User Prompts to request which file to import (4:33)
Automating CSV imports using triggers (9:37)
Importing CSV files from Gmail attachments (15:50)
Automated Survey Response Tool
Create Google Form & Automatically Send Email Replies (30:27)
Create Draft Email Replies (17:17)
Avoiding Duplicate Draft Emails (13:43)
Triggers I: Automatically Create Draft Emails (3:38)
Draft Emails Waiting Notification System (26:54)
Tracking Sent Emails (27:59)
Triggers II: Automatically Run Notification and Tracking Code (8:42)
Improving the Code (25:47)
Sheets to Calendar
Create Calendar Event from Sheet with dates (22:24)
Create all-day Events (27:23)
Create events with start and end times (30:51)
Introduction to APIs
API Introduction (24:30)
Numbers API (16:13)
Nasa API (36:17)
College Scorecard API
Introduction to the College Scorecard Data and API (4:56)
Getting API Key and Creating Authenticated API Connection (28:54)
Error Handling (21:03)
Changing the Query Parameters and Pasting Data into Google Sheet (30:10)
Pagination (49:00)
MailChimp API
Setting up the Basic Authentication (13:15)
Parsing the Data Returned by MailChimp (11:51)
PayPal API (OAuth Example)
OAuth 2 Protocol: Get Access Token (15:44)
OAuth 2 Protocol: Bearer Authorization REST API Call (7:23)
Retrieve PayPal Transaction Data (7:27)
Send PayPal Transaction Data into Google Sheet (12:14)
Facebook API (OAuth example)
Introduction to the OAuth Library and Facebook API (9:22)
Setting up the Authentication (14:45)
Handling the callback (6:14)
Getting data back from the Facebook API (14:36)
Automated Document Generator
Introduction to the Template Generator (4:26)
Introduction to HTML and CSS
Creating a Sidebar (5:31)
Adding Buttons and Styling the Sidebar (6:09)
Templated HTML and Scriptlets (6:57)
Adding a Form to the Sidebar (12:42)
Automatically Generate Copy of the Google Sheet Template (9:20)
Automatically Create New Folder for Template Docs (2:42)
Creating a Draft Contract with Google Docs and adding a Checkbox to the Sidebar (17:02)
Add More Input Fields to Sidebar (15:06)
Adding a Date to the Contract (8:01)
Making It All Look Professional (3:40)
Success and Failure Handlers (19:15)
Closing
Potential Project Expansions
Congratulations!
Adding a Date to the Contract
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock