Repository files navigation

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

• HTML Templates
• Steps
• Learning
• Contribution

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
• Feedback Email

• OpenGoogle Drive
• Create a new Google Sheet
• Name it whatever you want

• 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

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

• 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 inWeclome-Email.html
• Replace all the code in Feedback-Email.html with the code inFeedback-Email.html
• Save both files

• 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

• 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

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

This repository contains aLEARN.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.

How tocontribute to the project?

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

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