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.
All resources and code files are placed here: https://github.com/PacktPublishing/Google-Apps-Script---Exercise-Coding-Projects
- Publication date:
- June 2022
- 13 hours 22 minutes