Google Apps Script on the New IDE: Complete Course with 100+ Examples
Do more with the G Suite applications with the power of scripting
Updated on Oct, 2023
Language - English
Duration -21.5 hours
This course would be helpful for web developers who want to incorporate Google Script functionality or application developers who want to access the power of Google G Suite within their apps.
This course will also be helpful to anyone who wants to create custom functionalities using Google Apps Script.
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.
The code bundle for this course is available at https://github.com/PacktPublishing/Google-Apps-Script-on-the-New-IDE-Complete-Course-with-100-Examples
What will you learn in this course:
- Create custom functions within G Suite apps, Docs, Sheets, Gmail, and Slides
- Explore how to write Google Apps Script code within the G Suite app
- Create Google Script to power Google apps
- Create custom functions and macros for Google Sheets
- Add custom menus, dialogs, and sidebars to Google Docs, Sheets, and Forms
- Interact with other Google services
What are the prerequisites for this course?
Check out the detailed breakdown of what’s inside the course
Introduction to Getting Started with Google Apps Script
- Introduction to Google Apps Script, How to Write Code, and Explore the Course 02:25 02:25
- Getting Started with Apps Script 04:51 04:51
- How to Write Apps Script Code; Apps Script Editor Overview; Create Code 09:01 09:01
- How to Use the Apps Script Editor; Apps Script Editor Write Code 06:00 06:00
- How to Update Your Project Settings; Updated Project Settings Editor 09:26 09:26
- How to Deploy a Web App and Create Your Own Webapp with URL 08:42 08:42
Google Apps Script Sheets Spreadsheet; Service Class SpreadsheetApp
Google Apps Script Document Service Class DocumentApp
Google Apps Script Drive Service Class DriveApp
Google Apps Script Gmail Service Class GmailApp Methods to Send Email
Introduction to Google Apps Script Calendar Service Class CalendarApp
Google Apps Script Slides Service Class SlidesApp
Google Apps Script Forms Service Class FormApp
Google Workspace Services
Google Apps Script Common Services Mini Apps and Useful Coding Examples
Mini Projects with Web Apps; Create Web App URLs Using Google Apps Script
Create a WebApp API Endpoint Google Apps Script; Add-On Project
Apps Script Code Examples, Questions, and Sample Code
Founded in 2004 in Birmingham, UK, Packt's mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals.
Working towards that vision, we have published over 6,500 books and videos so far, providing IT professionals with the actionable knowledge they need to get the job done - whether that's specific learning on an emerging technology or optimizing key skills in more established tools.
As part of our mission, we have also awarded over $1,000,000 through our Open Source Project Royalty scheme, helping numerous projects become household names along the way.
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Related Video CoursesView More
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video CoursesSubscribe now
Master prominent technologies at full length and become a valued certified professional.Explore Now