Communication
Classify contact messages and store them in spreadsheets
14 nodes
112
83
Automatic trigger
Workflow Description
This automation receives contact form submissions from your e-commerce site, uses AI to classify them by type (inquiry, complaint, suggestion), stores the data in Google Sheets, and sends personalized confirmation emails to customers based on their message category.
How it works
- 1.Receive form submission data from your e-commerce website
- 2.Classify message content using OpenAI language model
- 3.Record the submission and classification in Google Sheets automatically
- 4.Send a confirmation email to the customer based on message type
Use cases
- Organize and categorize customer inquiries without manual sorting
- Maintain a centralized spreadsheet of all incoming contact messages for analysis
- Reduce staff time spent on message triage and initial routing
Requirements
- Active OpenAI account with API access enabled
- Google Workspace account with edit permissions on spreadsheets
- SMTP credentials for your business email server
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Form Trigger
If
OpenAI
Email Send
Google Sheets
Details
Trigger
Automatic trigger
Nodes
14
Apps
5
Views
112
Downloads
83
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (14)
/
On form submission
Form Trigger
Text Classifier
If
OpenAI
OpenAI
Prod. Dep.
Email Send
Quote Dep.
Email Send
Gen. Dep.
Email Send
Order Dep.
Email Send
Other Dep.
Email Send
Quote DB
Google Sheets
Prod DB
Google Sheets
General DB
Google Sheets
Order DB
Google Sheets
Other DB
Google Sheets
Sticky Note
Sticky Note