What This Workflow Does
This n8n workflow automates the entire customer feedback lifecycle—from collecting reviews across platforms to generating actionable insights. It solves the challenge of manually monitoring multiple review sources while providing deeper sentiment analysis than basic star ratings.
The system extracts review data from provided URLs, uses Google Gemini's AI to analyze sentiment and key themes, then compiles professional reports with trends and actionable insights. Businesses save 10-15 hours weekly on manual review monitoring while gaining more consistent, data-driven customer intelligence.
How It Works
1. Review Collection
The workflow begins by scraping review links from your Airtable base or other data sources. It handles authentication and pagination to ensure complete data collection from each review platform.
2. Data Extraction
Using Decodo's powerful scraping capabilities, the workflow extracts structured review data including text, ratings, dates, and reviewer information. This creates a standardized dataset regardless of the original platform format.
3. Sentiment Analysis
Google Gemini processes each review, assigning sentiment scores (positive/neutral/negative) and identifying key themes, complaints, or compliments. The AI detects emotional tone and specific product/service mentions.
4. Reporting
The system generates comprehensive reports including sentiment trends over time, common complaint categories, and positive feedback highlights. Reports can be delivered via email, saved to Google Drive, or pushed to BI tools.
Pro tip: Configure alerts for negative sentiment spikes to enable rapid response to customer issues before they escalate.
Who This Is For
This workflow is ideal for customer experience teams, marketing agencies managing multiple clients, and any business receiving substantial online feedback. Specific use cases include:
- E-commerce stores monitoring product reviews
- Hospitality businesses tracking guest feedback
- SaaS companies analyzing user sentiment
- Local service providers managing Google/Yelp reviews
What You'll Need
- n8n instance (cloud or self-hosted)
- Decodo account for web scraping
- Google Gemini API access
- Review source URLs (Airtable, spreadsheet, or direct links)
- Destination for reports (Email, Google Drive, etc.)
Quick Setup Guide
- Download the JSON template file
- Import into your n8n instance
- Configure Decodo and Google Gemini API connections
- Set your review source (Airtable base, spreadsheet, etc.)
- Define report recipients and schedule
- Test with sample review URLs
- Activate the workflow
Key Benefits
Save 10+ hours weekly by automating manual review monitoring and analysis across all your platforms.
Discover hidden trends with AI-powered sentiment analysis that goes beyond star ratings to understand customer emotions.
Respond faster to issues with real-time alerts for negative sentiment spikes or specific complaint keywords.
Standardize feedback analysis across locations, products, or teams with consistent scoring methodology.
Demonstrate CX improvements with professional reports showing sentiment trends and impact of changes.