Schedule emails in Google Sheets with Google script and HTML

10 ratings
Offered By
Coursera Project Network
In this Guided Project, you will:

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
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

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.

Skills you will develop

Google ScriptSpreadsheetHtmlBusiness AnalysisData Analysis

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  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.

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.