Learn to power up your Google Suite products using Apps Script to connect, automate, and add advanced functionality
About This Video
In Detail
This course will take you on a journey where you'll learn to power up your Google Suite products using Apps Script to connect, automate, and …
Learn to power up your Google Suite products using Apps Script to connect, automate, and add advanced functionality
About This Video
In Detail
This course will take you on a journey where you'll learn to power up your Google Suite products using Apps Script to connect, automate, and add advanced functionality. Apps Script allows 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 email, generate reports, use data more effectively—the list of amazing things you can do with Google Apps Script is endless. Just like JavaScript, Apps Scripts are easy to write and use the same structure and core fundamental functionality as JavaScript. If you know JavaScript, you can get started with Apps Script in minutes. Functions, variables, loops, and more use the same syntax as JavaScript. With the added power of Google Classes, you can connect data from your Google apps and build on it. It's the easy way to power up your applications.
Chapter 1 : Introduction to using Google Script
Introduction to Google Script 00:06:24
Quick Start to Google Apps Script 00:04:15
Apps Script Power Example 00:07:00
IDE Integrated Development Environment 00:10:45
First Script using online IDE and Google Script 00:08:43
Google Script Classes 00:13:09
JavaScript Introduction 00:12:59
Chapter 2 : Google DocumentApp
Explore Document - Class DocumentApp 00:05:18
Get Document Contents 00:04:39
Document Body Contents 00:03:52
Document Body Updates 00:06:55
Document Body Children 00:05:37
Document Classes and Methods 00:08:08
Simple Copy Doc Script 00:12:48
DocumentApp Bound Script 00:06:39
Base Values within Script 00:08:17
HTML in Google Documents 00:06:12
Bound Content Interaction 00:07:22
Ranged elements in Document 00:06:03
Translate Selected Content 00:03:25
Search Content Replace With 00:08:14
Find Content Update Attributes 00:08:48
Content Selection Exercise 00:14:46
DocumentApp Exercise 00:15:13
DocumentApp Create Content 00:17:03
insert Image DocumentApp 00:05:33
DocumentApp Template Exercise 00:04:14
Chapter 3 : Google Spreadsheet app
StandAlone SpreadSheetApp 00:03:04
Creating Content and Styling. 00:07:17
Spreadsheet data to Doc Table 00:07:19
Spreadsheet data dynamic 00:04:10
SpreadSheet Tracker Exercise 00:07:08
SpreadSheet Sheet Class 00:06:09
From one sheet to another 00:10:47
Bound Spreadsheet App 00:03:18
Google Sheets Functions 00:05:10
UI menu options Spreadsheet 00:03:43
Spreadsheet UI Sidebar Modal 00:05:45
Get Selected Content 00:07:31
Exercise Cell Selection Add to Sheet 00:08:26
Range to Another Sheet CopyTo 00:04:56
Selecting Cell Values Loops 00:13:28
Sidebar content HTML 00:07:58
Script More UI options 00:04:18
HTML to backend GS code 00:07:52
Google Sheet content to Client Side 00:08:39
Triggers OnEdit OnChange 00:03:20
Exercise Google SpreadsheetApp. 00:05:30
Exercise Generate Random Content 00:10:10
Adding new Column 00:06:36
Add Formulas Set Colors 00:07:05
HTML modal to Spreadsheet 00:03:46
Sheet Data to HTML file 00:07:51
Get Sheet Data 00:07:19
Run Script Client Side 00:07:01
Response with Google Sheet Data 00:09:53
Chapter 4 : Google Script Sites
Introduction to Google Sites 00:08:42
New Google Sites 00:07:41
Publish Web App Google Script 00:08:13
Google Site Scripting 00:05:45
Google Script Web App html page 00:04:40
Chapter 5 : Google Drive - DriveApp Class
Google DriveApp Class 00:03:49
Select Folder By ID 00:02:58
Create Folder DriveApp 00:07:13
DriveApp create File 00:04:20
SpreadSheet with DriveApp Data 00:09:53
Create Doc and Move it 00:07:22
DriveApp Search 00:09:39
DriveApp Search Files 00:02:44
Google DriveApp searchFolders Params 00:01:12
Add editors and Delete 00:12:53
Redirect on search string 00:10:03
Exercise WebApp Redirector 00:07:11
Chapter 6 : Google GmailApp
Introduction to Class GmailApp 00:02:36
Make Draft GmailApp 00:04:47
View your Draft Email 00:05:11
Use HTML Template email 00:05:58
Send out a bunch of Emails 00:11:11
Chat Threads GmailApp 00:03:34
Get Gmail Messages 00:12:27
Chapter 7 : Calendar App Class
Calendar App Service 00:03:44
Add Location Info Calendar App 00:04:47
Calendar Event with options 00:05:33
Full Day events Calendar App 00:05:43
Calendar App Event Series 00:07:04
Calendar App Date Time 00:03:23
Easy way to enter Events 00:03:19
More Calendars 00:04:03
Calendar Settings 00:04:42
Get All Calendars 00:05:26
Calendars By Name 00:05:49
Calendar Events 00:02:53
Calendar Events Explored 00:05:06
Calendar Events into spreadsheet 00:07:59
Google Calendar Events Invites No 00:07:44
Send Weekly Calendar Events 00:18:52
Review Google Script 00:03:04
Chapter 8 : Exercise Google Script Image Uploader Project
Apps Script Image Uploader project intro 00:02:03
HTML Content Service 00:07:16
HTML Content Template File 00:03:50
HTML Content from File 00:08:47
Create the HTML form 00:04:44
Send Data to Google Script Backend 00:07:38
Send Image to Google Script 00:06:24
Image upload Tweaks 00:02:36
Spreadsheet App tracking uploads 00:04:34
Send Email notification 00:02:56
Final Application Image Uploader 00:05:50
Chapter 9 : Form auto Email responder
Setup Google Form 00:06:37
Spreadsheet Bound Script 00:03:45
Google Script Setup Project triggers 00:05:03
Setup Email to Send 00:04:14
MailApp Send Email 00:04:16
Email HTML template 00:05:58
HTML Service replace content 00:03:32
HTML to PDF and Attach it 00:05:16
Send automatic emails 00:05:27
iterate Sheet Data Send Emails 00:06:47
Review and update code for project 00:05:57