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.
Learning Google Apps Script - Automate Google Apps
Enjoy unlimited growth with a year of Coursera Plus for $199 (regularly $399). Save now.
Learning Google Apps Script - Automate Google Apps
Instructor: Packt - Course Instructors
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
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
Details to know
Shareable certificate
Add to your LinkedIn profile
Recently updated!
December 2025
Assessments
9 assignments
Taught in English
See how employees at top companies are mastering in-demand skills
There are 9 modules in this course
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
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
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
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
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.
What's included
1 video3 readings1 assignment
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
Instructor
Offered by
Explore more from Software Development
Status: Free TrialGoogle Cloud
Google Cloud
Why people choose Coursera for their career
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."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
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."
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.
More questions
Financial aid available,