CertiMerge

Make Certificate and Mail Merge in your domain.

This add-on will enable the user to create a CERTIFICATE to the number of users based on the given spreadsheet and template slide. The prepared certificates will be stored in the Google Drive inside the created folder with e-mailing them as pdf to each user.

You can add various details to the certificate from a spreadsheet columns. This includes:

 Full Name, 

 Course Code, 

 Exam Score,

 Address Mail

You need to add the required field in the template slide as:

{{FullName}}

{{CourseCode}}, 

 {{ExamScore}},

 {{AddressMail}}

To send a subject and body mail, then all you need is to put them in cell A1 of the second sheet with adding the name of the user as ${"Full Name"}.

This is a spreadsheet add-on, that means using the CertiMerge can be done by installing the add-on using a spreadsheet.