Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Google Apps Script 2020 Build Fun Projects Sites GSuite
Getting started with Google Apps Script Projects Course
Introduction Google Scripts Projects (3:44)
Introduction to Google Apps Script
Start Google Apps Script (1:19)
0 Google Apps Script Introduction (2:35)
1 Getting Started with Apps Script (3:51)
2 Apps Script Editor (7:24)
3 Create a Document (6:38)
4 Create a Spreadsheet (4:34)
5 JavaScript in Apps Script Variables (5:19)
6 JavaScript in Apps Script Arrays (6:06)
7 JavaScript in Apps Script Objects (4:42)
8 JavaScript in Apps Script Functions (3:41)
9 JavaScript in Apps Script Conditions (3:31)
10 JavaScript in Apps Script Loops (2:46)
11 Apps Script Coding (3:18)
12 Create a Web App (5:54)
13 Google Apps Script Email (4:31)
14 Google Apps Script Calendar (3:27)
15 Google Apps Script Drive (6:56)
16 Google Apps Script Conclusion2 (2:25)
Form Submission auto response with Google Sheets and Apps Script
0 Introduction Google Scripts (3:29)
1 Google Forms Setup (4:59)
2 Send Email via Script (9:03)
3 Setup Trigger v2 (7:05)
4 Copy to another Sheet (8:55)
5 Copy content on Submit (4:33)
6 Sheet data sorter (4:38)
7 Check Sheet Data for Value (7:17)
8 Quick Fixes and Updates (2:13)
9 Update Spreadsheet UI (3:58)
10 Conclusion Spreadsheet Data (3:59)
Advanced Services YouTube API made easy with Google Apps Script
0 Introduction youTube Project (2:47)
1 Project Setup Google Apps Script (3:27)
2 Search YouTube (3:44)
3 Use Data Results From Search (3:54)
4 Create a Web App (5:34)
5 Create HTML index page (6:58)
6 Get Data from Google Script (3:47)
7 Output Results to HTML Page (4:14)
8 Output Results to HTML Page 2 (6:19)
9 Output Results to HTML Page 3 (2:46)
10 Add to Spreadsheet (5:05)
11 Code Review youTube Project (5:09)
Spreadsheet UI email functionality
0 Email from Spreadsheet Introduction (4:38)
1 Google Apps Script Bound Script (2:25)
2 Start Scripting (6:59)
3 Get Values from Spreadsheet (3:51)
4 Create User Object (4:51)
5 Alert UI Buttons Yes No (3:52)
6 HTML Template (4:42)
7 Send Email Message (3:12)
8 Update Spreadsheet column (4:43)
9 Final Code Review (5:01)
Fun with Spreadsheet series of mini projects that are useful for many projects
0 SpreadsheetApp Introduction (2:45)
1 Bound Script Starter Lesson (5:11)
2 Add More Content to Spreadsheet (10:50)
3 Spreadsheet Formulas (5:29)
4 Update Sheet Content (7:17)
5 Spreadsheet UI (4:44)
6 Finder and Replace Content (5:23)
7 Finder and Replace Content 2 (9:52)
8 Get Cell Values (7:15)
9 Get Content as HTML (8:11)
10 Email Spreadsheet HTML table (3:32)
11 Copy Spreadsheet as PDF (5:33)
12 Copy Spreadsheet as PDF 2 (5:48)
13 Copy Spreadsheet as PDF 3 (3:41)
14 Content Copy (5:23)
15 Search Drive Files (2:58)
16 Search Drive Files 2 (5:48)
v17 Value Checker if Exists (6:29)
18 Course Conclusion Code Review (7:49)
API Data From Spreadsheet
0 Google Get Post Web API Introduction (3:00)
1 Web Developer Setup (5:02)
2 Write Google Apps Script (3:38)
3 Get Spreadsheet Data (5:59)
4 Web App Content (5:29)
5 Connect to WebApp URL (5:15)
6 Post Data to Sheet (7:07)
7 WebApp POST (3:23)
8 Add POST to Spreadsheet (5:25)
9 DeBug and Clean Web App (5:19)
10 Application Conclusion Code review (5:28)
Google Drive Image Gallery
0 Introduction Image Gallery (2:26)
1 Web Application Setup (5:58)
2 Google Script Web App (5:36)
3 Get Drive Images (9:14)
4 Connect to WebApp JSON (4:22)
5 Create Page Elements (3:10)
6backup JavaScript Popup Image Modal Part 2 (6:56)
7 JavaScript Popup Image Modal Part 2 (3:53)
8 Code Review Image Gallery (8:09)
Google Apps Script Make Images HTML5 Canvas save to Gdrive
0 Image Uploader Project Introduction (2:56)
1 Google Apps Script Web App (4:25)
2 Images as base64 (6:52)
3 Base64 image client side (7:06)
4 Client Side Options (4:27)
5 Client Side JavaScript (7:11)
6 Add Text to Canvas (5:00)
7 Add Logo to Canvas (2:37)
8 Upload Image to Canvas (6:46)
9 Save Canvas Image to gDrive (4:17)
10 Google Apps Script Save Image (7:27)
11 Final Tweaks and Updates (5:20)
12 Image Uploader Project Conclusion (6:55)
Google Apps Script WYSIWYG editor and email HTML maker
0 HTML Editor Introduction (4:04)
1 WYSIWYG Project Setup (4:25)
2 Create a Apps Script Web App (4:48)
3 Output File in Web App (3:19)
4 Client Side Coding Project (4:45)
5 Client Side Request Values (3:56)
6 Create Editor on Client Side (4:43)
7 Client Side Options Setup (5:08)
8 Add Button Events (4:19)
9 Add Button Events 2 (2:42)
10 Save HTML as file to gDrive 1 (5:02)
11 Save HTML as file to gDrive 2 (7:10)
12 Save HTML as file to gDrive 3 (4:59)
13 Load File Names as options (3:29)
14 Existing Files Options (4:25)
15 Load File Contents HTML (4:18)
16 Add File Names (7:59)
17 Create as PDF File (7:54)
18 Send HTML Email (5:03)
19 Final Project Conclusion Editor R (11:13)
20 Load File By ID into Editor R (7:18)
Google Apps Script Form Submission Send Email
0 Course Introduction (4:32)
1 Google Script Setup (5:06)
2 Create Form (3:33)
3 Google Apps Script (4:25)
4 Setup Form Trigger (6:02)
5 On Form Submit (4:47)
6 Send Email (8:00)
7 Object Send Email (6:08)
8 Final Tweaks and Testing (6:26)
Google Apps Script PDF uploader Project
0 PDF Uploader Project Section (3:03)
1 Getting started with Apps Script (3:41)
2 Create a simple Script (6:14)
3 Spreadsheet App (11:59)
4 Update Spreadsheet content (4:52)
5 Get Content from Spreadsheet (7:52)
6 Add Content to Spreadsheet (7:23)
7 Spreadsheet content (4:57)
8 Create Web App (6:00)
9 Templated HTML webApp (7:33)
10 Sheet Values on Client Side (8:29)
11 Upload PDF to Drive (8:36)
12 Upload PDF to Drive 2 (9:56)
13 Upload PDF to Drive 3 (7:30)
14 Project Review Conclusion (10:33)
Google Sites
Quick Start Google Sites (0:57)
0 Google Sites Introduction (3:42)
1 Introduction to Google Sites (2:29)
2 Getting Started with Sites (4:21)
3 Looks and Feel Themes (4:02)
4 Page Layouts (4:26)
5 Add more Pages (6:14)
6 Publish Site (2:47)
7 Delete Restore Site (2:39)
8 Add Images, Files and Scripts (5:40)
9 Add Google Script Web App (4:23)
10 More Content Options2 (5:00)
11 Google Sites Conclusion (2:49)
Gmail App Class Get Email Threads Email Image Project
0 Image Gmail to Drive Project Introduction section (1:51)
1 Get inbox threads (5:14)
2 View GmailThread Info (7:33)
3 check for attachments (7:49)
4 Copy Image To GDrive (5:02)
5 Move Emails Add Labels (5:34)
6 Get Active User (2:28)
7 Move Image to Folder Project 1 (6:37)
8 = Move Image to Folder Project 2 (8:57)
9 Code Review and Conclusion (5:20)
WebApp Sheet data as API
0 Sheet Data as JSON API Introduction (3:17)
1 Create Google Script (3:52)
2 Use HtmlService createHtmlOutput (8:26)
3 parameters in the URL (6:28)
4 Client side - Server Side Code (5:31)
5 Output from a file (8:30)
6 Spreadsheet Data (8:21)
7 Spreadsheet Data 2 (2:33)
8 Data as JSON Output (5:09)
9 SheetData as JSON Output (2:37)
10 WebPage Connection Fetch (6:10)
11 Request parameters (3:18)
12 Request parameters 2 (4:52)
13 Sheet Data as JSON API Conclusion (1:19)
Google Apps Script Consent Form Exercise - JavaScript Cloud
Introduction Google Apps Script Consent Form Exercise (2:30)
1 Setup Google Script (4:23)
2 Developer Environment (11:44)
3 HtmlService Output HTML (6:15)
4 HtmlService Try and Catch (2:34)
5 HTML form submission to GS (9:16)
6 Google Script RUN (5:19)
7 SpreadSheet App add data (10:06)
8 Send and Email with PDF of Doc (10:28)
9 Add to Sites (4:59)
10 Source Code Overview (6:18)
Google Sheets as JSON data source for JavaScript
0 Spreadsheet as JSON introduction (2:07)
1 SpreadSheet Setup (4:33)
2 Google SpreadSheet as JSON (5:12)
3 JavaScript Fetch JSON (5:48)
4 Get JSON Promiseall JavaScript Example (9:59)
5 Code explained JavaScript Map (8:15)
6 Code explained JavaScript Promise All (5:59)
7 Spreadsheet Data Clean Up JSON (10:58)
8 Build the object using Sheet name (4:20)
9 Output Sheet data to HTML (5:03)
Google Apps Script - Project Exercise Spreadsheet web app Team Site on Sites
0 Team Site Introduction (2:21)
0 Google Script Google Sites Project2 (3:07)
1 Google Apps Script Introduction (4:02)
2 Google Apps Script Create First Script (5:50)
3 Run your Script make things Happen (10:23)
4 Output HTML Create webapp (5:31)
5 Create Index page as HTML (7:29)
6 Get user Session Email (1:24)
7 Build Client Side Code JavaScript (5:30)
8 Get Spreadsheet content to client side (8:40)
9 JavaScript Build Post Output (4:15)
10 Build Output Items (4:10)
11 Bring web app into Google Sites (6:32)
12 Submit a new post to Spreadsheet (6:25)
13 Send Data to Google Script (8:58)
14 Google Script Sort Column Data (5:01)
15 Detect URL parameter Page number (5:51)
16 Add Pagination Pages for posts2 (8:32)
17 Add Pagination Pages part 2 (6:19)
18 Add Pagination Pages part 3-2 (11:30)
19 Application Tweaks (3:43)
20 Remove Record from Spreadsheet (7:23)
21 Update Spreadsheet data remove row (6:28)
22 Date Sort Bug Fixes (3:23)
23 Style and Updated View Content (7:50)
24 Final Tweaks (6:47)
Introduction Google Scripts Projects