Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Automation with Apps Script
Introduction
001 Course Introduction
002 Access to the Course Q&A Group
003 Course Index
Apps Script Building Blocks
004 Overview of the Google Apps Script Ecosystem (20:31)
005 The New Apps Script IDE (December 2020) (10:53)
006 Solutions Gallery (11:02)
007 Adding Apps Script Files to Drive (1:08)
008 Understanding how Apps Script and Sheets work together (34:16)
009 Double Array Notation for Sheets Data in Apps Script (15:16)
010 Variables (32:34)
011 Operators (26:40)
012 Functions (31:22)
013 Arrays (21:30)
014 Objects (17:36)
015 JSON (23:22)
016 For Loop (7:29)
017 forEach Loop (16:26)
018 For In Loop (5:58)
019 Filter, Map and Reduce Loops (14:10)
020 Apps Script & Sheets Performance Considerations (29:32)
021 Errors (31:20)
022 Multiple Script Files (8:57)
Copying Data
023 Copying Data Setup and Append Row (25:24)
024 Adding a menu to Google Sheets (8:47)
025 Automate the process with a trigger (7:59)
026 Copying data to a different Google Sheet - Part I (29:44)
027 Copying data to a different Google Sheet - Part II (26:44)
028 Adding email confirmation (24:27)
Importing CSV Files
029 Import single CSV file into Google Sheets with Apps Script (21:25)
030 Importing CSV files from Drive folder (16:58)
031 Using User Prompts to request which file to import (14:14)
032 Automating CSV imports using triggers (20:54)
033 Importing CSV files from Gmail attachments (41:13)
Automated Survey Response Tool
034 Create Google Form & Automatically Send Email Replies (30:27)
035 Create Draft Email Replies (17:17)
036 Avoiding Duplicate Draft Emails (13:43)
037 Triggers I: Automatically Create Draft Emails (3:38)
038 Draft Emails Waiting Notification System (26:54)
039 Tracking Sent Emails (27:59)
040 Triggers II: Automatically Run Notification and Tracking Code (8:42)
041 Improving the Code (25:47)
Sheets to Calendar
042 Create Calendar Event from Sheet with dates (22:24)
043 Create all-day Events (27:23)
044 Create events with start and end times (30:51)
Introduction to APIs
045 API Introduction (24:30)
046 Numbers API (16:13)
047 Nasa API (36:17)
College Scorecard API
048 Introduction to the College Scorecard Data and API (4:56)
049 Getting API Key and Creating Authenticated API Connection (28:54)
050 Error Handling (21:03)
051 Changing the Query Parameters and Pasting Data into Google Sheet (30:10)
052 Pagination (49:00)
MailChimp API
053 Setting up the Basic Authentication (28:39)
054 Parsing the Data Returned by MailChimp (19:56)
PayPal API (OAuth Example)
055 OAuth 2 Protocol: Get Access Token (33:55)
056 OAuth 2 Protocol: Bearer Authorization REST API Call (15:34)
057 Retrieve PayPal Transaction Data (21:19)
058 Send PayPal Transaction Data into Google Sheet (26:35)
Facebook API (OAuth example)
059 Introduction to the OAuth Library and Facebook API (14:58)
060 Setting up the Authentication (24:03)
061 Handling the callback (17:06)
062 Getting data back from the Facebook API (25:32)
Automated Document Generator
063 Introduction to the Template Generator (8:03)
064 Introduction to HTML and CSS
065 Creating a Sidebar (13:23)
066 Adding CSS Styling the Sidebar (11:50)
067 Templated HTML and Scriptlets (15:58)
068 Adding a Form to the Sidebar (28:00)
069 Automatically Generate Copy of the Google Sheet Template (19:10)
070 Automatically Create New Folder for Template Docs (6:45)
071 Creating a Draft Contract with Google Docs and adding a Checkbox to the Sidebar (39:44)
072 Add More Input Fields to Sidebar (30:09)
073 Adding a Date to the Contract (19:16)
074 Making It All Look Professional (9:10)
075 Success and Failure Handlers (37:37)
Closing
076 Potential Project Expansions
077 Congratulations!
069 Automatically Generate Copy of the Google Sheet Template
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock