Ce système classe automatiquement les messages issus des formulaires de contact selon leur catégorie, puis les transmet au bon service et archive toutes les données dans Google Sheets.
Ce système classe automatiquement les messages issus des formulaires de contact selon leur catégorie, puis les transmet au bon service et archive toutes les données dans Google Sheets.
{
"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 }}nnMessage:n{{ $json.Message }}nnTipo 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 }}nnMessage:n{{ $json.Message }}nnTipo 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 }}nnMessage:n{{ $json.Message }}nnTipo 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 }}nnMessage:n{{ $json.Message }}nnTipo 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 }}nnMessage:n{{ $json.Message }}nnTipo 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 notesnnThis very simple workflow is ideal for eCommerce businesses or customer support teams looking to automate and streamline the handling of contact form submissions.nn- It is possible to hook any external form such as CF7 for Wordpress through a webhookn- 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
}
]
]
}
}
}