Bulk Personalized Emails with Custom Attachments

This workflow enables efficient bulk emailing of personalized messages with individual attachments. It starts by reading a pre-formatted CSV file containing student email addresses and corresponding attachment filenames (e.g., certificate PNGs). The CSV is parsed into structured JSON data, then split into batches of 5 for controlled processing to avoid overwhelming email servers.

For each record in the batch, the workflow dynamically reads the specified binary attachment file from a directory (e.g., /home/shashikanth/Documents/Cert-Gen-Test/generator-output/{{$json["name"]}}.png). It then sends a personalized email via SMTP with the attachment, using a fixed subject like 'Certificate For Course' and the student's email as the recipient.

Benefits include significant time savings for educators or admins handling enrollments—eliminating manual emailing of hundreds of certificates. It's scalable, error-resistant with batching, and customizable for paths/credentials. Use cases: student certificate issuance, enrollment confirmations, course completion notifications, or any bulk personalized outreach in education or marketing.