Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

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

person icon Packt Publishing

3.9

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 Apr, 2024

language icon Language - English

person icon Packt Publishing

English [CC]

category icon Development,Programming Languages,Google Apps Script

Lectures -156

Duration -21.5 hours

3.9

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point 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
  • 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
Tutorialspoint
Google Apps Script Sheets Spreadsheet; Service Class SpreadsheetApp
23 Lectures
Tutorialspoint
Google Apps Script Document Service Class DocumentApp
20 Lectures
Tutorialspoint
Google Apps Script Drive Service Class DriveApp
13 Lectures
Tutorialspoint
Google Apps Script Gmail Service Class GmailApp Methods to Send Email
14 Lectures
Tutorialspoint
Introduction to Google Apps Script Calendar Service Class CalendarApp
10 Lectures
Tutorialspoint
Google Apps Script Slides Service Class SlidesApp
11 Lectures
Tutorialspoint
Google Apps Script Forms Service Class FormApp
9 Lectures
Tutorialspoint
Google Workspace Services
11 Lectures
Tutorialspoint
Google Apps Script Common Services Mini Apps and Useful Coding Examples
10 Lectures
Tutorialspoint
Mini Projects with Web Apps; Create Web App URLs Using Google Apps Script
16 Lectures
Tutorialspoint
Create a WebApp API Endpoint Google Apps Script; Add-On Project
6 Lectures
Tutorialspoint
Apps Script Code Examples, Questions, and Sample Code
2 Lectures
Tutorialspoint

Instructor Details

Packt Publishing

Packt Publishing

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

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
Annual Membership

Online Certifications

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

Explore Now
Online Certifications

Talk to us

1800-202-0515