I'll provide you with automated custom emails using app script and html.
I'll convert the provided email template to html and make it dynamic using google sheet data. So you'll have the flexibility to send single email according to your template or multiple emails to different recipients at once.
The formatting, colors, table everything in the email body can be dynamic upon request to get formatting from google sheet.