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:





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.