Google Apps Script Online Course

Google Apps Script Online Course

This course introduces you to Google Apps Script, a JavaScript-based language that unlocks the power of Google Workspace services. You’ll learn to write and edit code, create projects, and build custom macros for spreadsheets. Through hands-on projects, you’ll create docs, web apps with GET/POST endpoints, work with sheet data, send emails, and more. By the end, you’ll be confident in coding with Google Apps Script and integrating it seamlessly with Google services.

Who should take this course?

This course is designed for professionals, developers, and tech enthusiasts who want to automate workflows, extend Google Workspace apps, and boost productivity with custom scripts. It’s perfect for those looking to integrate Google Sheets, Docs, Gmail, and other Workspace tools through Apps Script. Whether you’re a beginner eager to explore scripting or an experienced programmer aiming to streamline business processes, this course equips you with the skills to create powerful automation solutions.

What you will learn

• Connect your code to a Google Workspace document
• Learn to create customized functionality within Google Workspace
• Learn to create projects and open the project to update and edit the code
• Learn to bring your Google Workspace to the next level
• Explore how to code Google Apps Script
• Learn how to use spreadsheet data and update it with code

Course Outline

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

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

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

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

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

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

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

Google Apps Script Coding Examples and Helpful Code Snippets

• Google Sheets Data Exercise Sending Emails and Updating Sheet Content Using UI