Contact Form Text Classifier for eCommerce

Automate the intelligent routing of incoming contact form submissions for your eCommerce business with this powerful workflow. This n8n automation connects your form submissions directly to an AI-powered text classifier, leveraging OpenAI to analyze the content and categorize each inquiry. Based on the classification, the workflow automatically sends the submission to the appropriate departmental email (Production, Quote, General, Order, or Other) and simultaneously logs the details into the corresponding Google Sheet database (Prod DB, Quote DB, General DB, Order DB, or Other DB) for organized record-keeping. This workflow is ideal for eCommerce businesses looking to streamline customer service operations, reduce manual sorting of inquiries, and ensure that customer questions are directed to the correct team member quickly. By eliminating the need for human intervention in initial triage, this automation significantly saves time, improves response times, and enhances overall customer satisfaction.

14 nodesmanual trigger80 views0 copiesMarketing

Google SheetsOpenAI

Workflow JSON

{"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}]]}}}

How to Import This Workflow

1Copy the workflow JSON above using the Copy Workflow JSON button.
2Open your n8n instance and go to Workflows.
3Click Import from JSON and paste the copied workflow.

Don't have an n8n instance? Start your free trial at n8nautomation.cloud

Related Templates

Auto categorize wordpress template

Automatically categorize your WordPress posts with the power of AI. This workflow connects your WordPress site with OpenAI's advanced language models to intelligently analyze your content and assign appropriate categories. When you manually trigger this workflow, it first retrieves all your WordPress posts using the "Get All Wordpress Posts" node. This data then flows into an AI Agent, which leverages the "OpenAI Chat Model" to understand the context and content of each post. Based on this analysis, the AI Agent then interacts with your WordPress site to update the categories of your posts, streamlining your content management. This is incredibly useful for bloggers, content marketers, and website administrators who manage large volumes of content and want to ensure their posts are consistently and accurately categorized without manual effort. It saves significant time and reduces the potential for human error in content organization, making your website more navigable and improving SEO.

9 nodes

Effortless Email Management with AI

Automate your email management by intelligently processing incoming messages, summarizing their content, and drafting personalized replies with AI. This powerful workflow connects your Gmail inbox via an IMAP trigger to a Text Classifier that categorizes emails, then uses OpenAI for summarization and drafting responses, and Qdrant for vector storage of relevant documents from Google Drive. It’s ideal for marketing teams, customer support, or busy professionals who need to efficiently handle high volumes of correspondence, saving significant time on reading, understanding, and responding to emails by leveraging AI to streamline communication and ensure timely, relevant replies. The system also allows for reviewing AI-generated drafts before sending, ensuring quality control while drastically reducing manual effort.

31 nodes

Summarize emails with A.I. then send to messenger

Automatically summarize incoming emails using artificial intelligence and then instantly share those summaries to your preferred messenger application with this efficient n8n workflow. This automation connects your IMAP email account to an AI summarization service via an HTTP Request, extracting key information from your messages. The summarized content is then sent to a messenger platform, also through an HTTP Request, ensuring important updates reach your team or personal devices without delay. Businesses can leverage this to quickly disseminate critical client communications, project updates, or urgent alerts from various email accounts directly to team chat channels, saving valuable time spent sifting through lengthy emails. This workflow significantly reduces manual effort in information processing and dissemination, allowing for faster decision-making and improved communication efficiency across your organization.

7 nodes

Ready to automate with n8n?

Get affordable managed n8n hosting with 24/7 support.