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.