{"id":"LGpVLWPpNZSt9ISM","meta":{"instanceId":"workflow-cef16250","versionId":"1.0.0","createdAt":"2025-09-29T07:07:44.992819","updatedAt":"2025-09-29T07:07:44.992837","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"name":"Contact Form Text Classifier for eCommerce","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,"notes":"This formTrigger node performs automated tasks as part of the workflow."},{"id":"7b352c9f-5d2e-46ca-9499-594063167e9a","name":"Text Classifier","type":"n8n-nodes-base.noOp","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,"notes":"This textClassifier node performs automated tasks as part of the workflow."},{"id":"efef4c71-5f56-44b0-a613-9fa888e495b8","name":"OpenAI","type":"n8n-nodes-base.noOp","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,"notes":"This lmChatOpenAi node performs automated tasks as part of the workflow."},{"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,"notes":"This emailSend node performs automated tasks as part of the workflow."},{"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,"notes":"This emailSend node performs automated tasks as part of the workflow."},{"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,"notes":"This emailSend node performs automated tasks as part of the workflow."},{"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,"notes":"This emailSend node performs automated tasks as part of the workflow."},{"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,"notes":"This emailSend node performs automated tasks as part of the workflow."},{"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":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Foglio1"},"documentId":{"__rl":true,"mode":"list","value":"1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Classified Contact Form"}},"credentials":{"googleSheetsOAuth2Api":{"id":"JYR6a64Qecd6t8Hb","name":"Google Sheets account"}},"typeVersion":4.5,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"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":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Foglio1"},"documentId":{"__rl":true,"mode":"list","value":"1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Classified Contact Form"}},"credentials":{"googleSheetsOAuth2Api":{"id":"JYR6a64Qecd6t8Hb","name":"Google Sheets account"}},"typeVersion":4.5,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"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":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Foglio1"},"documentId":{"__rl":true,"mode":"list","value":"1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Classified Contact Form"}},"credentials":{"googleSheetsOAuth2Api":{"id":"JYR6a64Qecd6t8Hb","name":"Google Sheets account"}},"typeVersion":4.5,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"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":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Foglio1"},"documentId":{"__rl":true,"mode":"list","value":"1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Classified Contact Form"}},"credentials":{"googleSheetsOAuth2Api":{"id":"JYR6a64Qecd6t8Hb","name":"Google Sheets account"}},"typeVersion":4.5,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"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":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Foglio1"},"documentId":{"__rl":true,"mode":"list","value":"1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw","cachedResultUrl":"{{ $env.WEBHOOK_URL }}","cachedResultName":"Classified Contact Form"}},"credentials":{"googleSheetsOAuth2Api":{"id":"JYR6a64Qecd6t8Hb","name":"Google Sheets account"}},"typeVersion":4.5,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"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,"notes":"This stickyNote node performs automated tasks as part of the workflow."}],"active":false,"settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"versionId":"649d6a6a-a2a1-49f6-b63a-6def1a8831f1","connections":{"OpenAI":{"main":[[]]},"Prod. Dep.":{"main":[[],[],[],[],[],[],[],[]]},"Quote Dep.":{"main":[[],[],[],[],[],[],[],[]]},"Gen. Dep.":{"main":[[],[],[],[],[],[],[],[]]},"Order Dep.":{"main":[[],[],[],[],[],[],[],[]]},"Other Dep.":{"main":[[],[],[],[],[],[],[],[]]},"Quote DB":{"main":[[]]},"Prod DB":{"main":[[]]},"General DB":{"main":[[]]},"Order DB":{"main":[[]]},"Other DB":{"main":[[]]}},"description":"Automated workflow: Contact Form Text Classifier for eCommerce. This workflow integrates 7 different services: textClassifier, stickyNote, formTrigger, stopAndError, lmChatOpenAi. It contains 25 nodes and follows best practices for error handling and security.","notes":"Excellent quality workflow: Contact Form Text Classifier for eCommerce. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}