Schedule emails in Google Sheets with Google script and HTML

5 classificações
oferecido por
Coursera Project Network
Neste projeto guiado, você irá:

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
CloudSem necessidade de download
VideoVídeo em tela dividida
Comment DotsInglês
LaptopApenas em desktop

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.

Habilidades que você desenvolverá

Google ScriptSpreadsheetHtmlBusiness AnalysisData Analysis

Aprender passo a passo

Em um vídeo reproduzido em uma tela dividida com a área de trabalho, seu instrutor o orientará sobre esses passos:

  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.

Como funcionam os projetos guiados

Sua área de trabalho é um espaço em nuvem, acessado diretamente do navegador, sem necessidade de nenhum download

Em um vídeo de tela dividida, seu instrutor te orientará passo a passo

Perguntas Frequentes – FAQ

Perguntas Frequentes – FAQ

Mais dúvidas? Visite o Central de Ajuda ao Aprendiz.