Learning Google Apps Script - Automate Google Apps

Learning Google Apps Script - Automate Google Apps

位教师：Packt - Course Instructors

访问权限由 New York State Department of Labor 提供

9个模块

深入了解一个主题并学习基础知识。

中级等级

推荐体验

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

9个模块

深入了解一个主题并学习基础知识。

中级等级

推荐体验

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将学到什么

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.

您将获得的技能

要了解的详细信息

可分享的证书

添加到您的领英档案

作业

9 项作业

授课语言：英语（English）

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

该课程共有9个模块

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.

涵盖的内容

2个视频3篇阅读材料1个作业

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

涵盖的内容

1个视频3篇阅读材料1个作业

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.

涵盖的内容

1个视频4篇阅读材料1个作业

1个视频总计1分钟

Parsing and Sending E-mails - Overview Video 1分钟

4篇阅读材料总计80分钟

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

1个作业总计10分钟

Email Automation and Spreadsheet Management 10分钟

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.

涵盖的内容

1个视频5篇阅读材料1个作业

1个视频总计1分钟

Creating Interactive Forms - Overview Video 1分钟

5篇阅读材料总计95分钟

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

1个作业总计10分钟

Interactive Form Development Essentials 10分钟

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

涵盖的内容

1个视频4篇阅读材料1个作业

1个视频总计1分钟

Creating Google Calendar and Drive Applications - Overview Video 1分钟

4篇阅读材料总计80分钟

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

1个作业总计10分钟

Mastering Google Drive and Calendar Automation 10分钟

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.

涵盖的内容

1个视频4篇阅读材料1个作业

1个视频总计1分钟

Creating Feed Reader and Translator Applications - Overview Video 1分钟

4篇阅读材料总计110分钟

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

1个作业总计10分钟

Feed Reader and Translator Fundamentals 10分钟

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.

涵盖的内容

1个视频3篇阅读材料1个作业

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.