Schedule emails in Google Sheets with Google script and HTML

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
Comment Dots英语(English)

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 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.






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