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 trigger114 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

Automate Blog Creation in Brand Voice with AI

Generate blog posts in your brand's unique voice and style directly within WordPress using this powerful AI-driven workflow. It begins by fetching existing articles from your blog via an HTTP request, then intelligently extracts their content and structure using an HTML node and an AI chain LLM to understand your established writing patterns. Concurrently, an AI information extractor analyzes these articles to pinpoint and define your brand's distinct voice characteristics. This extracted style and voice, along with the structural insights, are then fed into an AI content generation agent which crafts new blog post drafts. Finally, these AI-generated articles are automatically saved as drafts in your WordPress instance, ready for review and publication. This workflow is ideal for marketing teams, content creators, and agencies looking to scale their content production while maintaining consistent brand messaging and reducing the manual effort involved in drafting new posts, ultimately saving significant time and resources.

27 nodes

Auto-Tag Blog Posts in WordPress with AI

Automatically tag your WordPress blog posts with relevant keywords using the power of AI. This n8n workflow connects your WordPress site with OpenAI's advanced language models to intelligently analyze new or existing articles and assign appropriate tags, streamlining your content management process. It starts by either triggering manually or by an RSS Feed Trigger monitoring your blog for new content, then sends the article text to an OpenAI Chat Model for tag generation. The workflow then checks your existing WordPress tags via an HTTP Request to avoid duplicates, creates any new tags needed with another HTTP Request, and finally updates the WordPress post with the newly generated and existing tags. This automation is perfect for content managers, marketing teams, and bloggers who want to improve SEO, enhance content discoverability, and reduce the manual effort of categorizing a large volume of articles, ultimately saving significant time and ensuring consistent tagging across your entire blog.

32 nodes

Extract spend details (template)

Automate the extraction and tracking of spend details directly from your email inbox into Google Sheets. This workflow connects Gmail to automatically retrieve invoice and payment emails, then uses AI models like Google Gemini Chat Model and Groq Chat Model to intelligently parse and extract key financial data. The extracted information, including vendor, amount, date, and itemized details, is then seamlessly organized and sent to Google Sheets for centralized record-keeping. This powerful automation is ideal for marketing teams, small businesses, and freelancers who need to efficiently monitor expenses, reconcile accounts, and gain better financial visibility without manual data entry, saving significant time and reducing errors in financial tracking.

24 nodes

Ready to automate with n8n?

Get affordable managed n8n hosting with 24/7 support.