About this recipe
A recipe for Modular & Customizable Ai Powered Email Routing Text Classifier For Ecommerce
Recipe Template
{
"id": "LGpVLWPpNZSt9ISM",
"meta": {
"instanceId": "a4bfc93e975ca233ac45ed7c9227d84cf5a2329310525917adaf3312e10d5462",
"templateCredsSetupCompleted": true
},
"name": "Contact Form Text Classifier for eCommerce",
"tags": [],
"nodes": [
{
"id": "13175d48-c3a6-4ca6-afed-b70f40289f38",
"name": "On form submission",
"type": "n8n-nodes-base.formTrigger",
"position": [
-480,
-320
],
"webhookId": "8e10c8ca-895c-4274-ba95-0d646b8bda4e",
"parameters": {
"options": [],
"formTitle": "Contacts",
"formFields": {
"values": [
{
"fieldLabel": "Name",
"placeholder": "Name",
"requiredField": true
},
{
"fieldLabel": "Email",
"placeholder": "Email",
"requiredField": true
},
{
"fieldType": "textarea",
"fieldLabel": "Message",
"placeholder": "Message",
"requiredField": true
}
]
},
"responseMode": "lastNode",
"formDescription": "Basic Contact Form"
},
"typeVersion": 2.2
},
{
"id": "7b352c9f-5d2e-46ca-9499-594063167e9a",
"name": "Text Classifier",
"type": "@n8n\/n8n-nodes-langchain.textClassifier",
"position": [
-160,
-320
],
"parameters": {
"options": {
"fallback": "other",
"systemPromptTemplate": "=Please classify the text provided by the user into one of the following categories: {categories}, and use the provided formatting instructions below. Don't explain, and only output the json with the selected {categories}."
},
"inputText": "={{ $json.Message }}",
"categories": {
"categories": [
{
"category": "Request Quote",
"description": "Request for quote"
},
{
"category": "Product info",
"description": "General information about a product"
},
{
"category": "General problem",
"description": "General problems about a product"
},
{
"category": "Order",
"description": "Information about an order placed"
}
]
}
},
"typeVersion": 1
},
{
"id": "efef4c71-5f56-44b0-a613-9fa888e495b8",
"name": "OpenAI",
"type": "@n8n\/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-220,
-100
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini",
"cachedResultName": "gpt-4o-mini"
},
"options": []
},
"credentials": {
"openAiApi": {
"id": "CDX6QM4gLYanh0P4",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "83f0d528-884c-4701-8fdd-dc07c05fafb5",
"name": "Prod. Dep.",
"type": "n8n-nodes-base.emailSend",
"position": [
320,
-540
],
"parameters": {
"html": "=Name: {{ $json.Name }}\nEmail: {{ $json.Email }}\n\nMessage:\n{{ $json.Message }}\n\nTipo prodotto: {{ $json[\"tipo prodotto\"] }}",
"options": {
"replyTo": "={{ $json.Email }}"
},
"subject": "=[n8n Contacts] Product info",
"toEmail": "to@domain.com",
"fromEmail": "from@domain.com"
},
"credentials": {
"smtp": {
"id": "hRjP3XbDiIQqvi7x",
"name": "SMTP info@n3witalia.com"
}
},
"typeVersion": 2.1
},
{
"id": "88486500-dcea-4db9-9ffd-f55193eaa83d",
"name": "Quote Dep.",
"type": "n8n-nodes-base.emailSend",
"position": [
320,
-780
],
"parameters": {
"html": "=Name: {{ $json.Name }}\nEmail: {{ $json.Email }}\n\nMessage:\n{{ $json.Message }}\n\nTipo prodotto: {{ $json[\"tipo prodotto\"] }}",
"options": {
"replyTo": "={{ $json.Email }}"
},
"subject": "=[n8n Contacts] Quote",
"toEmail": "to@domain.com",
"fromEmail": "from@domain.com"
},
"credentials": {
"smtp": {
"id": "hRjP3XbDiIQqvi7x",
"name": "SMTP info@n3witalia.com"
}
},
"typeVersion": 2.1
},
{
"id": "f6a63c4f-ee2e-42f1-a12c-b1fc6cf48f94",
"name": "Gen. Dep.",
"type": "n8n-nodes-base.emailSend",
"position": [
320,
-320
],
"parameters": {
"html": "=Name: {{ $json.Name }}\nEmail: {{ $json.Email }}\n\nMessage:\n{{ $json.Message }}\n\nTipo prodotto: {{ $json[\"tipo prodotto\"] }}",
"options": {
"replyTo": "={{ $json.Email }}"
},
"subject": "=[n8n Contacts] General",
"toEmail": "to@domain.com",
"fromEmail": "from@domain.com"
},
"credentials": {
"smtp": {
"id": "hRjP3XbDiIQqvi7x",
"name": "SMTP info@n3witalia.com"
}
},
"typeVersion": 2.1
},
{
"id": "04a3e144-af75-4a95-819f-d5f1d4591b67",
"name": "Order Dep.",
"type": "n8n-nodes-base.emailSend",
"position": [
320,
-80
],
"parameters": {
"html": "=Name: {{ $json.Name }}\nEmail: {{ $json.Email }}\n\nMessage:\n{{ $json.Message }}\n\nTipo prodotto: {{ $json[\"tipo prodotto\"] }}",
"options": {
"replyTo": "={{ $json.Email }}"
},
"subject": "=[n8n Contacts] Order info",
"toEmail": "to@domain.com",
"fromEmail": "from@domain.com"
},
"credentials": {
"smtp": {
"id": "hRjP3XbDiIQqvi7x",
"name": "SMTP info@n3witalia.com"
}
},
"typeVersion": 2.1
},
{
"id": "3767e3c7-b792-4b0d-a1f2-fc068310cb11",
"name": "Other Dep.",
"type": "n8n-nodes-base.emailSend",
"position": [
320,
140
],
"parameters": {
"html": "=Name: {{ $json.Name }}\nEmail: {{ $json.Email }}\n\nMessage:\n{{ $json.Message }}\n\nTipo prodotto: {{ $json[\"tipo prodotto\"] }}",
"options": {
"replyTo": "={{ $json.Email }}"
},
"subject": "=[n8n Contacts] Other",
"toEmail": "to@domain.com",
"fromEmail": "from@domain.com"
},
"credentials": {
"smtp": {
"id": "hRjP3XbDiIQqvi7x",
"name": "SMTP info@n3witalia.com"
}
},
"typeVersion": 2.1
},
{
"id": "c411a82d-0b86-49da-a11f-47ec79f9f7ff",
"name": "Quote DB",
"type": "n8n-nodes-base.googleSheets",
"position": [
520,
-780
],
"parameters": {
"columns": {
"value": {
"TO": "={{ (JSON.stringify($json.envelope.to)) }}",
"DATA": "={{ $('Text Classifier').item.json.submittedAt }}",
"NOME": "={{ $('Text Classifier').item.json.Name }}",
"EMAIL": "={{ $('Text Classifier').item.json.Email }}",
"CATEGORIA": "info prodotti",
"RICHIESTA": "={{ $('Text Classifier').item.json.Message }}"
},
"schema": [
{
"id": "DATA",
"type": "string",
"display": true,
"required": false,
"displayName": "DATA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NOME",
"type": "string",
"display": true,
"required": false,
"displayName": "NOME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"type": "string",
"display": true,
"required": false,
"displayName": "EMAIL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "RICHIESTA",
"type": "string",
"display": true,
"required": false,
"displayName": "RICHIESTA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CATEGORIA",
"type": "string",
"display": true,
"required": false,
"displayName": "CATEGORIA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TO",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TO",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw\/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw",
"cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw\/edit?usp=drivesdk",
"cachedResultName": "Classified Contact Form"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "c14008fb-8932-44ad-88ef-42f6d4029fb1",
"name": "Prod DB",
"type": "n8n-nodes-base.googleSheets",
"position": [
520,
-540
],
"parameters": {
"columns": {
"value": {
"TO": "={{ (JSON.stringify($json.envelope.to)) }}",
"DATA": "={{ $('Text Classifier').item.json.submittedAt }}",
"NOME": "={{ $('Text Classifier').item.json.Name }}",
"EMAIL": "={{ $('Text Classifier').item.json.Email }}",
"CATEGORIA": "info prodotti",
"RICHIESTA": "={{ $('Text Classifier').item.json.Message }}"
},
"schema": [
{
"id": "DATA",
"type": "string",
"display": true,
"required": false,
"displayName": "DATA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NOME",
"type": "string",
"display": true,
"required": false,
"displayName": "NOME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"type": "string",
"display": true,
"required": false,
"displayName": "EMAIL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "RICHIESTA",
"type": "string",
"display": true,
"required": false,
"displayName": "RICHIESTA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CATEGORIA",
"type": "string",
"display": true,
"required": false,
"displayName": "CATEGORIA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TO",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TO",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw\/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw",
"cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw\/edit?usp=drivesdk",
"cachedResultName": "Classified Contact Form"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "f2e02c07-7218-4d08-a816-1ce2de289312",
"name": "General DB",
"type": "n8n-nodes-base.googleSheets",
"position": [
520,
-320
],
"parameters": {
"columns": {
"value": {
"TO": "={{ (JSON.stringify($json.envelope.to)) }}",
"DATA": "={{ $('Text Classifier').item.json.submittedAt }}",
"NOME": "={{ $('Text Classifier').item.json.Name }}",
"EMAIL": "={{ $('Text Classifier').item.json.Email }}",
"CATEGORIA": "info prodotti",
"RICHIESTA": "={{ $('Text Classifier').item.json.Message }}"
},
"schema": [
{
"id": "DATA",
"type": "string",
"display": true,
"required": false,
"displayName": "DATA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NOME",
"type": "string",
"display": true,
"required": false,
"displayName": "NOME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"type": "string",
"display": true,
"required": false,
"displayName": "EMAIL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "RICHIESTA",
"type": "string",
"display": true,
"required": false,
"displayName": "RICHIESTA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CATEGORIA",
"type": "string",
"display": true,
"required": false,
"displayName": "CATEGORIA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TO",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TO",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw\/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw",
"cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw\/edit?usp=drivesdk",
"cachedResultName": "Classified Contact Form"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "d6ee5c05-d966-47c1-a7ec-df721f77c5d0",
"name": "Order DB",
"type": "n8n-nodes-base.googleSheets",
"position": [
520,
-80
],
"parameters": {
"columns": {
"value": {
"TO": "={{ (JSON.stringify($json.envelope.to)) }}",
"DATA": "={{ $('Text Classifier').item.json.submittedAt }}",
"NOME": "={{ $('Text Classifier').item.json.Name }}",
"EMAIL": "={{ $('Text Classifier').item.json.Email }}",
"CATEGORIA": "info prodotti",
"RICHIESTA": "={{ $('Text Classifier').item.json.Message }}"
},
"schema": [
{
"id": "DATA",
"type": "string",
"display": true,
"required": false,
"displayName": "DATA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NOME",
"type": "string",
"display": true,
"required": false,
"displayName": "NOME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"type": "string",
"display": true,
"required": false,
"displayName": "EMAIL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "RICHIESTA",
"type": "string",
"display": true,
"required": false,
"displayName": "RICHIESTA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CATEGORIA",
"type": "string",
"display": true,
"required": false,
"displayName": "CATEGORIA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TO",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TO",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw\/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw",
"cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw\/edit?usp=drivesdk",
"cachedResultName": "Classified Contact Form"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "b4f344bd-a5c4-4977-af96-edbab85b49d0",
"name": "Other DB",
"type": "n8n-nodes-base.googleSheets",
"position": [
520,
140
],
"parameters": {
"columns": {
"value": {
"TO": "={{ (JSON.stringify($json.envelope.to)) }}",
"DATA": "={{ $('Text Classifier').item.json.submittedAt }}",
"NOME": "={{ $('Text Classifier').item.json.Name }}",
"EMAIL": "={{ $('Text Classifier').item.json.Email }}",
"CATEGORIA": "info prodotti",
"RICHIESTA": "={{ $('Text Classifier').item.json.Message }}"
},
"schema": [
{
"id": "DATA",
"type": "string",
"display": true,
"required": false,
"displayName": "DATA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NOME",
"type": "string",
"display": true,
"required": false,
"displayName": "NOME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"type": "string",
"display": true,
"required": false,
"displayName": "EMAIL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "RICHIESTA",
"type": "string",
"display": true,
"required": false,
"displayName": "RICHIESTA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CATEGORIA",
"type": "string",
"display": true,
"required": false,
"displayName": "CATEGORIA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TO",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TO",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw\/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw",
"cachedResultUrl": "https:\/\/docs.google.com\/spreadsheets\/d\/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw\/edit?usp=drivesdk",
"cachedResultName": "Classified Contact Form"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "99872f49-85c3-47a0-b0ea-10ebbdbb67f5",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
-680
],
"parameters": {
"width": 580,
"height": 280,
"content": "## Important notes\n\nThis very simple workflow is ideal for eCommerce businesses or customer support teams looking to automate and streamline the handling of contact form submissions.\n\n- It is possible to hook any external form such as CF7 for Wordpress through a webhook\n- It is possible to send the email through other providers by replacing them with the relative nodes (Gmail, Outlook....)\n- It is possible to change the collection database with other tools"
},
"typeVersion": 1
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": "649d6a6a-a2a1-49f6-b63a-6def1a8831f1",
"connections": {
"OpenAI": {
"ai_languageModel": [
[
{
"node": "Text Classifier",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Gen. Dep.": {
"main": [
[
{
"node": "General DB",
"type": "main",
"index": 0
}
]
]
},
"Order Dep.": {
"main": [
[
{
"node": "Order DB",
"type": "main",
"index": 0
}
]
]
},
"Other Dep.": {
"main": [
[
{
"node": "Other DB",
"type": "main",
"index": 0
}
]
]
},
"Prod. Dep.": {
"main": [
[
{
"node": "Prod DB",
"type": "main",
"index": 0
}
]
]
},
"Quote Dep.": {
"main": [
[
{
"node": "Quote DB",
"type": "main",
"index": 0
}
]
]
},
"Text Classifier": {
"main": [
[
{
"node": "Quote Dep.",
"type": "main",
"index": 0
},
{
"node": "Prod. Dep.",
"type": "main",
"index": 0
}
],
[],
[
{
"node": "Gen. Dep.",
"type": "main",
"index": 0
}
],
[
{
"node": "Order Dep.",
"type": "main",
"index": 0
}
],
[
{
"node": "Other Dep.",
"type": "main",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "Text Classifier",
"type": "main",
"index": 0
}
]
]
}
}
}How to Use an n8n Template
1
Create a New Workflow
Click "New Workflow" in your n8n dashboard to get started.
2
Copy & Paste Template
First, copy this template:
Click here to copy the JSON
.
Then, in n8n, click the three dots (···) → "Import from file" and paste the JSON code.
3
Customize the Nodes
Go through each node in the workflow to update inputs like spreadsheet IDs, email addresses, or message content. Adjust field mappings to match your data.
4
Grant Access
For nodes that connect to external apps (like Google Sheets or Slack), you'll need to grant access. Connect your accounts using OAuth or an API key and save the credentials in the node.
5
Test It
Run the workflow by clicking "Execute Node" for each step or "Run Once" for the whole thing. Check the right sidebar to inspect data and debug any errors (they'll show up in red).
6
Activate Workflow
Once everything works as expected, click the "Activate" toggle to turn your workflow on. You're all set!