Send course certificates to many people in one run. Ideal for training teams, schools, and events that need simple bulk delivery. Each person gets the right file and a clear subject line.

The run starts by clicking execute. A CSV file is read and turned into rows using the spreadsheet node with a header row. Records move in batches of five to control send rate. For each row, the flow builds a file path from the person’s name, loads the matching PNG certificate, and attaches it to an email. The email goes out through your SMTP account and uses the email column from the data.

Setup is simple. Keep the CSV header names consistent, such as name and email, and name each certificate image to match the name field. Adjust the batch size to fit your server limits. Expect strong time savings and fewer mistakes compared to manual sends. This fits graduation days, internal training completions, and workshop follow ups where you want fast, correct delivery without copy and paste work.

• Manual start gives full control over when messages are sent
• Reads a local CSV and converts it into rows with header support
• Processes contacts in batches of five to pace delivery
• Builds a certificate file path from each person’s name
• Loads the PNG certificate and attaches it to the email
• Sends personalized emails using your SMTP credentials
• Maps the recipient address from the email column in the data
• Custom subject and from address for clear, branded communication

• Reduce manual work from hours to minutes by sending all certificates in one run
• Automate up to 90 percent of repetitive email tasks for certificate delivery
• Cut attachment mistakes by matching files to names from the CSV
• Control send rate with batch size to avoid email server limits
• Scale to large groups by adding more rows to the CSV without extra effort

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with SMTP. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create a new SMTP credential. Add your SMTP host, port, username, and password. Choose the correct encryption option offered by your provider and save.
4. Open the Send Email node and select the SMTP credential you created. Set the From email and confirm the Subject text.
5. Open the Read Binary File node that loads the CSV. Update the file path to point to your local CSV file and keep the binary property name consistent.
6. Open the Spreadsheet File node. Set the binary property name to the same key from the previous node and make sure Header Row is enabled so column names map correctly.
7. Open the Split In Batches node and set the batch size. Start with five and adjust based on your email provider’s rate limits.
8. Open the second Read Binary File node for certificates. Set the file path pattern to your certificates folder and use the name field from the row so the correct PNG is loaded.
9. In the Send Email node, confirm the To field uses the email column from the parsed data. Check that the attachment points to the binary data from the certificate file node.
10. Run a small test with one or two rows. Confirm that each email is received with the right file and the correct recipient address.
11. If a send fails, check file paths, confirm the CSV has name and email columns, and verify your SMTP host, port, and encryption settings. Adjust batch size if you hit rate limits.
12. Once tests pass, load the full CSV and execute the workflow. Monitor the run and confirm delivery in your email service logs.