Write smarter emails for your customers

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