Skip to content

Google apps script to send two custom HTML messages to anyone automatically.

Notifications You must be signed in to change notification settings

john0isaac/Google-Apps-Script-Send-Custom-Emails

Repository files navigation

Google Apps Script Send Custom Emails

Using Google apps script on a google sheet to send two custom html messages to anyone automatically.

Overview:

Google Sheets Image

HTML Templates

This repo contains two html templates you can change whatever you want in them but to ease the process I created a JSON object Named changes which contains what you need to change per email.

  • Welcome Email Welcome Email Screenshot
  • Feedback Email Feedback Email Screenshot

Steps

Step 1

  • Open Google Drive
  • Create a new Google Sheet
  • Name it whatever you want Step 1 Screenshot

Step 2

  • Inside your spreadsheet
  • Add two columns Name, Email
  • Add your first name and email to try this script
  • Open the Script editor from the navigation menu
  • Tools -> Script editor Step 2 Screenshot

Step 3

  • Inside your Script editor
  • Replace all the code in Code.gs with the code in Code.gs
  • Save the Script
  • Name it whatever you want Step 3 Screenshot

Step 4

  • Inside your Script editor
  • Create two HTML files from File -> New -> HTML file
  • Name the first one Welcome-Email
  • Name the second one Feedback-Email
  • Replace all the code in Welcome-Email.html with the code in Weclome-Email.html
  • Replace all the code in Feedback-Email.html with the code in Feedback-Email.html
  • Save both files Step 4 Screenshot

Step 5

  • Inside your Script editor
  • Go to Code.gs
  • Adjust your range "A2:B2"
  • Write your chapter's Name
  • Write the number of the event
  • Write the day of the event
  • Write the time of the event
  • Place your event's link
  • Place your chapter's Website link
  • Write the Powered by phrase
  • Change the Subject of the Email to be sent
  • Save the file Step 5 Screenshot

Step 6

  • Inside your Script editor
  • Choose the Function you want to run
  • Press Play button
  • Authinticate it and you are ready to go
  • Check your email to find the output of what you have just done Step 6 Screenshot Step 6 Screenshot

Each time you only need to add the emails and names to your spreadsheet then repeat Step 5, Step 6.

Learning

This repository contains a LEARN.md which users can learn and understand how the project works.

Through this, users can even potentially move on to contributing and improving the project.

Contribution

How to contribute to the project?

While contributing, it must be necessary that each contributor keeps in mind the Code Of Conduct.

This repository is open for everyone to contribute and is maintained by John Aziz.