The Complete Google Apps Script Course: Build 16 Project Sites for $16

Business Integration Made Easy! Explore the Fundamentals of Google Scripting & Build Amazing G-Suite Apps with 21 Hours of Content

The Complete Google Apps Script 2020: Build 16 Project Sites for $16 Course - Product Image

Get $1 credit for every $25 spent!

$16 ~~$200~~ 92% off wishlist

by Laurence Svekis

Add to Cart

Add to Cart ($16)

Instructor

Laurence Svekis

Lessons

233

Ending In:

Certification Included

access

Lifetime

content

21.0 Hours

Description

Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with G Suite. This course gives you an introduction to Google Apps Script. Find out how it works, get a quick refresher on JavaScript fundamentals like variables, arrays, objects, loops, functions, and conditions. Try it out and see with just a few lines of code how you can create a doc, spreadsheet access the Google Calendar add events and send emails with Script. This course comes with 16 projects that you need to build while you learn.

Access 233 lectures & 21 hours of content 24/7
Build amazing web apps
Connect to your Google Spreadsheet as a source of data for your website
Emails users with the power of Gmail
Track users in a spreadsheet
Get messages from users right into a spreadsheet
Share content of your drive

Projects

Form Submission auto response
YouTube API - Connect to YouTube
Spreadsheet User data Project
Spreadsheet Mini Projects
Spreadsheet Data as API JSON
GDrive Image Gallery
HTML5 Canvas image uploade
HTML editor saving HTML files

Simple Auto Response
PDF Uploader
GmailApp
WebApp Sheet Data as API
Consent Form Exercise - JavaScript Cloud
Google Sheets as JSON data source for JS
Build a team site on sites
Simple Google Sheet input

Instructor

Providing Web development courses and digital marketing strategy courses since 2002. Laurence Svekis is an innovative technology expert with a wide range of real-world experience providing smart digital solutions online for both small and enterprise level businesses.

Important Details

Length of time users can access this course: lifetime
Access options: web & mobile streaming
Certification of completion included
Redemption deadline: redeem your code within 30 days of purchase
Updates included
Experience level required: all levels

Requirements

Any device with basic specifications

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

Course Outline

Your First Program
Preview
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

View Full Curriculum