Create Certificates and Mail Merge
应用详情更新日期:2024年4月25日
适用于:
4万+
概览
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. Or you can only save them in your google drive without e-mailing them if you did not specify an e-mail address.

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

 Full Name, 
 Course Code, 
 Exam Score,
 E-mail Address,
 Month

Prepare the Spreadsheet Columns as:
 
Full Name	Exam Score	E-mail Address	Course Code  Month

Set the name of the first sheet as Sheet1 and the second sheet as Email Template
																		
You need to add the required field in the template slide as:
{{FullName}}
{{CourseCode}} 
{{ExamScore}}
{{Month}}


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

Updates (v3):
Create another folder for saving copies of the certificates as pdf.

Updates (v2):
you can write your E-mail template in the way you want. 
You can prepare your certificates and send them by e-mail and save the copy in your Google drive Or you can only save them in Google drive without sending any e-mail, if there's no written e-mail address. 

This is a spreadsheet add-on, that means using the CertiMerge can be done by installing the add-on using a spreadsheet. 
其他信息
定价未提供
开发者
CertiMerge”将请求获得以下权限。了解详情
CertiMerge”将需要访问您的 Google 账号
这样可让CertiMerge
在 Google 文档中创建文档,以及查看、修改和删除您在 Google 文档中的所有文档
查看、修改、创建和删除您的所有 Google 云端硬盘文件
查看和管理您的 Google 云端硬盘中的表单
在 Google 幻灯片中创建演示文稿,以及查看、修改和删除您在 Google 幻灯片中的所有演示文稿
在 Google 表格中创建电子表格,以及查看、修改和删除您在 Google 表格中的所有电子表格
以您的名义发送电子邮件
查看您的 Google 账号的主电子邮件地址
查看您的个人信息,包括您已公开的任何个人信息
评价
语言:
排序依据:
Google 不会核实评价或评分。 详细了解评价
没有评论
搜索
清除搜索内容
关闭搜索框
Google 应用
主菜单