|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-script-apps-project/
课程评论:没有评论
课程名称:谷歌脚本应用程序:从电子表格列表发送电子邮件 课程概述: 该课程旨在教授如何使用谷歌应用脚本创建一个简单而强大的应用程序,将您的谷歌套件整合在一起。您将学习使用谷歌应用脚本在电子表格中创建高级功能,管理用户列表,并通过电子邮件发送确认信息,跟踪已发送的邮件。课程中还将教您如何创建自定义的HTML模板邮件,并通过电子表格UI菜单添加按钮来管理电子表格数据。您会惊讶于如何轻松创建出强大的功能,提升您的谷歌套件产品的效用。 课程要求: 参与者需具备JavaScript基础知识。课程涵盖如何应用谷歌应用脚本构建项目应用,并涉及以下内容: - 向电子表格UI菜单添加触发谷歌应用脚本功能的项目 - 从电子表格中选择用户活动单元格的内容 - 创建用于发送邮件的HTML模板 - 使用提示来接受用户操作 - 更新电子表格数据的值 - 选择范围并更新该范围内的内容 - 从电子表格中获取内容 - 使用谷歌应用脚本发送电子邮件 课程包括源代码,您可以复制粘贴代码进行练习。学习过程为循序渐进,并提供友好的支持,您可以在问答区提出问题。讲师拥有超过20年的经验,随时准备帮助您学习。加入课程,开始创建您自己的有用应用程序吧!
Explore how you can create a simple powerful application with Google Apps Script that connects your Google Suite togetherUse Google Apps Script to create advanced functions within your spreadsheetUse the spreadsheet to manage a user list, click the members on the list and send out confirmation emails. Track emails that have been sent. Create your own custom HTML template mail that gets sent to the users on the list. Use the spreadsheet UI menu to add buttons for administration of the spreadsheet data. You will be amazed at how easy it is to create powerful functionality that helps power up your Google Suite of products.JavaScript is a prerequisite to this course.Course covers applying Google Apps Script to build a project application.Add items to the spreadsheet UI menu that can trigger functions in Google Apps ScriptSelect user active cell content from the spreadsheetCreate HTML template to send emailUse Alerts to accept user actionsUpdate values of the spreadsheet dataSelect ranges and update content in the rangeGet content from the spreadsheetSend email from Google Apps ScriptGoogle Script Apps Email From Spreadsheet list Source code is included so you can copy and paste the code to try for yourself.Step by step learningFast friendly support is always available within the Q & A sectionExperienced instructor with over 20 years of experience ready to help you learnYou have nothing to lose - Join now and start learning to create your own version of this helpful application today!!!