Bulk Emails with Personalized Attachments

This n8n workflow is designed to automate the process of sending bulk personalized emails, each with a unique attachment, to a list of recipients. It streamlines a common marketing or communication task, ensuring each recipient receives tailored content.

What it does

1. Triggers Manually: The workflow starts when manually executed.
2. Reads Spreadsheet Data: It is configured to read data from a spreadsheet file (e.g., CSV, Excel) which likely contains recipient information such as email addresses, names, and potentially file paths for personalized attachments.
3. Loops Over Items: The workflow processes each row (recipient) from the spreadsheet individually using a loop.
4. Reads Binary File: For each recipient, it reads a specific binary file, which is intended to be the personalized attachment for that email.
5. Sends Personalized Email: Finally, it sends an email to the recipient using the data from the spreadsheet and attaches the previously read binary file. This allows for personalized subject lines, body content, and unique attachments for each email.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Email Sending Credentials: SMTP credentials configured in n8n to send emails.
• Spreadsheet File: A spreadsheet file (e.g., .csv, .xlsx, .ods) containing recipient data. This file should ideally include columns for email address, name, subject, body, and attachment_path or similar.
• Attachment Files: The personalized attachment files must be accessible by the n8n instance at the paths specified in the spreadsheet.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Set up your Send Email node with the appropriate SMTP credentials.
3. Prepare Spreadsheet:
   • Create a spreadsheet file (e.g., recipients.csv) with columns for email, name, subject, body, and attachmentPath.
   • Populate it with your recipient data and the absolute or relative paths to their personalized attachment files.
4. Configure Spreadsheet File Node:
   • In the Spreadsheet File node, specify the path to your recipient spreadsheet file.
5. Configure Read Binary File Node:
   • In the Read Binary File node, ensure the "File Path" expression dynamically pulls the attachment path from the incoming item (e.g., {{ $json.attachmentPath }}).
6. Configure Send Email Node:
   • Configure the Send Email node to use dynamic data from the incoming items for fields like "To" (e.g., {{ $json.email }}), "Subject" (e.g., {{ $json.subject }}), and "Body" (e.g., {{ $json.body }}).
   • Ensure the attachment is correctly linked from the previous Read Binary File node.
7. Test and Activate:
   • Run a test execution to ensure everything is configured correctly and emails are sent as expected.
   • Once satisfied, activate the workflow.
8. Execute: Manually execute the workflow to send the bulk personalized emails.