Contact Form Text Classifier for eCommerce

Name: Contact Form Text Classifier for eCommerce
Rating: 5 (5 reviews)
Author: Free N8N

Intermediate

12 nodes connected

detail.loadingPreview

Free N8N Temples

164 views

0 downloads

Customer SupportAIAutomationClassificationContact FormEmailGoogle SheetseCommerce

Automates the classification and routing of contact form submissions for eCommerce businesses using AI.

About This Workflow

This workflow is designed to process incoming contact form submissions, classify their intent using an AI language model, and route them to the appropriate department or database. It enhances customer support efficiency by automating initial triage.

Key Features

Form Submission Trigger: Captures data from a basic contact form.
AI Text Classification: Utilizes an OpenAI model (gpt-4o-mini) to categorize messages into predefined intents (Request Quote, Product Info, General Problem, Order).
Conditional Routing: Directs classified submissions to specific email recipients and Google Sheets for logging.
Data Persistence: Stores classified data in separate Google Sheets for each category.

How To Use

Configure the 'On form submission' node: Set up your contact form fields (Name, Email, Message).
Set up OpenAI credentials: Connect your OpenAI API key to the 'OpenAI' node.
Customize Text Classifier: Adjust the categories and systemPromptTemplate in the 'Text Classifier' node as needed.
Configure Email Nodes: Update toEmail, fromEmail, and subject in each of the * Dep. (e.g., Prod. Dep.) email nodes to direct inquiries to the correct departments.
Configure Google Sheets Nodes: Ensure your Google Sheets credentials are set up and that the documentId and sheetName in each of the * DB nodes (e.g., Quote DB) point to your desired Google Sheet.
Map Columns: Verify the column mapping in each Google Sheets node, ensuring CATEGORIA accurately reflects the classification.
Activate the workflow.

Apps Used

Automation

Classification

Contact Form

Google Sheets

eCommerce

Workflow JSON

{
  "id": "a21fb7a3-4fe8-4e86-af8e-240f9d4c8c57",
  "name": "Contact Form Text Classifier for eCommerce",
  "nodes": 12,
  "category": "Customer Support",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.