Do more with the G Suite applications with the power of scripting
About This Video
In Detail
Google Apps Script is a rapid application development platform that makes it fast and easy to integrate business applications with Google …
Do more with the G Suite applications with the power of scripting
About This Video
In Detail
Google Apps Script is a rapid application development platform that makes it fast and easy to integrate business applications with Google Workspace.
This is a complete hands-on course, loaded with 100s of Google Apps Script coding examples to do amazing things with Google G Suite and sample projects to create advanced functionality with Google apps and Google services.
Boost workflow efficiency when working with Google Workspace by automating or streamlining tasks and connect to non-Google services within Google Workspace applications, allowing us to retrieve or upload data from those services into and from Google Workspace. Explore how to deploy your Apps Script project as an add-on extending Google Workspace.
In this course, we will explore how to create and release functionalities within our G Suite apps.
We’ll add custom menus, dialogs, and sidebars to Google Docs, Sheets, and Forms; publish web apps—either standalone or embedded in Google sites; create customized user interfaces that are directly integrated into Google Workspace applications.
By the end of this course, you will become an expert in Google Apps Script.
Chapter 1 : Introduction to Getting Started with Google Apps Script
Introduction to Google Apps Script, How to Write Code, and Explore the Course
Getting Started with Apps Script
How to Write Apps Script Code; Apps Script Editor Overview; Create Code
How to Use the Apps Script Editor; Apps Script Editor Write Code
How to Update Your Project Settings; Updated Project Settings Editor
How to Deploy a Web App and Create Your Own Webapp with URL
Chapter 2 : JavaScript in the Cloud Google Apps Script and JavaScript Basics of Code
Introduction to JavaScript Fundamentals; Modern JavaScript and Apps Script
How to Use JavaScript Variables Functions in Google Apps Script
How JavaScript Arrays and Objects are Used in Google Apps Script
Basics of JavaScript Loops; Conditions JavaScript
How to Apply JavaScript Built-In Methods; Math Date Within Google Apps Script
Chapter 3 : Google Apps Script Sheets Spreadsheet; Service Class SpreadsheetApp
Introduction to Google Spreadsheet Services with Apps Script
Creating Sheets Macros; Writing Code Macros in Spreadsheets
How to Customize Spreadsheet Services; Introduction Class SpreadsheetApp
How to Add Custom Functions to G Suite Sheets; Spreadsheet Sheets Apps Script
How to Update Sheets and Spreadsheet Selection
How to Create New Sheets with Apps Script Sheets
How to Manipulate and Update Sheet Content and Interact with Sheets
How to Get Ranges to Update Content Within Sheets and Selecting Range from Sheets
How to Update Sheet Content and Set Values Within Sheet Cells and Rows
How to Troubleshoot Debugging Dashboard Options Within Google Apps Script
How to Access Data Within G Suite Sheets with Code; Sheet Data Cols and Rows
How to Get Sheets Bound Script; Active Sheet and Selections
Coding Challenge - Mini App to Copy Values into New Sheet
How to Add Menus to G Suite Sheets Menus and UI Functions Sheet UI Object
Coding Challenge - Create a Custom Logger into a Sheet - Track Messages into Log
How to Create Alerts in Sheets; Spreadsheet UI Alerts and Prompts User inputs
How to Add a Modal Popup Window to Sheets with Apps Script; Spreadsheet UI Modal
How to Display Sidebar; Show Sidebar HTML Code from Template File and HTML Code
How to Add Rows to Sheets; AppendRow Adding Rows to Sheet
Coding Challenge - Create a Custom Prepend Function; Prepend Row Exercise
Google Sheets Custom Formulas; Cell Formulas and Custom Functions
How to Add Notes and Comments to Sheets Cells; Cell Notes and Comments
Google Apps Script SpreadsheetApp; Overview Sheet Services
Chapter 4 : Google Apps Script Document Service Class DocumentApp
Introduction to Google Docs Services DocumentApp Class with Apps Script
Google Apps Script Docs Code DocumentApp Class Introduction
How to Create a StandAlone Script Add to Doc
How to Get Document Contents; Document Body with Code
How to Access Paragraph Content; DocumentApp Paragraphs
How to Interact with Paragraphs; DocumentApp Paragraphs 2
How to Set Font Size and Get Body Elements
How to Select Elements; Body Elements as Text
Docs App Interaction with Style Attributes
How to Replace Text Within Body
How to Get Doc Types; List Type Elements
How to Make a Copy of a Doc; Copy Doc; Clear Doc
How to Add a New Table; Create Table
How to Add Menu Items; DocumentApp UI Menu
Coding Challenge - Add Text Within the Doc; Press Menu Button
Coding Challenge - Find and Highlight Text from Doc Content
How to Add Modal Dialogs to Docs; UI showModalDialog
How to Add Menu UI; Show Sidebar UI; Show Sidebar Menu
Coding Challenge - Insert Images in Doc Content; Insert Images
DocumentApp Overview
Chapter 5 : Google Apps Script Drive Service Class DriveApp
Introduction to Google Drive Using DriveApp Service and Classes with Apps Script
Introduction to Apps Script DriveApp Service getFiles
How to Get Files in a Specific Folder Using DriveApp Service; Google Apps Script
How to Make Files Within Your GDrive; Apps Script DriveApp Create a File
Get Info and GDrive Folder Drive Details with Apps Script
How to Send Files to Trash with Google Apps Script
Coding App MiniProject Add and Remove Editors
How to Set Files in Folders; Set File and Folder
Coding App MiniProject Challenge - Create an App to List Folder Details in Sheet
Coding App MiniProject Move File from One Folder to Another
Coding App MiniProject Search Files; Return File Object
Coding App MiniProject Webapp Folder URLs in Webapp from Search
Google Apps Script DriveApp Class Overview
Chapter 6 : Google Apps Script Gmail Service Class GmailApp Methods to Send Email
Introduction to Gmail and Mail Service Google Apps Script Sending Email
How to Send Emails - Sending Emails with Apps Script
Sending an Email in Mail Service sendEmail
How to Create Drafts; Email in GmailApp Service
How to Get Threads Within Gmail Using GmailApp Service Inbox Threads
How to Send an Email Using a Template File; Send Email from Template
Coding App MiniProject Use Doc as Email Template
Coding App MiniProject How to Use Spreadsheet Data List to Send Emails
How to Add Stars to Emails; Star Messages Gmail Classes Apps Script
How to Set Up Message Labels Using Google Apps Script
How to Access Chat Threads GmailApp Class Using Apps Script
How to Find Messages - Apps Script GmailApp Search
Coding App MiniProject Get attachments GmailApp Attachment Class
Google Apps Script GmailApp Overview
Chapter 7 : Introduction to Google Apps Script Calendar Service Class CalendarApp
Introduction to Calendar Apps Services with Apps Script Course Section
Introduction to Class CalendarApp Access Calendar
How to Get Calendar Owner and Settings; Get Owner; Create Calendars
How to Update Google Calendar Name and Add Description
How to Access the Calendar Event Class Using Google Apps Script
How to Create Events CalendarApp Within Google Calendar with Apps Script
Create Events CalendarApp Within Google Calendar with Apps Script - 2
How to Delete and Remove Calendar Events with Apps Script
How to Add Google Calendar Event Guests - Calendar Event Guest
Coding App MiniProject Spreadsheet Calendar Lister - CalendarApp Spreadsheet
Chapter 8 : Google Apps Script Slides Service Class SlidesApp
Introduction to Creating Slides Using Google Slide Service with Apps Script
How to Use Slides Service Class SlidesApp with Google Apps Script
How to Update Google Slides with Code; Slides Bound Script Updates
How to Select Slides Within Google Slides, Get Slides, and Update Them
How to Add Custom Menu Options for Slides Users SlideApp UI Menu
Coding App MiniProject Remove a Slide; Google Slides Presentation Remove Slide
How to Add Text to Slide from Menu Google Slides; Slide TextRange Insert Text
How to Update and Change Google Slides Layout; SlideApp Layouts
Coding App MiniProject Create a Presentation from Sheets
Coding App MiniProject Create a Presentation from Sheets Part 2
Google Slides with Apps Script SlideApp Class Overview
Chapter 9 : Google Apps Script Forms Service Class FormApp
Introduction to Google Forms Service with Apps Script Course Section
How to Create a Form with Apps Script Forms Service; Create a Form
How to Add Items to a Form Using Google Apps Script to Google Form Using FormApp
How to Get Form Items; Update Google Form Contents with Apps Script
How to Set Up Feedback Within Google Form; Feedback Within Form
How to Set Up Response from Google Form; Coding FormApp Class FormResponse.
Coding App MiniProject FormResponses into Sheet; Get Form Responses; Add Sheetdata
Coding App MiniProject Create a Math Quiz in Google Forms Apps Script; Quiz Gen
How to Use Google Forms with Code FormApp Overview
Chapter 10 : Google Workspace Services
Apps Script Useful Google Workspace Class Examples; Common Apps Classes Section
How to Use Class ContactsApp Within Google Services Apps Script
How to Use LanguageApp Service Within Google Apps Script
How to Generate Maps Using Maps Service Within Google Apps Script
Google Apps Script Base Services; Examples of Code
Coding Example: Using Content Service with Apps Script
Coding Example: HTML Service Within Google Apps Script
Send Data from Client Side Back to Google Apps Script; Class Google Script Host
Google WebApp Client-Side Data Scriptlets; Services Host Services Google
How to Store Values Within Google Apps Script; Class PropertiesService User Doc
Create a Request to HTTP Endpoint API Using UrlFetchApp Class
Chapter 11 : Google Apps Script Common Services Mini Apps and Useful Coding Examples
Common Apps Script Coding Examples and Mini Code Projects
Coding App MiniProject Create Charts in Google Spreadsheets; Setup Sheets
Coding App MiniProject Create Charts in Google Spreadsheets; Setup Sheets 2
Coding App MiniProject Add Charts to Slides; Create Slides Presentation
Coding App MiniProject Create PDF in Drive email as Attachment Slides as PDF
Coding Example of Google Docs UI; Add Menu item for Advanced Functions
Sheets UI Menu Button for Advanced Interaction
Getting to Know Sheets Simple Triggers on Edit and Change; Run Some Code
Create a Webapp onGet onPost Simple triggers with Apps Script
Automation Setup Triggers; Run Code on Events and Regular Time Intervals
Chapter 12 : Mini Projects with Web Apps; Create Web App URLs Using Google Apps Script
Introduction to Section Code Examples; Mini Projects
How to Create Multiple Page WebApp Introduction
WebApp Templates Multiple Page WebApp Templates
Multiple Page WebApp Templates 2
Multiple Page WebApp Templates 3 with Apps Script
Interactive Document Custom Functions Introduction; Document UI File
Document UI File Templates
Build the Client-Side Interaction
Docs and Client-Side Interaction
Docs Interactive Project
Apps Script Project Setup Custom Sheet Quiz WebApp
Custom WebApp Quiz Setup from Sheets Using a Web App
Web App Get Sheet Data to Client Side Using Apps Script
Adding Input Fields radiobuttons; Add Questions with RadioButtons
How to Submit Form to Sheets and Store Form Response in the Sheet Columns
How to Update and Add Data to Sheet with Google Apps Script
Chapter 13 : Create a WebApp API Endpoint Google Apps Script; Add-On Project
Create and Deploy Google Apps Script Add-On to Google Services
Output Sheet Data as JSON API Sheets Data as WebApp Endpoint
Set Up to Deploy Apps Script Code as Addon; JSON Manifest File Addon Project ID
Addon Setup; HomePage Setup; Addon Interface for Docs
Get JSON data into Doc URL; Fetch Content
Overview Addon Complete Coding
Chapter 14 : Apps Script Code Examples, Questions, and Sample Code
Google Apps Script DocumentApp Table Class; Table Rows; Adding and Updating
Document Copy by Elements: Coding Example