Google Apps Script on the New IDE: Complete Course with 100+ Examples

person icon Packt Publishing

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 icon Updated on Oct, 2023

language icon Language - English

person icon Packt Publishing

architecture icon Development,Programming Languages,Google Apps Script

Lectures -156

Duration -21.5 hours


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

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?

  • JavaScript, basic HTML and CSS knowledge, a Google account, and a basic understanding of web development is a requirement for this course.
Google Apps Script on the New IDE: Complete Course with 100+ Examples


Check out the detailed breakdown of what’s inside the course

Introduction to Getting Started with Google Apps Script
6 Lectures
  • play icon Introduction to Google Apps Script, How to Write Code, and Explore the Course 02:25 02:25
  • play icon Getting Started with Apps Script 04:51 04:51
  • play icon How to Write Apps Script Code; Apps Script Editor Overview; Create Code 09:01 09:01
  • play icon How to Use the Apps Script Editor; Apps Script Editor Write Code 06:00 06:00
  • play icon How to Update Your Project Settings; Updated Project Settings Editor 09:26 09:26
  • play icon How to Deploy a Web App and Create Your Own Webapp with URL 08:42 08:42
JavaScript in the Cloud Google Apps Script and JavaScript Basics of Code
5 Lectures
Google Apps Script Sheets Spreadsheet; Service Class SpreadsheetApp
23 Lectures
Google Apps Script Document Service Class DocumentApp
20 Lectures
Google Apps Script Drive Service Class DriveApp
13 Lectures
Google Apps Script Gmail Service Class GmailApp Methods to Send Email
14 Lectures
Introduction to Google Apps Script Calendar Service Class CalendarApp
10 Lectures
Google Apps Script Slides Service Class SlidesApp
11 Lectures
Google Apps Script Forms Service Class FormApp
9 Lectures
Google Workspace Services
11 Lectures
Google Apps Script Common Services Mini Apps and Useful Coding Examples
10 Lectures
Mini Projects with Web Apps; Create Web App URLs Using Google Apps Script
16 Lectures
Create a WebApp API Endpoint Google Apps Script; Add-On Project
6 Lectures
Apps Script Code Examples, Questions, and Sample Code
2 Lectures

Instructor Details

Packt Publishing

Packt Publishing

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.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us