Google Apps Script 2020 Build 18+ Fun Projects Sites GSuite
4.6 (24 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
305 students enrolled

Google Apps Script 2020 Build 18+ Fun Projects Sites GSuite

Explore Google Apps Script see amazing Google Apps Script projects build power up your GSuite Google Apps Script Plus
4.6 (24 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
305 students enrolled
Created by Laurence Svekis
Last updated 3/2020
English
English [Auto-generated]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 23.5 hours on-demand video
  • 169 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to apply Google Apps Script in Projects
  • Explore how to use Google Apps Script - Classes and Methods to power up GSuite
  • How to apply Google Apps Script
Course content
Expand all 427 lectures 24:26:27
+ Introduction to Google Apps Script
31 lectures 01:17:39
Source Code
00:02
Source Code
00:05
Create a Spreadsheet.
04:34
Source Code
00:09
JavaScript in Apps Script Variables
05:19
Source Code
00:03
JavaScript in Apps Script Arrays
06:06
Source Code
00:07
JavaScript in Apps Script Objects
04:42
Source Code
00:03
JavaScript in Apps Script Functions
03:41
Source Code
00:04
JavaScript in Apps Script Conditions
03:31
Source Code
00:06
JavaScript in Apps Script Loops.
02:46
Source Code
00:02
Apps Script Coding
03:18
Source Code
00:05
Create a Web App
05:54
Source Code
00:08
Google Apps Script Email.
04:31
Source Code
00:04
Google Apps Script Calendar
03:27
Source Code
00:06
Google Apps Script Drive.
06:56
Source Code
00:07
Google Apps Script Conclusion.
02:25
+ Form Submission auto response with Google Sheets and Apps Script
20 lectures 01:00:12
Google Forms Setup.
04:59
Send Email via Script.
09:03
Source Code sample email function
00:02
Setup Trigger. For automation of scripts on event
07:05
Source Code Update Spreadsheet
00:05
Copy to another Sheet.
08:55
Source Code Spreadsheet updater
00:08
Copy content on Submit.
04:33
Source Code Sheet Data Range
00:09
Sheet data sorter.
04:38
Source Code Sort Sheet Column
00:05
Check Sheet Data for Value.
07:17
Source Code Apps Script
00:08
Quick Fixes and Updates.
02:13
Source Code Apps Script
00:11
Update Spreadsheet UI
03:58
Source Code Project
00:14
Conclusion Spreadsheet Data
03:59
Final Project All Source Code used
00:45
+ Advanced Services YouTube API made easy with Google Apps Script
20 lectures 53:51
Project Setup Google Apps Script
03:27
Resource Links
00:17
Search YouTube API using Google Apps Script
03:44
Source Code
00:02
Use Data Results From Search
03:54
Source Code
00:05
Create a Web App with Google Apps Script
05:34
Source Code
00:04
Create HTML index page Client side web app HTML
06:58
Source Code
00:10
Get Data from Google Script
03:47
Source Code
00:11
Output Results to HTML Page.
04:14
Output Results to HTML Page Part 2
06:19
Output Results to HTML Page Part 3
02:46
Project Source Code
00:28
Add to Spreadsheet.
05:05
Source Code
00:10
Code Review youTube Project.
05:09
+ Spreadsheet UI email functionality
18 lectures 42:32
Google Apps Script Bound Script.
02:25
Start Scripting.
06:59
Source Code Google Apps Script Email Spreadsheet Project
00:02
Get Values from Spreadsheet
03:51
Source Code Google Apps Script Email Spreadsheet Project
00:06
Create User Object
04:51
Source Code Google Apps Script Email Spreadsheet Project
00:09
Alert UI Buttons Yes No.
03:53
Source Code Google Apps Script Email Spreadsheet Project
00:14
HTML Template.
04:42
Source Code Google Apps Script Email Spreadsheet Project
00:10
Send Email Message
03:12
Source Code Google Apps Script Email Spreadsheet Project
00:05
Update Spreadsheet column.
04:43
Source Code Google Apps Script Email Spreadsheet Project
00:26
Final Code Review
05:01
Source Code Google Apps Script
00:26
+ Fun with Spreadsheet series of mini projects that are useful for many projects
33 lectures 01:57:44
Bound Script Starter Lesson
05:11
Source Code
00:02
Add More Content to Spreadsheet
10:50
Source Code
00:09
Spreadsheet Formulas with Google Apps Script
05:30
Source Code
00:04
Update Sheet Content
07:17
Source Code
00:08
Spreadsheet UI more options
04:44
Source Code
00:05
Finder and Replace Content
05:24
Finder and Replace Content 2
09:52
Source Code
00:25
Get Cell Values
07:15
Source Code
00:09
Get Content as HTML. webApp
08:11
Source Code
00:12
Email Spreadsheet HTML table
03:32
Source Code
00:04
Copy Spreadsheet as PDF.
05:33
Copy Spreadsheet as PDF 2.
05:48
Copy Spreadsheet as PDF 3
03:41
Source Code Copy App
00:15
Content Copy.
05:23
Source Code
00:07
Search Drive Files
02:58
Search Drive Files 2
05:48
Search Drive Files Project Source Code
00:14
Value Checker if Exists
06:29
Source Code
00:07
Section Conclusion Code Review
07:49
FINAL projects Source Code
02:23
+ API Data From Spreadsheet
20 lectures 55:49
Web Developer Setup.
05:02
Source Code Client Side HTML
00:06
Write Google Apps Script.
03:38
Get Spreadsheet Data
05:59
Source Code Google Script
00:04
Web App Content
05:29
Source Code Web App
00:08
Connect to WebApp URL.
05:15
Source Code JavaScript Client side
00:08
Post Data to Sheet.
07:07
Source Code JavaScript
00:21
WebApp POST
03:23
Source Code Web App POST method
00:03
Add POST to Spreadsheet.
05:25
Google Script Source Code Post
00:17
DeBug and Clean Web App.
05:19
Web Application Source Code
00:26
Application Conclusion Code review.
05:28
Project FULL source Code
00:51
+ Google Drive Image Gallery
17 lectures 51:02
Web Application Setup.
05:58
HTML Source Code
00:06
Google Script Web App
05:36
Source Code Setup
00:03
Get Drive Images
09:14
Apps Script Source Code
00:10
Connect to WebApp JSON
04:22
JavaScript Project Source Code
00:04
Create Page Elements.
03:10
DOM Page Contents Source Code
00:08
JavaScript Popup Image Modal Part 1
06:56
JavaScript Modal Popup Source Code
00:34
JavaScript Popup Image Modal Part 2.
03:53
JavaScript Modal
00:16
Code Review Image Gallery
08:09
Final Project Source Code
00:48
+ Google Apps Script Make Images HTML5 Canvas save to Gdrive
24 lectures 01:13:52
Google Apps Script Web App.
04:25
Source Code
00:04
Images as base64
06:52
Source Code
00:05
Base64 image client side.
07:06
Source Code
00:16
Client Side Options
04:27
Source Code
00:12
Client Side JavaScript.
07:11
Source Code
00:21
Add Text to Canvas
05:00
Source Code
00:26
Add Logo to Canvas
02:37
Source Code
00:29
Upload Image to Canvas
06:46
Source Code
00:38
Save Canvas Image to gDrive
04:17
Source Code
00:04
Google Apps Script Save Image.
07:27
Source Code
00:09
Final Tweaks and Updates
05:20
Source Code
01:12
Image Uploader Project Conclusion.
06:55
+ Google Apps Script WYSIWYG editor and email HTML maker
37 lectures 01:57:31
WYSIWYG Project Setup.
04:25
Create a Apps Script Web App
04:48
Source Code
00:01
Output File in Web App.
03:19
Source Code
00:04
Client Side Coding Project.
04:45
Source Code
00:08
Client Side Request Values
03:56
Source Code
00:12
Create Editor on Client Side.
04:43
Source Code
00:08
Client Side Options Setup.
05:08
Source Code
00:21
Add Button Events.
04:19
Add Button Events 2
02:42
Source Code
00:34
Save HTML as file to gDrive 1
05:02
Save HTML as file to gDrive 2
07:10
Save HTML as file to gDrive 3
04:59
Source Code
00:59
Load File Names as options
03:29
Source Code
00:05
Existing Files Options
04:25
Source Code
00:46
Load File Contents HTML
04:18
Source Code
00:51
Add File Names.
07:59
Source Code
01:20
Create as PDF File.
07:54
Source Code
00:13
Send HTML Email.
05:03
Source Code
00:11
Final Project Conclusion Editor.
11:13
Source Code
01:42
Load File By ID into Editor
07:18
Source Code
01:56
Requirements
  • JavaScript - Web development experience
  • Prior Programming experience
  • JavaScript and prior coding experience
  • Computer access and internet access
  • Google Account
Description

Google Apps Script will amaze YOU!

Perfect course to learn more about Google Apps Script

Even if you have never coded Apps Script Before - we have you covered step by step intro covering use of fundamental JavaScript to get you started with Google Apps Script.  Wow you friends and family with Google Apps Script

Write a little code and do so so much Google Apps Script

"I never knew Google Apps Script can do all this"

"This course was perfect for me to learn and build my own project"

"I think I've found a new career - I love it Google Apps Script Rules"

"This is simply amazing Google Apps Script"

"Google Apps Script is easy to learn I am a JavaScript developer and it took me no time at all"

Everything you need to get started with Google Apps Script in one big course.

Apps Script is a scripting platform developed by Google for light-weight application development in the G Suite platform.

Build amazing Web Apps

Connect to your Google Spreadsheet as a source of data for your WEBSITE - Any webs connect with AJAX

Email users with the power of Gmail

Track users in a spreadsheet

Get messages from users right into a spreadsheet

Share content of your drive - create an image gallery for your website from images sitting on your Gdrive

Let your imagination go wild - whatever you can dream up Google Apps Script can help you accomplish it

Automate your tasks

Build web apps and automate tasks with Google Apps Script

Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with G Suite.

No need for a database - save your time using Google Script for backend functionality

Start Scripting

  • Build with Google

    Feature-rich APIs let you extend Google services and build your own web applications.

  • Code on the Web

    A web browser is all you need to build with Google Apps Script.

  • Share your App

    Store and share your projects in Google Drive or publish on the Chrome Web Store.

Learn the fundamental concepts of Google Apps Script - it’s based on JavaScript allowing you to connect the power of your Google Suite of products together to do some really amazing things. The upcoming lessons are going to show you the basics of how to get started creating your own projects with Google Apps Script.

The sections can be skipped if you are already familiar with the content, they are not dependant on the ones prior and fully wrapped within each project from start to finish. You choose which ones you want to do next, have fun.

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.

Project #1 - Form Submission auto response - Create custom responses and run code all triggered by a user submission of form data. Connecting Google Suite together to make things happen. This is a common and simple application that can be really useful in a number of ways.

Project #2 - YouTube API - Connect to YouTube - get content from YouTube that you can use within your application. This section demonstrates utilizing the power of YouTube, searching and retrieving video information back into a web app. Create a webapp with Google Script that can be used to search YouTube and video results.

Project #3 - Spreadsheet User data Project - Add user data to a Spreadsheet, then take action from the Spreadsheet UI to send emails and update the data. This is a dashboard designed to help manage user lists and send out emails all done within a Spreadsheet.

Project #4 - Spreadsheet Mini Projects - A collection of useful code snippets that do commonly asked for things within Spreadsheets. Explore functionality that can be extended upon to create useful additions to your web applications. Code snippets and mini projects that you can connect and extend upon.

Project #5 - Spreadsheet Data as API JSON - Explore how you can output JSON data from your spreadsheet and use within your websites as a data source and content. Use JavaScript fetch to connect to the JSON data coming from Google Scripts Web App.

Project #6 - GDrive Image Gallery - Use your Gdrive as a source for website images, creating an image gallery project to showcase images from your drive.

Project #7 - HTML5 Canvas image uploader - Fun project that allows users to create images within HTML5 Canvas, and save them to Gdrive. Upload images into canvas then add text and logo then save as an image to GDrive.

Project #8 - HTML editor saving HTML files - Using CKEditor create and save HTML files on GDrive. Select existing files from Gdrive and update the content of the file. Fun mini project that focuses on GDrive and file management.

Project #9 - Simple AutoResponse - Mini project to demo creating an email template, using triggers to automate form responses and tracking data into Spreadsheets.

Project #10 - PDF Uploader - Mini Project using Google Script to create files, use of blobs for PDF and sending of emails.

Google Sites - Perfect place to host all of your Google Web Apps in one place, showcase your work and more. A quick intro and overview of the new Google Sites.

Project #11 - GmailApp - Send email with an image attachment that will be copied to your GDrive and moved to another label within your Gmail Folders.

Project #12 - WebApp Sheet data as API - Explore how you can output Sheet content into a Web API as JSON data

Project #13 - Google Apps Script Consent Form Exercise - JavaScript Cloud - Useful project on how to create a webapp form have users select fill it out and get a PDF of their response info.

Project #14 - Google Sheets as JSON data source for JavaScript - Using Google Sheets as a source for data for your website

Project #15 - Build a team site on sites. Google Apps Script - Project Exercise Spreadsheet web app Team Site on Sites.  Posting board where users can post messages.

Project #16 - Simple Google Sheet input Project Submit data to your spreadsheet from your website

Step by step learning Google Apps Script

Fast friendly support is always available within the Q&A section

Experienced instructor with over 20 years of experience ready to help you learn

You have nothing to lose - Join now and start learning to create your own version of this helpful application today!!!

Create your own amazing time saving application - Google Apps Script

Did you know you can automate Google Apps Script

Who this course is for:
  • Web developers
  • Application Developers
  • Coders who want to explore how to use Google Apps Script
  • JavaScript developers who want to add a new language to their portfolio
  • Anyone who wants to power up their Google Suite of Products with really amazing features
  • Anyone who wants to learn more about Google Script
  • Anyone who wants to create amazing applications