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