Get $1 credit for every $25 spent!

The Increase Your Google App Productivity with Google Script Bundle

Ending In:
Add to Cart - $34.99
Add to Cart ($34.99)
$1,400
97% off
wishlist
Courses
7
Lessons
646
Enrolled
108

What's Included

Product Details

Access
Lifetime
Content
21.0 hours
Lessons
233

Google Apps Script 2020: Build 16+ Fun Projects Sites GSuite

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

By Laurence Svekis | in Online Courses

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.

1,082 positive reviews from 7,640 students enrolled

  • 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: JS Cloud
  • Google Sheets, JSON data source for JS
  • Build a team site on sites
  • Simple Google Sheet input

"I am very pleased with this course, it has great real-life examples. The teacher explained it all in depth and it is easy to follow. Thanks Laurence!" – Ivan Josipovic

Laurence Svekis | Instructor, Google Development Expert, Application Developer

4.3/5 Instructor Rating: ★ ★ ★ ★

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.

581,302 Total Students

33,520 Reviews

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

Course Outline

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


Access
Lifetime
Content
1.0 hours
Lessons
12

Google Apps Script: Set Up Simple Twitter Posting Bot

Use Google Spreadsheet Content to Post Automatically to Your Twitter Account — Source Code Included

By Laurence Svekis | in Online Courses

If you use social media for brand marketing, this course is for you. Explore how you can connect your Twitter Account using Google Apps Script and automate posts coming from your Spreadsheet data. All of the source code is included as well as 12 step-by-step lessons to help you learn about the code being used and illustrate what it does. By the end of this course, you'll be able to automate Twitter posting and simplify marketing.

1,331+ students enrolled

  • Access 12 lectures & 1 hour of content 24/7
  • Create a Spreadsheet & add script
  • Set up an app as a Twitter Developer, create the app & get secret keys and tokens to automate Twitter interactions
  • Access Google Apps Script Developer Code Editor & write Google Script
  • Know which library to use & how to add libraries of existing code to your Google Apps Script
  • Create Conditions to setup content for Tweet
  • Set up Triggers to automate application & script to run at set times
Note: Source Code is Included

Laurence Svekis | Instructor, Google Development Expert, Application Developer

4.3/5 Instructor Rating: ★ ★ ★ ★

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.

581,302 Total Students

33,520 Reviews

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

  • JavaScript and some developer experience
  • Google Account
  • Twitter Developer Account
  • Twitter account

Course Outline

  • Introduction to creating a Twitter posting application
    • 0 TwitterBot Introduction - 4:10
    • Source Code
    • 1 Setup Google Sheet - 6:04
    • 2 Setup Spreadsheet Twitter Keys - 4:56
    • 3 Start Coding - 7:33
    • 4 Add twitter Library - 2:27
    • 5 Search Tweets - 5:42
    • 6 Send Post Tweet - 4:22
    • 7 Setup Spreadsheet sorter - 5:26
    • 8 Setup Spreadsheet create Tweet - 5:42
    • 9 TweetBot Ready - 4:55
    • 10 Setup Triggers Conclusion - 4:42

View Full Curriculum


Access
Lifetime
Content
12.0 hours
Lessons
119

Google Apps Script Complete Course: Beginner to Advanced

Connect, Automate & Add Advanced Functionality — Power Up Your Google Suite of Products Using App Scripts

By Laurence Svekis | in Online Courses

Apps Script lets you do more with Google and that's what this course is all about. Increase the power of your favorite Google apps — like Calendar, Docs, Drive, Gmail, Sheets, and Slides. This course covers every step to get started with Google Scripts including an overview of the editor and what it does and how to use it. Followed by more detailed syntax and code examples of applying Google Script in real-world projects. Automate, add functionality, use spreadsheet data, create documents, interact with emails, generate reports, use data the list is endless on all the amazing things you can do with Google Apps Script. Warning once you start using Google Apps Script you may want to use it for everything!

1,097 positive reviews from 7,674 students enrolled

  • Access 119 lectures & 12 hours of content 24/7
  • Learn about selection of data & construction of content
  • Use Spreadsheet UI for added interactions w/ users
  • Design sites interface w/ options to create pages & more

"He has also done a good job at moving slowly and not assuming certain information was already known by me as the student." – Tim Pedersen

"Laurence does a great job with breaking down how to do great things within Google Apps Script" – Cordelle Griffin

Laurence Svekis | Instructor, Google Development Expert, Application Developer

4.3/5 Instructor Rating: ★ ★ ★ ★

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.

581,302 Total Students

33,520 Reviews

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

  • JavaScript & basic HTML and CSS knowledge
  • Google Account
  • Basic Web development understanding
  • JavaScript knowledge

Course Outline

  • Introduction to using Google Script
    • 00 Google Scripts Course Introduction - 6:23
    • 2 Apps Script Power Example - 7:00
    • 1 Quick Start to Google Apps Script - 4:14
    • 3 IDE Integrated Development Environment - 10:44
    • 4 First Script - 8:43
    • 5 Google Script Classes - 13:09
    • 5-1 JavaScript Refresher - 12:59
  • Google DocumentApp
    • 6 Explore Document - 5:18
    • 7 Get Document Contents - 4:39
    • 8 Document Body Contents - 3:51
    • 9 Document Body Updates - 6:54
    • 10 Document Body Children - 5:37
    • 11 Document Classes and Methods - 8:07
    • 12 Simple Copy Doc Script - 12:47
    • 13 DocumentApp Bound Script - 6:38
    • 14 Base Values within Script - 8:17
    • 15 HTML in Google Documents - 6:12
    • 16 Bound Content Interaction - 7:21
    • 17 Ranged elements in Document - 6:02
    • 18 Translate Selected Content - 3:25
    • 19 Search Content Replace With - 8:14
    • 20 Find Content Update Attributes - 8:47
    • 21 Content Selection Exercise - 14:45
    • 22 DocumentApp Exercise - 15:12
    • 23 DocumentApp Create Content - 17:02
    • 24 insert Image DocumentApp - 5:32
    • 25 DocumentApp Template Exercise - 4:13
  • Google Spreadsheet app
    • 26 StandAlone SpreadSheetApp - 3:04
    • 27 Creating Content and Styling - 7:16
    • 28 SpreadsheetApp Set Values - 7:16
    • 29 Spreadsheet data to Doc Table - 7:19
    • 30 Spreadsheet data dynamic - 4:10
    • 31 SpreadSheet Tracker Exercise - 7:07
    • 32 SpreadSheet Sheet Class - 6:09
    • 33 From one sheet to another - 10:47
    • 34 Bound Spreadsheet App - 3:18
    • 34-0 Google Sheets Functions - 5:10
    • 35 UI menu options Spreadsheet - 3:42
    • 36 Spreadsheet UI Sidebar Modal - 5:44
    • 37 Get Selected Content - 7:31
    • 38 Exercise Cell Selection Add to Sheet - 8:26
    • 39 Range to Another Sheet CopyTo - 4:55
    • 40 Selecting Cell Values Loops - 13:30
    • 41 Sidebar content HTML - 7:57
    • 42 More UI options - 4:18
    • 43 HTML to backend GS code - 7:52
    • 44 Google Sheet content to Client Side - 8:39
    • 45 Triggers OnEdit OnChange - 3:20
    • 45-1 Exercise Google SpreadsheetApp - 5:29
    • 45-2 Exercise Generate Random Content - 10:09
    • 45-3 Adding new Column - 6:36
    • 45-4 Add Formulas Set Colors - 7:04
    • 45-5 HTML modal to Spreadsheet - 3:46
    • 45-6 Sheet Data to HTML file - 7:51
    • 45-7 Get Sheet Data - 7:18
    • 45-8 Run Script Client Side - 7:01
    • 45-9 Response with Google Sheet Data - 9:52
  • Google Script Sites
    • 46 Introduction to Google Sites - 8:41
    • 47 New Google Sites - 7:41
    • 48 Publish Web App Google Script - 8:12
    • 49 Google Site Scripting - 5:45
    • 50 Google Script Web App html page - 4:39
  • Google Drive - DriveApp Class
    • 51 Google DriveApp Class - 3:49
    • 52 Select Folder By ID - 2:57
    • 53 Create Folder DriveApp - 7:13
    • 54 DriveApp create File - 4:20
    • 55 SpreadSheet with DriveApp Data - 9:53
    • 56 Create Doc and Move it - 7:21
    • 57 DriveApp Search - 9:38
    • 58 DriveApp Search Files - 2:44
    • 59 DriveApp searchFolders Params - 1:11
    • 60 Add editors and Delete - 12:52
    • 61 Redirect on search string - 10:03
    • 62 Exercise WebApp Redirector - 7:10
  • Google GmailApp
    • 63 Class GmailApp - 2:35
    • 64 Make Draft GmailApp - 4:46
    • 65 View your Draft Email - 5:11
    • 66 Use HTML Template email - 5:58
    • 67 Send out a bunch of Emails - 11:10
    • 68 Chat Threads GmailApp - 3:34
    • 69 Get Gmail Messages - 12:26
  • Calendar App Class
    • 70 Calendar App Service - 3:44
    • 71 Add Location Info Calendar App - 4:46
    • 72 Calendar Event with options - 5:33
    • 73 Full Day events Calendar App - 5:43
    • 74 Calendar App Event Series - 7:04
    • 75 Calendar App Date Time - 3:23
    • 76 Easy way to enter Events - 3:19
    • 77 More Calendars - 4:03
    • 78 Calendar Settings - 4:42
    • 79 Get All Calendars - 5:25
    • 80 Calendars By Name - 5:49
    • 81 Calendar Events - 2:52
    • 82 Calendar Events Explored - 5:05
    • 83 Calendar Events into spreadsheet - 7:59
    • 84 Google Calendar Events Invites No - 7:43
    • 85 Send Weekly Calendar Events - 18:52
    • 86 Review Google Script - 3:03
  • Exercise Google Script Image Uploader Project
    • 0 Apps Script Image Uploader - 2:03
    • 1 Google Script Apps Script - 3:59
    • 2 Quick JavaScript Overview - 4:50
    • 3 Apps Script Online Editor - 10:23
    • 4 HTML Content Service - 7:16
    • 5 HTML Content Template File - 3:50
    • 6 HTML Content from File - 8:47
    • 7 Create the HTML form - 4:44
    • 8 Send Data to Google Script Backend - 7:37
    • 9 Send Image to Google Script - 6:23
    • 10 Image upload Tweaks - 2:36
    • 11 Spreadsheet App tracking uploads - 4:34
    • 12 Send Email notification - 2:55
    • 13 Final Application Image Uploader - 5:50
    • 5 Source Code
    • 7 Source Code
    • 10 Source Code
    • 13 Source Code
    • 16 Source Code
    • 20 Source Code
    • 21 Source Code

View Full Curriculum


Access
Lifetime
Content
4.0 hours
Lessons
50

Google Apps Google Script: Content System Web App Project

Build a Custom Web Application Using Google Scripts & Connect Your Google Apps Together

By Laurence Svekis | in Online Courses

Increase the power of your favorite Google apps — like Calendar, Docs, Drive, Gmail, and Sheets. Apps Script lets you do more with Google...all on a JavaScript platform in the cloud. If you know JavaScript you can jump right in and start creating web apps connecting all of your Google applications together. Automate your work you will be amazed at how easy it is to work with Apps Script. This is a project-based course and the scope of the course is to use technologies like HTML, CSS, JavaScript, jQuery, Bootstrap to create the project. All of the source code is included.

4.3/5 rating from 5,710 students enrolled: ★ ★ ★ ★

  • Access 50 lectures & 4 hours of content 24/7
  • Create Google Docs with script
  • Send gmail emails with Google Script
  • Translate Google docs to different languages
  • Use Google sheets to store data & access data
  • Create web apps using Google Script

"Well paced and informative. The instructor covered the key items without getting bogged down in minute details. Enough information for the student to grasp and nowhere to look for help when experimenting." – Ged Mirski-Fitton

Laurence Svekis | Instructor, Google Development Expert, Application Developer

4.3/5 Instructor Rating: ★ ★ ★ ★

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.

581,302 Total Students

33,520 Reviews

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

  • JavaScript
  • HTML CSS
  • Google Account
  • jQuery
  • Bootstrap

Course Outline

  • Write Google Script to create and connect Google apps together
    • 1 Google Scripts Introduction - 8:51
    • 2 What is Google Scripts - 3:21
    • 3 Setup Google account open script editor - 3:36
    • 4 How to Create a Google Doc with Google Script - 9:28
    • 5 Access existing document and add content Google Script - 5:47
    • 6 Setup Triggers Run script using Google Script - 3:55
    • 7 Run method to copy current content and output as bold Google Script Doc - 8:29
    • 8 Change text attributes output different colors Google Scripts - 7:38
    • 9 Link more google services into your Script + Use JavaScript Methods - 4:42
    • 10 Google Scripts Send Email - 8:06
    • 11 Source Code
    • 12 Resources
    • 13 Use Google Sheets as a webapp with Data - 3:43
    • 14 Google Sheet data into local application jQuery - 10:42
    • 15 Resources
    • 16 OnOpen Setup default buttons Google Script - 4:55
    • 17 Get Sheet values into object - 6:34
    • 18 Output data from spreadsheet - 4:02
    • 19 Source Code Output
    • 20 Popup HTML file within Google Sheet - 4:31
    • 21 Pass data Object to HTML page Google Script - 8:58
    • 22 Pass Sheet data as object array into HTML page Google Script - 5:27
    • 23 output content from sheet get each value - 5:06
    • 24 Source Code
    • 25 Deploy as Web App - 6:02
    • 26 GS source Code
    • 27 HTML Source Code
    • 28 Custom portal setup Google Scripts - 3:18
    • 29 Create Alert with prompt response shown in sidemenu - 5:55
    • 30 Source Code Sidemenu
    • 31 Setup testing popup modal with content Google Script - 6:49
    • 32 Setup user portal entry page - 9:18
    • 33 Dynamic Drop down content from Google Sheet - 10:10
    • 34 Pass Google Sheet data to Frontend Google Script - 5:39
    • 35 Generate home page content from google sheet data - 6:14
    • 36 Send data to Google Script for processing - 6:02
    • 37 Generate Page Content Google Sheet - 7:29
    • 38 Project Source Code
    • 39 HTML source Code
    • 40 Callback webpage builder - 10:44
    • 41 Bug Fix and Tweak output pages - 2:39
    • 42 Return row contents using Google Script - 8:20
    • 43 Add in validation check for email addresses - 9:34
    • 44 Tweaks and Bug Fixes Google Script - 8:53
    • 45 Deploy as webapp Google Script Application - 8:58
    • 46 Code review Index - 5:18
    • 47 Source Code
    • 48 Code Review Code Google Script - 8:30
    • 49 Source Code GS
    • 50 Resources

View Full Curriculum


Access
Lifetime
Content
15.0 hours
Lessons
187

Google Apps Script Projects

Create Mini Web Applications Using Google Apps Script Collection of Projects

By Laurence Svekis | in Online Courses

Do you want to connect Google Apps Together and make some really amazing things happen? This course will provide you the foundation to work with Google Script to build a Web App that can be embedded in Google Sites. Within the course, you'll learn how to use Google Spreadsheet as a source for retrieving and storing data. Power up what you do online, bringing together built-in functionality in your Google Suite. Source Code is included so you can build the same app in the course but even better!

4.1/5 rating from 2,829 students enrolled: ★ ★ ★ ★

  • Access 187 lectures & 15 hours of content 24/7
  • Learn the basics of Google Script - how to use the online editor & overview of functionality
  • Create a bound script to your Google Sheet
  • Use HTTP service to output & HTML file within Google Web apps
  • Use JavaScript within Google Apps & Google client side pages
  • Setup a Google site & embed your Google script

"So far so good. Very useful. Pacing is good. Lots of small working bits." – Dennis Daniels

Laurence Svekis | Instructor, Google Development Expert, Application Developer

4.3/5 Instructor Rating: ★ ★ ★ ★

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.

581,302 Total Students

33,520 Reviews

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

  • Computer with internet access
  • Google Account
  • JavaScript Knowledge

Course Outline

  • Google Apps Script for Beginners- Amazing Things with Code
    • 0 Google Apps Script Introduction - 4:42
    • Resource Guide
    • 1 Marcos for Script - 5:19
    • 2 More fun with Marcos - 3:55
    • 3 Google Apps Script Scripting - 1:57
    • 4 Create Standalone Script - 11:12
    • 5 Get by ID Document - 5:24
    • 6 Document Service - 3:59
    • 7 JavaScript in Apps Script - 5:30
    • 8 JavaScript Arrays - 5:26
    • 9 Google Sheets AppendRow - 4:31
    • 10 JavaScript Objects - 3:43
    • 11 JavaScript Functions - 3:49
    • 12 JavaScript Conditions - 2:54
    • 13 JavaScript Loops - 3:31
    • 14 IDE Online Editor - 3:07
    • 15 IDE edit tab - 5:18
    • 16 IDE view tab - 1:47
    • 17 IDE Run - 1:46
    • 18 Publish Tab - 6:51
    • 19 Web App Dynamic Code - 2:45
    • 20 Editor Resources and Help - 2:16
    • 21 Document Service - 4:17
    • 22 Dialogs and custom UI buttons - 8:34
    • 23 Document as PDF - 8:00
    • 24 Spreadsheet Data - 4:27
    • 25 Add new sheet - 6:28
    • 26 Copy Content in Sheet - 4:34
    • 27 Calendar Data to Spreadsheet - 10:08
    • 28 Google Apps Script Conclusion - 5:00
  • Google Script Create Google Docs on the fly from templates
    • 1 Introduction to Google Scripts - 7:41
    • 2 Make Google Folders and Files - 3:29
    • 3 Setup Files and Headings - 4:17
    • 4 Create menu items to launch functions - 7:13
    • 5 Source Code for GS
    • 6 Create HTML Popup Dialog Window - 8:22
    • 7 Source Code to Get HTML file contents
    • 8 Build HTML frontend - 6:40
    • 9 List gDrive files - 8:24
    • 10 source code
    • 11 List Google Drive Contents into Google Spreadsheet - 11:04
    • 12 source code
    • 13 Read Document Content use body content in Google Script - 12:00
    • 14 Use Google Script Get Spreadsheet data and return as an array - 6:23
    • 15 source code
    • 16 create dynamic select list - 5:16
    • 17 Use Data to generate fields for input to template - 9:19
    • 18 picker source code
    • 19 Get form input values - 7:16
    • 20 Pass Data to Google Script from html - 6:25
    • 21 Source Code
    • 22 GS Source Code
    • 23 Planning to create doc into folder - 6:07
    • 24 Copy document into drive folder - 7:25
    • 25 Generate Doc from a template doc - 8:36
    • 26 HTML script tweaks and styling - 8:22
    • 27 Source Code
    • 28 Google Script Tweak - 3:16
    • 29 GS Source Code
    • 30 App testing and conclusion - 4:39
    • 31 Resources
  • Google Script How to Update Google Sheet data from a web App
    • 1 Introduction to Google App Script and Google Sheets - 3:22
    • 2 setup Google Script - 4:56
    • 3 Write your first Google Script - 8:41
    • 4 Create dialog and webapp of Google script output - 7:31
    • 5 Source Code
    • 6 html output append and update styling with Bootstrap - 4:50
    • 7 Coding exercise add UI item render HTML - 4:57
    • 8 Source Code Exercise
    • 9 Output content from spreadsheet - 6:44
    • 10 Project Source Code
    • 11 Output Sheet content as Data - 5:45
    • 12 Project Source Code
    • 13 Loop data output array as HTML - 6:24
    • 14 Sheet data in HTML table with inputs - 8:01
    • 15 data passing using jQuery from element - 6:43
    • 16 Class google.script.run (Client-side API) - 4:55
    • 17 Update Google Spreadsheet fron HTML - 7:29
    • 18 Launch Webapp - 4:18
    • 19 Styling Tweaks - 2:53
    • 20 Source Code review - 9:26
    • 21 Source Code GS
    • 22 Google Sheet html
  • Google Sheet Data API JSON AJAX
    • 0 Google Sheet Data API - 2:48
    • 1 Setup Sheet Data - 5:28
    • 2 Get Sheet Data - 5:42
    • 3 Output Sheet Data - 6:38
    • 4 Google Scripting - 8:36
    • 4 Source Code
    • 5 Use Google Script to Create Output - 15:36
    • 6 JSON feed from Google Sheets - 6:07
    • 6 Source Code
    • 7 Google Script POST data - 12:02
    • 8 Form Setup to Post - 4:22
    • 9 Post data to Google Sheets - 5:58
    • 9 Source Code
    • 10 Random User Data API - 6:30
    • 11 Project Overview and Review - 8:25
    • 11 Source Code
    • 12 Source Code
    • 18 Source Code
    • 19 Source Code
  • Google Sites - Getting started Guide to Quick Websites
    • 0 Course Google Site Introduction - 2:58
    • 1 Google Sites Setup - 2:41
    • 2 Create Your Site - 3:46
    • 3 Update the Look of your site - 5:06
    • 4 Create More Pages - 6:17
    • 5 Add content to your page - 9:18
    • 6 Review and Share Content - 3:22
    • 7 Embed Power up Your Sites - 8:37
    • 8 Advanced Options - 6:46
    • 9 Google Apps Scripts - 7:46
  • Apps Script Form Data Handler Exercise Google Form Sheet
    • 1 Setup Google Form - 6:36
    • 2 Spreadsheet Bound Script - 3:44
    • 3 Setup Project triggers - 5:02
    • 4 Setup Email to Send - 4:14
    • 5 MailApp Send Email - 4:15
    • 6 Email HTML template - 5:58
    • 7 HTML Service replace content - 3:31
    • 8 HTML to PDF and Attach it - 5:16
    • 9 Send automatic emails - 5:26
    • 10 iterate Sheet Data Send Emails - 6:46
  • Google Script - DocumentApp for Beginners
    • 0 DocumentApp Introduction - 2:54
    • 1 Create a Document Open Script Editor - 2:03
    • 2 StandAlone Script Create Doc - 6:08
    • 3 Bound Script DocumentApp - 5:51
    • 4 onOpen UI menu maker - 5:27
    • 4 Source Code
    • 5 Update Doc Content - 4:02
    • 6 Adding Content Dynamically - 9:12
    • 6 Source Code
    • 7 DocumentApp insert Images - 6:38
    • 8 DocumentApp Add Tables - 5:39
    • 8 Source Code
    • 9 DocumentApp Get All Elements - 9:04
    • 10 DocumentApp Next Steps - 3:05
    • 10 Final source
  • JavaScript CSV file creator - Google sheet to CSV Project
    • 0 Google Sheet to CSV - 2:28
    • 1 Setup CSV Maker - 3:19
    • 2 Setup Data Values - 2:13
    • 3 Process CSV Data - 5:32
    • 4 Avoid Memory Leaks - 2:02
    • 5 Create CSV File - 1:46
    • 6 Export Fixer - 5:10
    • 7 Google Sheet Data - 7:04
    • 8 Fetch Data from JSON - 10:42
    • 9 Google Sheet to CSV - 10:05
  • Google Calendar Live feed to your website Google Apps Script
    • 0 Calendar Events Introduction - 3:10
    • 1 Introduction to Google Apps Script - 7:49
    • 2 Google Bound Script - 4:12
    • 3 Spreadsheet Service - 4:16
    • 4 Add Content to Sheet - 2:06
    • 5 Calendar Service - 4:21
    • 6 Populate Calendar - 7:05
    • 7 List Calendar Events - 7:48
    • 8 List Events Function - 4:25
    • 9 Add Events to Spreadsheet - 4:24
    • 10 Create a Trigger - 3:41
    • 11 Spreadsheet as JSON - 4:48
    • 12 JavaScript Fetch JSON - 10:43
    • 13 Spreadsheet on WebPage - 3:58
    • 14 Google Script WebApp - 8:24
    • 18 Delete Events - 2:28
    • 15 List Events in Web App - 2:21
    • 16 Get JSON Data - 3:37
    • 17 Google Calendar Events - 6:11
  • Google Apps Script - Project Management App Project
    • 0 Apps Script PM app introduction - 4:36
    • 1 Developer Environment Setup - 5:31
    • 2 Class UI - 5:09
    • 3 Create html page menu - 7:50
    • 4 More Menu Items - 2:21
    • 5 Menu Functions for App - 6:53
    • 6 Spreadsheet Data to client side - 6:25
    • 7 Submit to Spreadsheet - 6:09
    • 8 Populate Client side with tasks - 7:03
    • 9 Google Script Run Values - 6:03
    • 10 Form Client Side Inputs - 4:37
    • 11 Add Client Side data to spreadsheet - 8:58
    • 12 Update Sheet Data Cell - 3:17
    • 13 Test Data - 3:25
    • 14 Get existing Row Data - 7:23
    • 15 Update Row Data - 9:57
    • 16 Bug Fixs and User Message - 4:14
    • 17 Web App Gantt Chart - 5:18
    • 18 Output Sheet Content Gantt - 12:01
    • 19 Chart Options - 4:23
    • 20 Project Management Conclusion - 13:33

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
17

Google App – Gmail: Increase your Email Productivity

15+ Tips to Save Time & Be More Productive with Your Emails

By Laurence Svekis | in Online Courses

If you're handling business you probably have times when you almost drown in a bunch of emails that you haven't read. Not only does it take time to skim all of them, you'll also have to reply! This course will save you time and give you tips on how to better use Gmail and be more productive with your emails.

4.7/5 rating from 2,410 students enrolled: ★ ★ ★ ★

  • Access 17 lectures & 1 hour of content 24/7
  • Adjust settings for optimal use of Gmail account
  • Know Conversation View & Reply options for viewing of emails
  • Use Message Filter to automate grouping of emails as they come in
  • Learn about Custom Star options for organizing emails
  • Learn overall email productivity tips

Laurence Svekis | Instructor, Google Development Expert, Application Developer

4.3/5 Instructor Rating: ★ ★ ★ ★

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.

581,302 Total Students

33,520 Reviews

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
  • Google Account

Course Outline

  • Introduction to Gmail Productivity save time with Gmail Tips
    • 0 Gmail Productivity Introduction - 3:26
    • Resource Guide
    • -1 Gmail Settings Cog - 5:25
    • -2 Send Email Undo - 3:36
    • -3 Undo send and Cancellation - 1:52
    • -4 Conversation View and Reply - 4:13
    • -5 Attach Large Files - 7:28
    • -6 Offline and Star options - 2:55
    • -7 Postpone email and Snooze - 5:47
    • -8 Gmail Labels - 7:39
    • -9 Message Filter - 6:52
    • -10 Canned responses - 3:55
    • -11 Email Search - 5:14
    • -12 Email Productivity TIPS - 7:53
    • -13 Stars and Grant Access - 5:09
    • -14 KeyBoard ShortCuts - 1:23
    • -15 Email Tips General - 5:45

View Full Curriculum


Access
Lifetime
Content
2.0 hours
Lessons
28

Dynamic Quiz App Using Google Sheets as Source Google Script

Create Web Apps with Java Script & Google Script

By Laurence Svekis | in Online Courses

This course will help you build your own Dynamic and interactive quiz that uses only Google Sheet data to output the contents of the quiz, and JavaScript on your web page or website. You will be amazed at what you can do with just a few lines of code and how easy it is to connect Google Sheets to your website. This is a great solution to avoid backend code using only Google Script which is essentially JavaScript with a bunch of methods in the cloud.

4.3/5 rating from 1,973 students enrolled: ★ ★ ★ ★

  • Access 28 lectures & 2 hours of content 24/7
  • Connect website input form to Google Spreadsheet
  • Build a quiz application from scratch that uses Google Sheets as the data source
  • Add data from input form to Google Spreadsheet

"This course covers the skills needed to work with Google Suite products particularly Google Sheets. Laurence is clear with all of his explanations and is very responsive to all questions you may have." – Guillermo Ithier

Laurence Svekis | Instructor, Google Development Expert, Application Developer

4.3/5 Instructor Rating: ★ ★ ★ ★

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.

581,302 Total Students

33,520 Reviews

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

  • Google Account
  • Fundamental JavaScript Knowledge

Course Outline

  • Introduction to creating web apps with JavaScript and Google Script
    • 0 Dynamic Quiz App Introduction - 2:26
    • 1 Development Setup - 6:04
    • 2 Spreadsheet Data as JSON - 5:21
    • 3 JavaScript Fetch Data - 5:15
    • 4 Get Sheet Data as Object - 6:00
    • 5 Get Sheet Data as Object 2 - 5:48
    • 6 Get Sheet Data as Object 3 - 3:17
    • 7 Multiple Sheets Promise All - 5:48
    • 8 Build your sheet data object - 6:53
    • 9 Client Side Create HTML from Data - 6:12
    • 10 Create Quiz Questions - 3:22
    • 11 Create Questions JavaScript - 7:21
    • 12 Output Answers to Questions - 5:49
    • 13 Add styling to output - 2:40
    • 14 First Run Output Builder - 1:43
    • 15 Check Answer Scoring - 5:19
    • 16 Game Over handling - 5:33
    • 17 Quiz Gameplay review - 8:07
    • 18 Create Your Quiz - 4:09
    • 19 Apps Script Setup - Use this - 5:55
    • 20 Apps Script add to Sheet - 9:05
    • 21 Connect to WebApp AJAX - 5:04
    • 22 JavaScript Form Builder - 7:33
    • 23 Form Data Post - 8:48
    • 24 WebApp Post Formdata - 4:26
    • 25 Quiz Creator Review and Tweaks - 7:08
    • 26 CORS error Debug - 6:08
    • 27 doGet Method - 3:44

View Full Curriculum



Terms

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