One of the most commonly asked for Google Apps Script Projects is How to Send custom HTML emails using Apps Script. This lesson will demonstrate how to code in Google Apps Script and create functionality to send custom HTML templated emails to a list of users within your Google Spreadsheet data. Also updating the spreadsheet data.
100+ Google Apps Script Example Projectshttps://www.udemy.com/course/course-apps-script/
Complete Apps Script Course https://www.udemy.com/course/apps-script-course/
Source Code is at
https://github.com/lsvekis/Google-Apps-Script/tree/main/Apps%20Script%20Emailer