ishmam156/automateemailfromgooglesheets

A simple script that runs on Google Apps Script which collects your raw data from a Google Sheet, formats it as per the sheet and then sends out as a an email to a selected group either at a regular interval or with the click of a button.

Automate Email Sending from Google Sheets with 1 click - HTML & JavaScript

A simple script that runs on Google Apps Script which collects your raw data from a Google Sheet, formats it as per the sheet and then sends out as a an email to a selected group either at a regular interval or with the click of a button.

---

Tutorial

Click to view

This repo contains the following:

• JavaScript code that automates the email sending process
• HTML template that helps format the final email as per the Google Sheet

The code provided in this repo will work on the specific table that has been shown here as sheetsRawData and you will need to alter the JavaScript as well as HTML template to suit your particular use case.

Google Sheets Format

Email Format

Acknowledgements

• Spreadsheet Dev

The tutorial is based on the great article from Spreadsheet Dev and has been further customized to highlight a particular use case.

License

ISC

Authors

• Ishmam Chowdhury

Contributing

Contributions are always welcome!

Kindly do a pull request with your contribution.

Feedback

If you have any feedback, please reach out to me in GitHub.