Classify WordPress form responses and route them automatically
Workflow Description
Automation that receives form submissions via webhook, uses Gemini to intelligently categorize them, sends targeted emails based on type, and stores structured data in Google Sheets for tracking and analysis.
How it works
- 1.Receive form data from WordPress via webhook trigger
- 2.Analyze and classify text using Gemini language model
- 3.Route responses by detected category (inquiry, complaint, request)
- 4.Send notifications to relevant teams via Gmail
- 5.Store classified data in Google Sheets for record-keeping
- 6.Create organized database for future analysis and reporting
Use cases
- Automatically prioritize and categorize customer inquiries by topic
- Route complaints to support team and suggestions to product team
- Build centralized repository of all form submissions for insights
Requirements
- WordPress site with contact forms or custom forms enabled
- Google account with Gmail and Google Sheets access
- Gemini API key from Google Cloud
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
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 (24)
From Wordpress
Webhook
Set Fields
Set
Google Gemini Chat Model
Gemini Model
Message Classifier
If
Google Gemini Chat Model1
Gemini Model
Email draft - Other info
Gmail
Email writer (Others)
LLM Chain
Google Gemini Chat Model2
Gemini Model
Google Gemini Chat Model3
Gemini Model
Email writer (Order info)
LLM Chain
Email writer (Product info)
LLM Chain
Email draft - Product info
Gmail
Email draft - Order info
Gmail
Save on Sheet (product)
Google Sheets
Save on Sheet (order)
Google Sheets
Save on Sheet (other)
Google Sheets
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Subject and Text
Output Parser Structured
Subject and Text 2
Output Parser Structured
Subject and Text 3
Output Parser Structured
Sticky Note4
Sticky Note