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
