Description
Automated customer sentiment analysis and email generation — powered by GPT-4o
📉 Stop manually writing follow-up emails — this workflow reads customer reviews and creates personalized responses using AI, including coupon offers for unhappy users
🧠 What Problem Does It Solve?
Reviewing customer feedback and replying manually is slow, inconsistent, and hard to scale
This workflow automates that process and generates AI-powered email responses based on sentiment
🔹 Positive → Reinforcement messaging
🔹 Negative → Recovery email with coupon
🔹 Neutral → Encouraging follow-up
⚙️ How It Works
📥 Downloads product review data from a Google Sheet or file
🧹 Normalizes and parses feedback for AI input
🧠 Uses GPT-4o to classify sentiment and generate email headline + body
🎯 Decides if a coupon should be offered
💌 Composes two types of HTML email (with or without coupon)
📤 Sends the final email via Gmail
✨ Key Features
✅ Fully automated feedback handling with OpenAI
✅ Personalized, sentiment-aware email generation
✅ Supports both .xlsx and .csv feedback files
✅ Automatically injects coupon logic when needed
✅ Uses different email templates based on user sentiment
✅ Built-in error handling and campaign logic toggles
🧰 What You Need
🔐 OpenAI API key (GPT-4o access)
📂 Google Drive folder or URL with feedback file
📧 Gmail account for sending messages
📝 Customer feedback in structured format (.csv or .xlsx)
🧪 n8n v1.19.4 or higher
🚀 Setup Instructions
🔗 Connect your feedback source (Google Drive or download node)
⚙️ Add your OpenAI and Gmail credentials in the respective nodes
📄 Use the provided dummy file or connect to real review exports
🧠 Modify prompt logic to suit your campaign tone and goals
📨 Customize HTML templates for your brand style
✅ Test on one account before scaling
🤝 Integrations
Google Drive
Gmail
OpenAI GPT-4o
n8n
