📊 Automated product review monitoring with sentiment analysis via Decodo, Gemini & Telegram
⚡ 2,317 views · 📊 Market Research & Insights
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
Decodo-powered review aggregation to Google Sheets with Gemini analysis and Telegram alerts
Who’s it for
This template is designed for e-commerce owners, marketplace sellers, product teams, and CX/reputation managers who need an automated way to monitor product reviews. It’s ideal for anyone tracking Amazon listings or other URLs and wants AI-powered sentiment, summaries, and alerts without manual scraping.
What it does
This workflow automatically retrieves product URLs from Google Sheets, scrapes reviews using Decodo (community node), formats the extracted data, and analyzes it using Gemini AI. It produces both sentiment classification and a concise review summary. Results are saved to a Google Sheets log, and the workflow sends a Telegram alert whenever new reviews are processed. The entire pipeline runs on a schedule, ensuring continuous and fully automated monitoring.
How it works
- A scheduled trigger starts the workflow.
- Google Sheets provides the list of product URLs.
- Each URL is processed through Decodo to extract user reviews.
- A Code node formats the raw review data.
- Gemini performs sentiment analysis and summarization.
- Results are appended to a Google Sheets review log.
- A Telegram message delivers a real-time summary and sentiment snapshot.
Sign up for Decodo — get better pricing here
Requirements
- Decodo API credentials (self-hosted community node)
- Google Sheets API Key
- Gemini AI credentials
- Telegram Bot + Chat ID
- n8n self-hosted (required for Decodo community node)
How to set up
- Add your Decodo credentials to the Decodo node.
- Update both Google Sheets nodes with your document ID and sheet names.
- Insert your Gemini API key.
- Provide your Telegram Bot token and Chat ID.
- Adjust the schedule interval to your preference.
- Run the workflow once to validate mappings and output fields.
How to customize
- Modify the Code node to change how reviews are formatted.
- Extend Gemini prompts for deeper analysis (keywords, categories, toxicity).
- Add filters to trigger alerts only on negative sentiment.
- Append additional metadata (timestamps, product IDs) to the Sheets log.
- Add email, Slack, or other communication channels.
Disclaimer (Community Node)
This workflow uses a community node (Decodo) and therefore works only on self-hosted n8n instances. Be sure to install and trust the package before using it.
🔗 Nodes Used
Google Sheets, Telegram, Schedule Trigger, Summarization Chain, Google Gemini Chat Model, Sentiment Analysis
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File