VOOZH about

URL: https://www.coursera.org/learn/packt-learning-google-apps-script-automate-google-apps

⇱ Learning Google Apps Script - Automate Google Apps | Coursera

Learning Google Apps Script - Automate Google Apps

Ends soon! Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.

Learning Google Apps Script - Automate Google Apps

Included with

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
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.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

9 assignments

Taught in English

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

2 videos•Total 2 minutes
  • Course Overview•1 minute
  • Introducing Google Apps Scripts - Overview Video•1 minute
3 readings•Total 50 minutes
  • Introduction•10 minutes
  • Google Drive•10 minutes
  • Google Docs•30 minutes
1 assignment•Total 10 minutes
  • Exploring Google Apps Script Capabilities•10 minutes

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

What's included

1 video3 readings1 assignment

1 video•Total 1 minute
  • Creating Basic Elements - Overview Video•1 minute
3 readings•Total 60 minutes
  • Introduction•20 minutes
  • Showing Toast When a Button Is Clicked•10 minutes
  • Creating a Sidebar•30 minutes
1 assignment•Total 10 minutes
  • Interactive Script Elements in Google Apps Script•10 minutes

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

1 video•Total 1 minute
  • Creating Interactive Webpages - Overview Video•1 minute
3 readings•Total 70 minutes
  • Introduction•30 minutes
  • Sending an HTTP/HTTPS Request with Query String•20 minutes
  • Creating an Employee Timesheet Application•20 minutes
1 assignment•Total 10 minutes
  • Dynamic Web Content and User Interaction•10 minutes

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.

What's included

1 video3 readings1 assignment

1 video•Total 1 minute
  • Building a Workflow Application - Overview Video•1 minute
3 readings•Total 90 minutes
  • Introduction•30 minutes
  • Enhancing the Order Form•30 minutes
  • Creating the Dispatch Form•30 minutes
1 assignment•Total 10 minutes
  • Building and Managing Workflow Applications•10 minutes

In this section, we learn to implement triggers for script timeouts, use external libraries, and create add-ons.

What's included

1 video3 readings1 assignment

1 video•Total 1 minute
  • More Tips and Tricks and Creating an Add-on - Overview Video•1 minute
3 readings•Total 70 minutes
  • Introduction•20 minutes
  • Using JSDoc Annotations•20 minutes
  • Creating an Add-on That Uses an OAuth2 External Library•30 minutes
1 assignment•Total 10 minutes
  • Mastering Add-on Development and Script Controls•10 minutes

Instructor

Offered by

Why people choose Coursera for their career

👁 Image

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
👁 Image

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
👁 Image

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
👁 Image

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions

Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.

If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.

Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.

If you complete the course successfully, your electronic Course Certificate will be added to your Accomplishments page - from there, you can print your Course Certificate or add it to your LinkedIn profile.

This course is currently available only to learners who have paid or received financial aid, when available.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Financial aid available,