Create tailored marketing emails from purchase and feedback data, then decide if a coupon should be included to win back unhappy customers. Ideal for marketing teams that want fast, human sounding email copy with simple privacy controls. The flow uses AI to write the headline and body, and uses a clear check to avoid empty or broken emails.

The run starts with a manual trigger. Sample data is downloaded and read from an xls file. Campaign options are set so the AI follows your tone and goal. A LangChain Information Extractor with an OpenAI Chat Model generates the headline, the email text, and a Yes or No coupon choice without sending personal data in the prompt. Results are merged with the source row and validated. If anything is missing, the error path stops the send. A branch picks the right HTML template based on the coupon decision. A fake coupon code is added for testing or replaced with your real system. The final email is built and sent over SMTP.

You only need an OpenAI API key and an SMTP server. Map your data columns to match Item Purchased and Feedback, adjust campaign options, and customize both HTML templates. Expect less manual writing time and more consistent recovery messages. Useful for post purchase follow ups, service recovery, and targeted win back campaigns.

• Manual trigger lets you test and run the flow on demand.
• HTTP Request downloads sample data and Extract From File reads xls rows.
• Campaign options node controls tone, target, and message style.
• LangChain Information Extractor with OpenAI writes headline, body, and a Yes or No coupon decision.
• Merge nodes combine AI output with source data for a complete record.
• If node validates required fields and routes failures to a Stop and Error path.
• Branching chooses between a no coupon template and a coupon template.
• Fake coupon node provides a placeholder code you can replace with a real generator.
• SMTP email node sends the final HTML message to the customer.

• Reduce manual drafting from 2 hours to 10 minutes per campaign.
• Automate up to 80 percent of repetitive email assembly.
• Recover more unhappy customers with timely coupon offers.
• Prevent empty or broken emails with built in validation.
• Lower privacy risk by keeping personal data out of AI prompts.
• Send consistent HTML emails using two ready templates.

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 OpenAI and SMTP. See the Tools Required section above for links to create accounts with these services.
3. Open the OpenAI Chat Model node, choose Credential to connect with, click Create new credential, then enter your OpenAI API key from your OpenAI account API page. Save the credential.
4. Open the Send Email node, choose Credential to connect with, click Create new credential, then enter your SMTP host, port, username, password, and From email. Save and test the connection.
5. In the Download dummy data node, keep the sample URL or replace it with your own file link. Make sure the file is reachable by n8n Cloud.
6. In Extract from File, confirm operation is xls and the sheet has columns for Item Purchased and Feedback. Update the field names if your file uses different labels.
7. Open Some Options for the Campaign and adjust target, tone, and other fields to guide the AI output.
8. Open the Information Extractor node. Review the system prompt and the schema so it returns Headline, Text, and a clear Yes or No for the coupon decision.
9. Customize Html Template for our Email and Html Template for our Email with a Coupon with your brand, colors, footer, and links.
10. Click Execute Workflow. Inspect the AI Output + Prev Data and Is the result valid nodes to confirm headline, text, and coupon decision are present.
11. If AI fails or fields are empty, reduce temperature, simplify the prompt, or check your OpenAI quota. The AI did fail us node shows the error path.
12. Send a test email to a safe inbox and review formatting, links, and coupon visibility. Adjust templates as needed.
13. Replace the Fake coupon node with your real coupon generator or API when moving to production.