Bring your coding to the next level or get more familiar with all the amazing things that can be done with Google Apps Script.
About This Video
In Detail
Google …
Bring your coding to the next level or get more familiar with all the amazing things that can be done with Google Apps Script.
About This Video
In Detail
Google Apps Script is by far one of the best coding languages to get started with, as it allows you to access the power of all the Google services that simply work so incredibly well within the script. It is based on JavaScript, which makes it easy to get started.
You will start by learning how to write code in Google Apps Script and understand the features of Google Apps Script. You will learn to create projects and open the project to update and edit the code. Moving on, you will learn how to use the power of the Workspace services and create custom macros adding advanced functions to your spreadsheet with Google Apps Script. You will understand how to interact with Google Workspace services, see examples of using Classes in Workspace services, and learn how to access class methods.
Then we will explore some amazing applications that can be built with Google Apps Script. The projects of this course will demonstrate how to apply Google Apps Script code to create docs, create a web app with both GET and POST endpoints, make use of sheet data, get sheet data, send emails, and much more. We will wrap up the course by creating a web form that can send emails using your Gmail account.
By the end of the course, you will learn to interact with Google Workspace services and learn how to code Google Apps Script.
Audience
This course is for Google Workspace users, web developers, and web designers. It can also be taken by application developers who want to learn Apps Script, Google Workspace users who want advanced and customized functionality, and JavaScript developers who want to learn Apps Script. This course is also useful to anyone who uses Google Workspace and wants custom functionality for Google Workspace users.
All you need is an internet connection and a Google Account, and you can start creating your coding apps.
Chapter 1 : Getting Started with an Introduction to Google Apps Script
Introduction to Google Apps Script
Getting Started with Google Apps Script
Create a WebApp URL Sharing and Deploying Scripts with Google Apps Script
Google Workspace Services Creating a Bound Script that Powers Up Your Workspace
Creating and Applying Code Within Your Script Helpful Resources and Tips
Chapter 2 : How to Do Amazing Things with Google Apps Script - Power Up Your Apps Script Code
Introduction to Google Apps Script Power Up Your Apps Script Code
How Marcos can Be Used to Create an App Script - Explore What an App Script Is
How to Get Data from Your Spreadsheet and Use It Within Your Code with Script
How to Use App Script for Creating Files on Drive and Tracking Data in Sheets
How to Create a PDF Email from Sheet Data and Send the Email Using Sheet Data
How to Set Up Bound Scripts Sheets UI Menu with Apps Script
How to Create Custom Functions in Sheets with Google Apps Script Code
How to Create Web Apps with Apps Script Launch Your Web App URL to Share
Learn More about Creating Web Apps with Google Apps Script Do More with Web Apps
How to Create an Apps Script Web API Endpoint for AJAX Connections Output Sheet
Apps Script Web App Data Transfer from ClientSide to ServerSide Web App Sheet
Google Apps Script Automation with Triggers
Chapter 3 : Google Workspace Services: Docs, Calendar, Drive, Forms, Gmail, and Sheets Slides
Introduction to Google Workspace Services: Docs, Calendar, Drive, Forms, Gmail, and Sheets
How to Use Document Service with Apps Script DocumentApp Class and Methods
How to Set Up Form Submission to Sheet Spreadsheet Data to get responses
Create Forms with Google Apps Script Code
How to Use Spreadsheet Service SpreadsheetApp with Google Apps Script
Apps Script How to Use SpreadsheetApp Update Sheets Data in Spreadsheet
Coding Using Spreadsheet Range Selections and Updates of Cells with Apps Script
How to Add Conditional Rules Format with Google Apps Script Code
Apps Script How to Use CalendarApp Class Methods and Calendars in Workspace
How to Create Apps Script Code to Access Drive Service DriveApp Functions
Create, Move, Update Files and Folders Within Your Google Drive with Code
Sending Emails Messages Thread Updates with GmailApp Gmail Service Functions
Explore Slides Service with SlidesApp Class with Apps Script Code
Chapter 4 : Getting Started with Apps Script Projects
Explore Google Apps Script - Connect the Power of Google Services Together
Create a Doc with Apps Script
How to Code DocumentApp to Create and Update Docs with Apps Script Code
Copy Existing Docs with Google Apps Script Use the ID of a Doc to Open
Selecting Spreadsheet Data with Apps Script
Create New Docs Populate with Sheet Data
How to Convert Docs to PDF and Email as Attachments
Final Project Create Doc as PDF and Email to Sheet Data Email Address
Chapter 5 : JavaScript and Google Apps Script Web App
Introduction to Creating a Web App URL for Webform Submission
HTML Send Email Through Apps Script
Send POST Request to Google Apps Script
Send Email When the Form Is Submitted
Chapter 6 : DocumentApp Bound Script Coding Projects
Add Date to Google Doc at Cursor Document Apps Script Example
Adding Images from the Web and Drive to Google Docs
Copy All Images from Doc into Your Google Drive
Highlight Emails in a Doc Using Regex
Chapter 7 : Apps Script Fetch and API Connections
Apps Script Introduction
How to Use Apps Script to Create a Spreadsheet
How to Fetch Request a Web URL and Return the Response Data Apps Script UrlFetch
How to POST with Apps Script UrlFetchApp Send Data to Endpoint API
How to Send an Attachment with Apps Script Advanced Mail Options MailApp
How to Output Google Sheet Data as JSON into a Web App
Chapter 8 : Google Apps Script Coding Examples and Helpful Code Snippets
Google Sheets Data Exercise Sending Emails and Updating Sheet Content Using UI