Google Apps Script Complete Course - Beginner to Advanced
4.5 (1,290 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.
8,456 students enrolled

Google Apps Script Complete Course - Beginner to Advanced

Learn to power up your Google Suite of products using Apps Script to connect - automate - add advanced functionality
Bestseller
4.5 (1,290 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.
8,456 students enrolled
Created by Laurence Svekis
Last updated 5/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
  • 20 hours on-demand video
  • 95 articles
  • 23 downloadable resources
  • 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
  • Create Google Script to power Google Apps
  • Use Google Script to to add functionality automation and more to Google Docs Sheets plus
Course content
Expand all 284 lectures 20:50:12
+ Introduction to using Google Script
10 lectures 01:03:41
Apps Script Power Example
07:00
Source Code
00:07
IDE Integrated Development Environment
10:44
First Script using online IDE and Google Script
08:43
Google Script Classes
13:09
Apps Script Resources
00:11
JavaScript Introduction
12:59
Source Code
00:09
+ Google DocumentApp
29 lectures 02:44:20
Explore Document - Class DocumentApp
05:18
DocumentApp Class overview
00:19
Source Code 7 Class DocumentApp
00:13
Source Code 10
00:33
Document Classes and Methods
08:07
Source Code 11
00:41
Simple Copy Doc Script
12:47
Source Code 12
00:09
Base Values within Script
08:17
Bound Content Interaction
07:21
Ranged elements in Document
06:02
Source Code 18
00:47
Search Content Replace With
08:14
Find Content Update Attributes
08:47
Content Selection Exercise
14:45
Source Code 21
00:35
DocumentApp Exercise
15:12
Source Code 22
00:47
DocumentApp Create Content
17:02
insert Image DocumentApp
05:32
DocumentApp Template Exercise
04:13
Source Code 25
01:19
+ Google Spreadsheet app
40 lectures 03:25:08
StandAlone SpreadSheetApp
03:04
Google SpreadSheetApp Methods CheatSheet
00:59
Creating Content and Styling.
07:16
Updated Lessons Set Values and Get Values
04:27
Source Code for Updates
00:18
Spreadsheet data to Doc Table
07:19
Spreadsheet data dynamic
04:10
SpreadSheet Tracker Exercise
07:07
SpreadSheet Sheet Class
06:09
From one sheet to another
10:47
Source Code 33
00:49
Bound Spreadsheet App
03:18
Google Sheets Functions
05:10
Source Code
00:03
UI menu options Spreadsheet
03:42
Spreadsheet UI Sidebar Modal
05:44
Get Selected Content
07:31
Exercise Cell Selection Add to Sheet
08:26
Range to Another Sheet CopyTo
04:55
Selecting Cell Values Loops
13:30
Source Code
00:38
Sidebar content HTML
07:57
Script More UI options
04:18
HTML to backend GS code.
07:52
Google Sheet content to Client Side
08:39
Source Code
00:30
Triggers OnEdit OnChange
03:20
Source
00:36
Exercise Google SpreadsheetApp.
05:29
Exercise Generate Random Content
10:09
Adding new Column
06:36
Add Formulas Set Colors
07:04
HTML modal to Spreadsheet
03:46
Sheet Data to HTML file
07:51
Source Code
00:28
Get Sheet Data
07:18
Run Script Client Side
07:01
Response with Google Sheet Data
09:52
Source Code HTML index file
00:25
Source Code GS
00:32
+ Google Script Sites
6 lectures 35:06
Introduction to Google Sites
08:41
New Google Sites
07:41
Publish Web App Google Script
08:12
Google Site Scripting
05:45
Source Code
00:08
Google Script Web App html page
04:39
+ Google Drive - DriveApp Class
17 lectures 01:21:33
Google DriveApp Class
03:49
Select Folder By ID
02:57
Create Folder DriveApp
07:13
DriveApp create File
04:20
SpreadSheet with DriveApp Data
09:53
Source Code
00:20
Create Doc and Move it
07:21
Source Code
00:06
DriveApp Search
09:38
DriveApp Search Files
02:44
Source Code
00:24
DriveApp searchFolders Params
01:11
Add editors and Delete
12:52
Source Code
01:08
Redirect on search string
10:03
Exercise WebApp Redirector
07:10
Source Code
00:21
+ Google GmailApp
9 lectures 46:54
Introduction to Class GmailApp
02:35
Make Draft GmailApp
04:46
View your Draft Email
05:11
Use HTML Template email
05:58
Send out a bunch of Emails
11:10
Source Code
00:31
Chat Threads GmailApp
03:34
Get Gmail Messages
12:26
Source Code
00:42
+ Calendar App Class
20 lectures 01:42:37
Calendar App Service
03:44
Add Location Info Calendar App
04:46
Calendar Event with options
05:33
Full Day events Calendar App
05:43
Calendar App Event Series
07:04
Calendar App Date Time
03:23
Easy way to enter Events
03:19
More Calendars
04:03
Calendar Settings
04:42
Get All Calendars
05:25
Calendars By Name
05:49
Source Code
01:22
Calendar Events
02:52
Calendar Events Explored
05:05
Calendar Events into spreadsheet
07:59
Google Calendar Events Invites No
07:43
Source Code
01:49
Send Weekly Calendar Events
18:52
Source Code
00:20
Review Google Script
03:03
+ Exercise Google Script Image Uploader Project
13 lectures 58:51
Apps Script Image Uploader project intro
02:03
New Updates 2020
00:48
HTML Content Service
07:16
HTML Content Template File
03:50
HTML Content from File
08:47
Create the HTML form
04:44
Send Data to Google Script Backend
07:37
Send Image to Google Script
06:23
Image upload Tweaks
02:36
Spreadsheet App tracking uploads
04:34
Send Email notification
02:55
Final Application Image Uploader
05:50
Project Source Code
01:27
+ Form auto Email responder
13 lectures 57:26
Setup Google Form
06:36
Spreadsheet Bound Script
03:44
Google Script Setup Project triggers
05:02
Setup Email to Send
04:14
MailApp Send Email
04:15
Email HTML template
05:58
HTML Service replace content
03:31
Source Code
00:19
HTML to PDF and Attach it
05:16
Send automatic emails
05:26
iterate Sheet Data Send Emails
06:46
Review and update code for project
05:57
Project Source Code
00:21
+ Using Google Script for website form submission and handling
24 lectures 01:17:26
Contact Form Setup
05:12
Source code
00:18
Create Spreadsheet and setup
08:35
Sending an Email with Apps Script.
05:33
Google Script send email
00:03
Spreadsheet App add content
07:11
Test Sheet Google Script
00:06
Create Web App
05:41
Google Script Trigger Examples
00:04
Get Data Parameters
03:33
JavaScript Fetch
06:09
Outdate HTML in Submit
02:05
Source Code
00:31
Google Script Application
07:24
Source Code Google Script Post
00:16
Send email on submit
03:08
Random ID function and Date Add
03:24
Google Script doPost doGet Source Code
00:48
Email template
06:26
Source Code Google Script
00:48
Create Web App
05:29
Source Code
00:49
App Wrap Up and Review
02:48
Final Project Source Code
01:01
Requirements
  • JavaScript and basic HTML and CSS knowledge
  • Internet Access
  • Google Account
  • Basic Web development understanding
  • JavaScript knowledge is REQUIRED
Description

Increase the power of your favorite Google apps — like Calendar, Docs, Drive, Gmail, Sheets, and Slides. Apps Script lets you do more with Google. All on a JavaScript platform in the cloud.G Suite Services.

Course content 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.  Perfect for students of all levels, with a step by step approach for anyone who has not used Google Script Before.

Apps Script allow you to power up your favorite Google apps and do more with them, way more.

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!!!

Just like JavaScript apps script is easy to write, uses the same structure as JavaScript and core fundamental functionality.   If you know JavaScript you can get started with apps script in minutes.  Functions, variables, loops, and more the same syntax as JavaScript.   With the added power of Google Classes you can connect data from your Google Apps and build on it.  Its the easy way to power up your applications.

Course will cover 

  • Standalone script

  • IDE editor

  • Quick demo to setup and get started with.

Document - DocumentApp

  • Get document

  • Document body

  • Get elements within body

  • Create docs on the fly

  • Document UI for alerts and responses.  Interact with users.

  • Selection of data and construction of content

  • Styling your doc content

Spreadsheet - SpreadsheetApp

  • How to Get spreadsheet data

  • Create spreadsheets and update, create and use the data

  • Get ranges - select sheets and get content

  • Get Sheet data and iterate through it to output it

  • Write to spreadsheet using script

  • Spreadsheet UI for added interactions with users

  • Update sheet with new data

  • Sidebar menu update sheet show sheet data and more

Google Sites - Standalone scripts

  • Sites class and how to use them

  • Sites dashboard navigation and use

  • Design sites interface with options to create pages and more

  • Add scripts to sites to create data driven and interactive pages

  • Output and setup sites content quickly and easily

Google Drive - DriveApp Class

  • Get drive data and use it

  • Setup files create new files

  • Move files from one folder to another

  • Get folder contents and list it

  • Create files copy files and update files

  • Search drive files and folders

  • Get permissions and set permissions

  • List files from folders in Google Sheet show permissions update permissions

Calendar Calendar - CalendarApp Class

  • Create events

  • Get event details

  • Update color style

  • Output events to Google Sheet

  • Using Calendar events checking availability and more

Gmail - GmailApp Class

  • Send message

  • Get inbox contents from folder

  • Create labels and move files

  • Get counts of emails and content

  • Mark Emails as read 

  • Track emails and use the content 

  • Search emails

  • Star Messages

Step by step training lessons

This course covers everything you need to learn about Google Apps Script, including practice exercises, loads of examples, source code and step by step training.  Along with friendly support in the Q&A to help you learn and answer any questions you may have.

Try it now you have nothing to lose, comes with a 30 day money back guarantee.  

Taught by a knowledge instructor with many years of web development experience, ready to help you learn.

Join now and create your own Google Scripts Apps see what is possible.


Who this course is for:
  • Anyone who wants to create amazing things using Google Scripts
  • JavaScript developers who want to empower Google suite of products
  • Web developers who want to incorporate Google Script functionality
  • Application developers who want to access the power of Google G Suite
  • App Script Google Script developers