What This Workflow Does
This automation solution solves the critical challenge of staying on top of customer feedback across multiple platforms. E-commerce businesses often struggle to manually monitor and analyze hundreds of product reviews, missing valuable insights and failing to promptly address customer concerns.
The system automatically collects new product reviews from Decodo, analyzes the sentiment using Gemini AI, logs the data in Google Sheets, and sends Telegram alerts for negative feedback. This creates a closed-loop system where customer concerns are addressed within hours rather than days, improving satisfaction and reducing churn.
How It Works
1. Review Collection
The workflow begins by fetching new product reviews from Decodo's API at regular intervals. It captures the review text, star rating, product details, and customer information.
2. Sentiment Analysis
Each review passes through Gemini's AI model which evaluates the emotional tone and classifies it as positive, neutral, or negative. The system also extracts key phrases and common themes.
3. Data Organization
Processed reviews are logged in Google Sheets with columns for sentiment score, key phrases, and automated timestamps. This creates a searchable historical record of customer feedback.
4. Alert System
Negative reviews trigger immediate Telegram alerts to customer service teams, including the product link and specific complaints. Positive reviews are batched for weekly performance reports.
Pro tip: Configure different Telegram channels for urgent issues (1-2 star reviews) versus general feedback (3 stars) to prioritize response efforts.
Who This Is For
This template is ideal for e-commerce businesses selling on Decodo who want to:
- Reduce manual review monitoring time by 80%+
- Improve response times to customer complaints
- Identify product quality issues before they escalate
- Gather actionable insights from customer feedback
What You'll Need
- Decodo seller account with API access
- Google Sheets document for data storage
- Telegram account and channel for alerts
- Gemini API key for sentiment analysis
- n8n instance (cloud or self-hosted)
Quick Setup Guide
- Download the template JSON file
- Import into your n8n instance
- Connect your Decodo API credentials
- Configure your Google Sheets document ID
- Set up Telegram bot and channel IDs
- Add your Gemini API key
- Test with sample reviews before going live
Key Benefits
Faster issue resolution: Get alerted to negative reviews within minutes instead of discovering them days later during manual checks.
Data-driven decisions: Spot product trends and quality issues through aggregated sentiment data rather than anecdotal evidence.
Competitive advantage: Outperform competitors by addressing customer concerns before they escalate to public complaints or returns.
Scalable monitoring: Handle thousands of reviews with the same effort as monitoring dozens, allowing business growth without proportional support costs.