(Use Case) Automatic Issuance of Training Completion Certificates

Date of creation
Name
(Use Case) Automatic Issuance of Training Completion Certificates
Created by
  • data_popcorn

1. Workflow Overview

The n8n workflow is an automated system that generates and sends student certificates .
Characteristic:
โ€ข
Retrieve and transfer student data from the n8n unified datastore.
โ€ข
Upload a certificate template image and insert the student's name and authentication information.
โ€ข
After your certificate is generated, it will be automatically sent to your email.
This workflow streamlines automation and streamlines the certificate issuance process.

2. Preparation in advance

To run this workflow, you need to prepare the following:
โœ… Gmail OAuth2 integration (required to send certificates via Gmail from n8n)
โœ… Connect to n8n Training Customer Datastore (enables loading student information from n8n's datastore)
โœ… Install Google Fonts (required to use Courier New, Comic Sans MS fonts)

3. Main functions and roles

๐Ÿ“Œ Node List and Roles

1.
When clicking 'Test workflow' (Manual Trigger)
โ€ข
Trigger that runs when a workflow starts
2.
Customer Datastore (n8n training)
โ€ข
Role in retrieving student data from n8n
3.
Get Email & Name (Set Node)
โ€ข
Extract student's name and email
4.
Generate Crypto (Generate UUID)
โ€ข
Generate a unique ID for your certificate information
5.
Load Image (HTTP Request)
โ€ข
Load certificate template image
6.
Write Text(name) / Write Text(uuid) (Edit Image)
โ€ข
Create a certificate by inserting student name and UUID into the image
7.
Send Email (Gmail Node)
โ€ข
Automatically send generated certificates to your email

4. How it works (step by step explanation)

1๏ธโƒฃ Import student data - Retrieve name and email information from n8n Training Customer Datastore
2๏ธโƒฃ
Generate UUID - Create a unique ID for each certificate
3๏ธโƒฃ
Load the certificate template image - via HTTP request
4๏ธโƒฃ
Insert name and UUID into image
5๏ธโƒฃ
Send your certificate via Gmail

5. Expected Results and Output

โ€ข
Upon successful execution, a certificate image will be sent to the student's email.
โ€ข
Example of email sent :
๊น€์ฒ ์ˆ˜ ๋‹˜, ๊ท€ํ•˜๋Š” ๋ณธ ๊ต์œก๊ณผ์ •์„ ์„ฑ๊ณต์ ์œผ๋กœ ์ˆ˜๋ฃŒํ•˜์˜€์Œ์„ ์ธ์ฆํ•ฉ๋‹ˆ๋‹ค. ์ˆ˜๋ฃŒ์ผ์ž: 2025.02.22 ๋ฐ์ดํ„ฐํŒ์ฝ˜ ๋“œ๋ฆผ
โ€ข
How to Share Your Certificate : You can download and share your certificate via that email.