Schedule emails in Google Sheets with Google script and HTML

4.4
5 个评分
提供方
Coursera Project Network
在此指导项目中,您将:

Create a table with HTML from a Google Sheet table.

Apply a script to import data dynamically from a google sheet into an email automatically.

Clock1 Hour
Beginner初级
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

By the end of this project, you will design automated mails of spreadsheets using Google script and HTML. In this project, you will be able to identify the basics of HTML code, create a table in an HTML file, and add the dynamic data from google sheets to an HTML table. Finally, you will be able to schedule an automated mail to send this HTML table to any number of mail users by google sheets which is one of the major means of communication these days. Organizations and individuals send out a huge number of emails every day. Sometimes, we find ourselves in situations where we want to send emails to several people listed on a Google spreadsheet. Can you imagine having to send out an email to hundreds of people by copying and pasting it one at a time? By the end of the project, you will be able to automate this process so that it can be completed in under a minute. This guided project is for people in the field of business and data analysis. people who want to send emails to several people listed on a Google spreadsheet. It provides you with the important steps to be a google script developer. Moreover, it equips you with the knowledge in spreadsheets related to business and how to send dynamic data by mail automatically. Project Prerequisites: Familiarity with google sheets For this project, we will be using free online software called Google sheets. If you do not have a Gmail account navigate to https://www.google.com/gmail/ to set up your account. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

您要培养的技能

Google ScriptSpreadsheetHtmlBusiness AnalysisData Analysis

分步进行学习

在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:

  1.  You will be able to identify the basics of the script editor and create the HTML file.

  2. You will be able to create a table with the HTML language.

  3. You will be able to get the data from the spreadsheet dynamically through google script.

  4. You will learn to add the data in an HTML table and send the mail automatically.

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心