How can I personalize HTML emails using Mail Merge and Google Spreadsheets?

Question

I'm attempting to personalize an email that uses HTML coding. Basically, I've made an HTML template that I want to have say the name of a person within the HTML code as well as the subject line of the email. For example: Subject line would be "Welcome to the club [name of contact]" and within the HTML body text have [name of contact] show up again. I'm using a Google Spreadsheet that has been scripted to run mail merge. Everything runs through the document. I've put all of the contacts on the spreadsheet with the script. Is this possible to personalize this?

Answer 1

Data from a spreadsheet can be inserted into a Gmail draft email (which can contain HTML) by using the Yet Another Mail Merge add-on in Google Sheets.