Get and prepare Dummy Data
Configured with Email Send, Extract From File, Html, HTTP Request, and additional nodes. Review the connections and setup before adapting this template.
Node categories in this workflow
- Trigger
- Transform
- AI & models
- Routing
- Web / API
- Messaging
Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.
Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.
How it works
The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.
| Node | Category | Type | Operation |
|---|---|---|---|
| When clicking "Execute Workflow" | Trigger | Manual Trigger | See node parameters |
| Extract from File | Transform | Extract From File | xls |
| Some Options for the Campaign | Transform | Edit Fields | See node parameters |
| Information Extractor | AI & models | Information Extractor | See node parameters |
| OpenAI Chat Model1 | AI & models | OpenAI Chat Model | See node parameters |
| AI did fail us1 | Routing | Stop And Error | See node parameters |
| Fake coupon | Transform | Edit Fields | See node parameters |
| Download dummy data | Web / API | HTTP Request | See node parameters |
| AI Output + Prev Data | Transform | Merge | See node parameters |
| Is the result valid? | Routing | If | See node parameters |
| Coupon them or not to Coupon them | Routing | If | See node parameters |
| Html Template for our Email | Transform | Html | See node parameters |
| The composed E-Mail + Prev Data | Transform | Merge | See node parameters |
| Html Template for our Email with a Coupon | Transform | Html | See node parameters |
| The composed E-Mail with Coupon + Prev Data | Transform | Merge | See node parameters |
| Send Email | Messaging | Email Send | See node parameters |
Setup
- Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
- Connect your own credentials through n8n’s credential store. Replace
REPLACE_WITH_*values with your resource identifiers. - Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
- Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.
Requirements
An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.
Credential types declared in the source
openAiApismtp
Workflow notes
Let GPT do the heavy work
Let GPT do the heavy work
For the prompt we follow the one-shot'ish principle. Also I've decided to NOT give the AI the personal data. Keeps it simpler regarding data privacy.
The AI-Chain will generate a Headline and the Text for the Email and even decides if we should send the user a Coupon.
Make sure we have what we need
Make sure we have what we need
We do not want to sent empty messages to our customers
Mocked: Fake a Coupon Code
Mocked: Fake a Coupon Code
For a real life scenario add the automated coupon generation here
Documentation
Documentation
This Workflow is for the n8n AI / Langchain Competition.
It solves the Problem: Personalizing marketing emails based on customer purchase history.
I've found it a bit ambiguous and decided to go the "Convert unhappy customers with a Coupon"-Route.
So this workflow utilizes the new LangChain Node for generating personalized E-Mail campaigns and decide if the user might need a coupon to be satisfied. Classic Rebound stuff.
There is also a Node "Some Options..." which can be adjusted to quickly change the direction this Campaign should go.
Additionally we use n8n to generate the HTML Mails by two different Templates. One with simple text and another for that Coupon handling.
Enjoy the Workflow! ❤️ https://let-the-work-flow.com
Send the Email to the Customer
Send the Email to the Customer
Although it's cool that n8n allows sending emails via SMPT I would recommend to stick to your newsletter tool for that to keep track of opt-outs and stuff.
Get and prepare Dummy Data
Get and prepare Dummy Data
Purpose and structure
This folder contains the Get and prepare Dummy Data workflow. Its executable nodes use emailSend, extractFromFile, html, httpRequest, if, informationExtractor, lmChatOpenAi, manualTrigger, merge, set, stopAndError. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.
Setup
Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.
Entry points
When clicking "Execute Workflow"
Verification
Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.
Attribution
https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Stopanderror/0331_Stopanderror_Extractfromfile_Send_Webhook.json MIT; preserve source notices.
Canvas section labels
These name areas of the original canvas; they do not include explanatory instructions.
- Get and prepare Dummy Data
- HTML Email-Template without Coupon
- HTML Email-Template with Coupon