Review Summarizer OpenClaw Skill - ClawHub
Do you want your AI agent to automate Review Summarizer workflows? This free skill from ClawHub helps with ai & llms tasks without building custom tools from scratch.
What this skill does
Scrape, analyze, and summarize product reviews from multiple platforms (Amazon, Google, Yelp, TripAdvisor). Extract key insights, sentiment analysis, pros/cons, and recommendations. Use when researching products for arbitrage, creating affiliate content, or making purchasing decisions.
Install
npx clawhub@latest install review-summarizerFull SKILL.md
Open original| name | description |
|---|---|
| review-summarizer | Scrape, analyze, and summarize product reviews from multiple platforms (Amazon, Google, Yelp, TripAdvisor). Extract key insights, sentiment analysis, pros/cons, and recommendations. Use when researching products for arbitrage, creating affiliate content, or making purchasing decisions. |
Review Summarizer
Overview
Automatically scrape and analyze product reviews from multiple platforms to extract actionable insights. Generate comprehensive summaries with sentiment analysis, pros/cons identification, and data-driven recommendations.
Core Capabilities
1. Multi-Platform Review Scraping
Supported Platforms:
- Amazon (product reviews)
- Google (Google Maps, Google Shopping)
- Yelp (business and product reviews)
- TripAdvisor (hotels, restaurants, attractions)
- Custom platforms (via URL pattern matching)
Scrape Options:
- All reviews or specific time ranges
- Verified purchases only
- Filter by rating (1-5 stars)
- Include images and media
- Max review count limits
2. Sentiment Analysis
Analyzes:
- Overall sentiment score (-1.0 to +1.0)
- Sentiment distribution (positive/neutral/negative)
- Key sentiment drivers (what causes positive/negative reviews)
- Trend analysis (sentiment over time)
- Aspect-based sentiment (battery life, quality, shipping, etc.)
3. Insight Extraction
Automatically identifies:
- Top pros mentioned in reviews
- Common complaints and cons
- Frequently asked questions
- Use cases and applications
- Competitive comparisons mentioned
- Feature-specific feedback
4. Summary Generation
Output formats:
- Executive summary (150-200 words)
- Detailed breakdown by category
- Pros/cons lists with frequency counts
- Statistical summary (avg rating, review count, etc.)
- CSV export for analysis
- Markdown report for documentation
5. Recommendation Engine
Generates recommendations based on:
- Overall sentiment score
- Review quantity and recency
- Verified purchase ratio
- Aspect-based ratings
- Competitive comparison
Quick Start
Summarize Amazon Product Reviews
# Use scripts/scrape_reviews.py
python3 scripts/scrape_reviews.py \
--url "https://amazon.com/product/dp/B0XXXXX" \
--platform amazon \
--max-reviews 100 \
--output amazon_summary.md
Compare Reviews Across Platforms
# Use scripts/compare_reviews.py
python3 scripts/compare_reviews.py \
--product "Sony WH-1000XM5" \
--platforms amazon,google,yelp \
--output comparison_report.md
Generate Quick Summary
# Use scripts/quick_summary.py
python3 scripts/quick_summary.py \
--url "https://amazon.com/product/dp/B0XXXXX" \
--brief \
--output summary.txt
Scripts
scrape_reviews.py
Scrape and analyze reviews from a single URL.
Parameters:
--url: Product or business review URL (required)--platform: Platform (amazon, google, yelp, tripadvisor) (auto-detected if omitted)--max-reviews: Maximum reviews to fetch (default: 100)--verified-only: Filter to verified purchases only--min-rating: Minimum rating to include (1-5)--time-range: Time filter (7d, 30d, 90d, all) (default: all)--output: Output file (default: summary.md)--format: Output format (markdown, json, csv)
Example:
python3 scripts/scrape_reviews.py \
--url "https://amazon.com/dp/B0XXXXX" \
--platform amazon \
--max-reviews 200 \
--verified-only \
--format markdown \
--output product_summary.md
compare_reviews.py
Compare reviews for a product across multiple platforms.
Parameters:
--product: Product name or keyword (required)--platforms: Comma-separated platforms (default: all)--max-reviews: Max reviews per platform (default: 50)--output: Output file--format: Output format (markdown, json)
Example:
python3 scripts/compare_reviews.py \
--product "AirPods Pro 2" \
--platforms amazon,google,yelp \
--max-reviews 75 \
--output comparison.md
sentiment_analysis.py
Analyze sentiment of review text.
Parameters:
--input: Input file or text (required)--type: Input type (file, text, url)--aspects: Analyze specific aspects (comma-separated)--output: Output file
Example:
python3 scripts/sentiment_analysis.py \
--input reviews.txt \
--type file \
--aspects battery,sound,quality \
--output sentiment_report.md
quick_summary.py
Generate a brief executive summary.
Parameters:
--url: Review URL (required)--brief: Brief summary only (no detailed breakdown)--words: Summary word count (default: 150)--output: Output file
Example:
python3 scripts/quick_summary.py \
--url "https://yelp.com/biz/example-business" \
--brief \
--words 100 \
--output summary.txt
export_data.py
Export review data for further analysis.
Parameters:
--input: Summary file or JSON data (required)--format: Export format (csv, json, excel)--output: Output file
Example:
python3 scripts/export_data.py \
--input product_summary.json \
--format csv \
--output reviews_data.csv
Output Format
Markdown Summary Structure
# Product Review Summary: [Product Name]
## Overview
- **Platform:** Amazon
- **Reviews Analyzed:** 247
- **Average Rating:** 4.3/5.0
- **Overall Sentiment:** +0.72 (Positive)
## Key Insights
### Top Pros
1. Excellent sound quality (89 reviews)
2. Great battery life (76 reviews)
3. Comfortable fit (65 reviews)
### Top Cons
1. Expensive (34 reviews)
2. Connection issues (22 reviews)
3. Limited color options (18 reviews)
## Sentiment Analysis
- **Positive:** 78% (193 reviews)
- **Neutral:** 15% (37 reviews)
- **Negative:** 7% (17 reviews)
## Recommendation
✅ **Recommended** - Strong positive sentiment with high customer satisfaction.
Best Practices
For Arbitrage Research
- Compare across platforms - Check Amazon vs eBay seller ratings
- Look for red flags - High return rates, quality complaints
- Check authenticity - Verified purchases only
- Analyze trends - Recent review sentiment vs older reviews
For Affiliate Content
- Extract real quotes - Use actual customer feedback
- Identify use cases - How people use the product
- Find pain points - Problems the product solves
- Build credibility - Use data from many reviews
For Purchasing Decisions
- Check recent reviews - Last 30-90 days
- Look at 1-star reviews - Understand worst-case scenarios
- Consider your needs - Match features to your use case
- Compare alternatives - Use compare_reviews.py
Integration Opportunities
With Price Tracker
Use review summaries to validate arbitrage opportunities:
# 1. Find arbitrage opportunity
price-tracker/scripts/compare_prices.py --keyword "Sony WH-1000XM5"
# 2. Validate with reviews
review-summarizer/scripts/scrape_reviews.py --url [amazon_url]
review-summarizer/scripts/scrape_reviews.py --url [ebay_url]
# 3. Make informed decision
With Content Recycler
Generate content from review insights:
# 1. Summarize reviews
review-summarizer/scripts/scrape_reviews.py --url [amazon_url]
# 2. Use insights in article
seo-article-gen --keyword "[product name] review" --use-insights review_summary.json
# 3. Recycle across platforms
content-recycler/scripts/recycle_content.py --input article.md
Automation
Weekly Review Monitoring
# Monitor competitor products
0 9 * * 1 /path/to/review-summarizer/scripts/compare_reviews.py \
--product "competitor-product" \
--platforms amazon,google \
--output /path/to/competitor_analysis.md
Alert on Negative Trends
# Check for sentiment drops below threshold
if [ $(grep -o "Sentiment: -" summary.md | wc -l) -gt 0 ]; then
echo "Negative sentiment alert" | mail -s "Review Alert" [email protected]
fi
Data Privacy & Ethics
- Only scrape publicly available reviews
- Respect robots.txt and rate limits
- Don't store PII (personal information)
- Aggregate data, don't expose individual reviewers
- Follow platform terms of service
Limitations
- Rate limiting on some platforms
- Cannot access verified purchase status on all platforms
- Fake reviews may skew analysis
- Language support varies by platform
- Some platforms block scraping
Make data-driven decisions. Automate research. Scale intelligence.