Learning Google Apps Script - Automate Google Apps

Learning Google Apps Script - Automate Google Apps

Instructor: Packt - Course Instructors

Access provided by D.M.POLYMERS

9 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

9 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Create custom menus and dialogs to enhance Google applications.
Automate email sending and calendar event creation.
Build interactive web pages and forms for data collection.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

9 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 9 modules in this course

This course provides a hands-on introduction to Google Apps Script, a powerful JavaScript-based platform that enables you to automate and customize Google applications. You'll learn essential skills like creating custom menus, automating email sending, and building interactive web pages and forms, all while working on real-world projects. This resource provides actionable knowledge to help you leverage Google Apps Script for both personal and professional automation.

By following this course, you’ll be able to enhance Google apps like Sheets, Docs, and Forms by integrating scripts that automate tasks, making processes more efficient and streamlined. Through examples, you will understand how to automate repetitive actions and build practical applications like email parsers and Google Calendar event creators. The course stands out by combining essential theory with practical applications, using real-world projects to bring the concepts to life. Whether you want to improve workflow automation or explore new ways to customize your Google apps, this course provides the tools you need to succeed. Ideal for those with basic JavaScript knowledge, this course will benefit anyone wanting to automate tasks in Google applications, especially those new to Google Apps Script.

In this section, we explore Google Apps Scripts for automation, custom functions in Sheets, and cloud-based integration.

What's included

2 videos3 readings1 assignment

In this section, we create buttons, menus, and message boxes in Google Sheets using Google Apps Script.

What's included

1 video3 readings1 assignment

In this section, we explore creating Gmail contacts with ContactsApp, analyzing sheet data using range and offset methods, and designing email merger applications for efficient communication.

What's included

1 video4 readings1 assignment

1 video Total 1 minute

Parsing and Sending E-mails - Overview Video 1 minute

4 readings Total 80 minutes

Introduction 20 minutes
Building the Gmail Parser Application 15 minutes
Sending E-mails Using the MailApp Service 15 minutes
Forwarding E-mails if the Specific Keyword is Found in the Message Body 30 minutes

1 assignment Total 10 minutes

Email Automation and Spreadsheet Management 10 minutes

In this section, we create interactive forms using FormApp and HtmlService, integrate spreadsheet data for dynamic options, and utilize doGet and doPost for form submissions.

What's included

1 video5 readings1 assignment

1 video Total 1 minute

Creating Interactive Forms - Overview Video 1 minute

5 readings Total 95 minutes

Introduction 20 minutes
Publishing the Script as a Web Application 10 minutes
Creating a Form Using HtmlService 30 minutes
Creating Forms Using Add-ons CSS and jQuery Libraries 15 minutes
Creating a Ticket Reservation Application 20 minutes

1 assignment Total 10 minutes

Interactive Form Development Essentials 10 minutes

In this section, we explore creating calendar events with CalendarApp, enabling advanced Google services, and building Drive applications with DriveApp for efficient task automation.

What's included

1 video4 readings1 assignment

1 video Total 1 minute

Creating Google Calendar and Drive Applications - Overview Video 1 minute

4 readings Total 80 minutes

Introduction 15 minutes
Enabling Advanced Google Services 20 minutes
Syncing Events from One Calendar to Another Calendar 30 minutes
Creating a Drive File Routing Application 15 minutes

1 assignment Total 10 minutes

Mastering Google Drive and Calendar Automation 10 minutes

In this section, we explore creating web search, feed reader, and translation applications using UrlFetchApp and LanguageApp classes. Key concepts include API integration, data parsing, and real-world application development.

What's included

1 video4 readings1 assignment

1 video Total 1 minute

Creating Feed Reader and Translator Applications - Overview Video 1 minute

4 readings Total 110 minutes

Introduction 30 minutes
Logging Bitcoin Quotes 30 minutes
Using Optional Parameters with the UrlFetchApp Class 30 minutes
Creating a Document Reviewing and Instant Inline Commenting Application 20 minutes

1 assignment Total 10 minutes

Feed Reader and Translator Fundamentals 10 minutes

In this section, we explore creating web apps to render Sheet data as HTML, send HTTP/HTTPS requests with query strings, and generate RSS feeds using Google Apps Script.

What's included

1 video3 readings1 assignment

In this section, we implement a workflow application using Google Sheets for order processing. We cover structured data handling, user input, and automated email notifications for real-world efficiency.