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

Name: Google Apps Script on the New IDE: Complete Course with 100+ Examples
Price: 134.99 USD
Author: Packt Publishing

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

Add to Cart Buy Now

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

Goals

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

Prerequisites

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

Curriculum

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

Introduction to Getting Started with Google Apps Script
6 Lectures

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

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

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.