|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-google-apps-script-course/
课程评论：没有评论
课程名称：Google Apps Script 邮件发送和 PDF 制作（基于文档模板） 概述：本课程要求学员具备 JavaScript 基础知识！本课程演示了如何应用 Google Apps Script 创建一个节省时间的微型应用程序，利用 GSuite 应用程序相互连接以实现惊人的功能。代码源文件会随课程提供。 如果你需要将一批自定义的 PDF 文件发送给一组电子邮件收件人，并且这些信息已经在 Google 表格中列出，使用简单的脚本来完成这一操作会方便得多。本课程内容如下： 1. 创建一个电子表格，列出姓名和电子邮件地址。 2. 创建一个 Google 文档作为模板，包含姓名和数据字段。 3. 编写 Google Apps Script 代码。 4. 利用 Google Apps Script 从电子表格中提取所有数据。 5. 遍历数据，将字段填充到 Apps Script 创建的新 Google 文档中。 6. 从 Google 文档生成 PDF，并保存到你的云端硬盘（可选）。 7. 将填充后的 PDF 从模板发送到电子表格中列出的电子邮件地址。 这整个过程都可以通过一个简单的 Google Script 完成。Google Apps Script 是一种基于云的 JavaScript 语言，可以为你的 GSuite 提供强大功能，帮助你节省时间，非常适合让你的同事惊艳不已。本课程由具有多年真实世界网络开发经验的 Google 开发者专家授课！ 请注意，这是一个基于项目的课程，节奏较快，专注于上述项目内容。
JavaScript is a prerequisite to this course!!!!!!!! The course demonstrates Applying Google Apps Script to create a time saving micro application making use of GSuite apps connected together to produce amazing functionality.Source Code is includedDo you need to send a bunch of custom PDFs to a group of email recipients - of course you already have it listed in a Google Spreadsheet. Wouldn't it be nice if this could be done with a simple script. You're in luck!Create a spreadsheet list out the first name, last name and email of the person.Create a Google Doc which can be used as a template with firstname lastname and data fieldsNow the fun part - coding with Google Apps Script.Use Google Apps Script to list all the data from the spreadsheetLoop through the data populating the fields into new Google Doc created by Apps ScriptCreate a PDF from the Google Doc - Save to your drive if you want!Send out the new PDF from the template with populated fields from the spreadsheet to the emails listed in the SpreadsheetThats it all done with a simple Google Script.Google Apps Script is a cloud based JavaScript Language that lets you power up your Gsuite and do some unbelievable things - saving you time. Like magic - great to amaze your coworkers:)Taught by an instructor with many years of REAL World web development - Google Developer Expert!!!Please note that this is a project based course and is fast paced focused on the project that is outlined in this description.
