Contact Form Text Classifier for eCommerce

{"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": "", "name": "[Your openAiApi]"}}, "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": "", "name": "[Your smtp]"}}, "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": "", "name": "[Your smtp]"}}, "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": "", "name": "[Your smtp]"}}, "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": "", "name": "[Your smtp]"}}, "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": "", "name": "[Your smtp]"}}, "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": "", "name": "[Your googleSheetsOAuth2Api]"}}, "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": "", "name": "[Your googleSheetsOAuth2Api]"}}, "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": "", "name": "[Your googleSheetsOAuth2Api]"}}, "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": "", "name": "[Your googleSheetsOAuth2Api]"}}, "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": "", "name": "[Your googleSheetsOAuth2Api]"}}, "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}]]}}}