🛍️ Amazon & Etsy Bestseller Product Research Engine
Slug: amazon-etsy-product-research
Category: E-Commerce / Product Research
Powered by: Apify + Claude AI
Input any niche. Get a complete product research report — bestsellers, pricing gaps, review weaknesses, search trends, profit margins & untapped opportunities — in minutes. Find your next winning product before your competitors do.
💥 Why This Skill Will Explode on ClawHub
Every dropshipper, Amazon FBA seller, Etsy creator, and e-commerce founder spends 20-40 hours/week manually researching products. That's the most painful, repetitive, high-stakes task in their business.
This skill cuts that to 5 minutes. With better data than anything they'd find manually.
What gets researched automatically:
- 🏆 Top 50 bestselling products in any niche (Amazon + Etsy combined)
- 💰 Real pricing data — average, min, max, optimal price point
- ⭐ Review gap analysis — what customers LOVE and HATE about existing products
- 📈 Search trend momentum — rising vs declining demand
- 🏭 Supplier intelligence — estimated production cost & profit margin
- 🔍 Keyword goldmine — top search terms driving sales
- 🚀 Untapped opportunity score — low competition, high demand niches
- 📦 Listing optimization tips — titles, tags, descriptions that rank
🛠️ Apify Actors Used
| Actor | ID | Purpose |
|---|
| Amazon Product Scraper | junglee/amazon-product-scraper | Bestsellers, pricing, reviews, BSR rank |
| Amazon Reviews Scraper | junglee/amazon-reviews-scraper | Deep review sentiment analysis |
| Etsy Scraper | emastra/etsy-scraper | Top Etsy listings, sales estimates, tags |
| Google Trends Scraper | emastra/google-trends-scraper | Demand momentum & seasonal patterns |
| Google Search Scraper | apify/google-search-scraper | Market size, competitor brands, news |
⚙️ Full Workflow
INPUT: Niche keyword + marketplace (Amazon / Etsy / Both) + budget range
↓
STEP 1 — Scrape Top 50 Bestsellers in the Niche
└─ Amazon BSR rank, Etsy sales count, pricing, review volume
↓
STEP 2 — Deep Review Mining (1,000+ reviews analyzed)
└─ What do buyers LOVE? What do they HATE?
└─ Most mentioned complaints = your product improvement opportunity
↓
STEP 3 — Pricing Intelligence
└─ Average price, price clustering, optimal entry price point
└─ Identify underpriced gaps and premium opportunities
↓
STEP 4 — Google Trends Analysis
└─ Is demand rising or declining?
└─ Seasonal peaks, emerging micro-trends
↓
STEP 5 — Keyword & SEO Analysis
└─ Top search terms, long-tail opportunities, low-competition keywords
↓
STEP 6 — Profit Margin Estimation
└─ Estimated COGS based on product type & complexity
└─ Realistic margin after platform fees, shipping, ads
↓
STEP 7 — Claude AI Generates Full Opportunity Report
└─ Top 10 product opportunities ranked by score
└─ Review gap = your product angle
└─ Exact listing strategy to outrank existing sellers
↓
OUTPUT: Ranked product list + full opportunity report (JSON / Markdown / CSV)
📥 Inputs
{
"niche": "minimalist home decor",
"marketplace": "both",
"price_range": {
"min": 15,
"max": 80
},
"target_margin": 40,
"exclude_brands": ["IKEA", "Amazon Basics"],
"research_depth": {
"max_products": 50,
"reviews_per_product": 100,
"lookback_days": 90
},
"apify_token": "YOUR_APIFY_TOKEN"
}
📤 Output Example
{
"niche": "minimalist home decor",
"market_overview": {
"total_products_analyzed": 50,
"average_price": "$34.50",
"average_reviews": 847,
"market_trend": "📈 Rising +23% YoY",
"competition_level": "🟡 Medium",
"best_entry_price_point": "$24.99 - $39.99"
},
"top_opportunities": [
{
"rank": 1,
"opportunity_score": 94,
"product_idea": "Minimalist Wooden Desk Organizer with Hidden Wireless Charger",
"why_it_wins": "Top 3 complaints in 800+ reviews of existing organizers: 'no cable management', 'takes up too much space', 'no charging'. Zero products currently solve all 3.",
"estimated_price": "$39.99",
"estimated_cogs": "$11.00",
"estimated_margin": "62%",
"monthly_search_volume": "28,400",
"top_competitors": 4,
"review_gap": {
"buyers_love": ["clean design", "sturdy wood", "good size"],
"buyers_hate": ["no wireless charging", "cables everywhere", "too bulky"],
"your_angle": "Same minimalist aesthetic + built-in wireless charging pad + cable routing"
},
"listing_strategy": {
"title": "Minimalist Wooden Desk Organizer with Wireless Charger — Cable-Free Workspace Storage for Home Office",
"top_keywords": ["desk organizer", "wireless charging desk organizer", "minimalist office accessories", "wooden desk storage"],
"price_to_win": "$37.99 (undercut leader by $4 while adding features)"
}
},
{
"rank": 2,
"opportunity_score": 87,
"product_idea": "Expandable Minimalist Spice Rack — Bamboo, No Assembly",
"why_it_wins": "Best seller has 2,400 reviews. #1 complaint (340 reviews): 'took 45 min to assemble, instructions terrible'. Opportunity: same product, tool-free snap assembly.",
"estimated_price": "$28.99",
"estimated_cogs": "$7.50",
"estimated_margin": "58%",
"monthly_search_volume": "41,200",
"top_competitors": 6,
"review_gap": {
"buyers_love": ["looks great", "holds a lot", "bamboo quality"],
"buyers_hate": ["horrible assembly", "screws stripped", "instructions useless"],
"your_angle": "Snap-fit bamboo construction — zero tools, 60 seconds to set up"
}
}
],
"keyword_goldmine": [
{ "keyword": "minimalist desk organizer", "volume": 28400, "competition": "medium", "trend": "rising" },
{ "keyword": "aesthetic home office accessories", "volume": 18700, "competition": "low", "trend": "rising +41%" },
{ "keyword": "bamboo desk storage", "volume": 12300, "competition": "low", "trend": "stable" }
],
"seasonal_insights": {
"peak_months": ["October", "November", "January"],
"advice": "Launch by September to catch Q4 gifting season — this niche sees 3x volume in November"
},
"sourcing_intelligence": {
"recommended_platforms": ["Alibaba", "1688.com", "AliExpress"],
"estimated_moq": "50-200 units for custom branding",
"avg_sample_cost": "$15-30",
"production_lead_time": "15-25 days"
}
}
🧠 Claude AI Master Prompt
You are a world-class Amazon FBA and Etsy product research expert.
SCRAPED MARKETPLACE DATA:
- Bestsellers: {{bestsellers_data}}
- Review analysis: {{reviews_data}}
- Pricing data: {{pricing_data}}
- Google Trends: {{trends_data}}
- Keyword data: {{keyword_data}}
RESEARCH PARAMETERS:
- Niche: {{niche}}
- Target price range: {{price_range}}
- Target margin: {{target_margin}}%
GENERATE:
1. Market overview — average price, competition level, trend direction
2. Top 10 product opportunities ranked by opportunity score (0-100)
For each opportunity include:
- Why it wins (review gap + market gap)
- Estimated price, COGS, and margin
- Exact buyer complaints that become your product USP
- Listing strategy: optimized title + top 5 keywords + recommended price
3. Keyword goldmine — top 10 search terms with volume, competition & trend
4. Seasonal insights — when to launch and peak months
5. Sourcing intelligence — where to source, MOQ, lead time estimates
SCORING CRITERIA (weight each):
- Review gap score (30%) — how many complaints can you fix?
- Demand trend (25%) — is search volume rising?
- Competition density (25%) — how many strong sellers dominate?
- Margin potential (20%) — can you hit the target margin?
OUTPUT: Valid JSON only. No markdown. No preamble.
💰 Cost Estimate
| Research Runs | Apify CU | Cost | Niches Researched |
|---|
| 1 niche | ~45 CU | ~$0.45 | 1 full report |
| 5 niches | ~220 CU | ~$2.20 | 5 full reports |
| 20 niches | ~880 CU | ~$8.80 | 20 full reports |
| 100 niches | ~4,300 CU | ~$43 | 100 full reports |
💡 $5 free Apify credits on signup = your first 10 niche reports completely free.
👉 https://www.apify.com?fpr=dx06p
🔗 Who Makes Money With This Skill
| User | How They Use It | Revenue Potential |
|---|
| Amazon FBA Seller | Find next winning product before competitors | $5K-$50K/month per product |
| Etsy Creator | Identify trending niches with low competition | $2K-$15K/month passive |
| Dropshipper | Validate products before buying inventory | Avoid $000s in bad stock |
| Product Research Agency | Sell reports to clients at $200-$500 each | $5K-$20K/month service |
| E-com Consultant | Bundle into strategy package | $2K-$10K per engagement |
| Private Label Brand | Source & brand winning products | Build 6-7 figure brand |
📊 Why This Beats Every Existing Research Tool
| Feature | Helium10 ($99/mo) | Jungle Scout ($69/mo) | This Skill |
|---|
| Amazon data | ✅ | ✅ | ✅ |
| Etsy data | ❌ | ❌ | ✅ |
| Review gap analysis | ❌ | ❌ | ✅ |
| AI-generated product angle | ❌ | ❌ | ✅ |
| Listing strategy included | ❌ | ❌ | ✅ |
| Monthly subscription | $99/mo | $69/mo | ~$0.45/run |
| Works for any niche instantly | ✅ | ✅ | ✅ |
🚀 Setup in 3 Steps
Step 1 — Get your Apify API Token
Sign up free → https://www.apify.com?fpr=dx06p
Go to: Settings → Integrations → API Token
Step 2 — Define your niche & parameters
Keyword, marketplace, price range, target margin. The more specific, the better.
Step 3 — Run & get your report
Full opportunity report with ranked products in under 5 minutes.
⚡ Pro Tips to Find Winning Products Faster
- Focus on products with 500+ reviews AND a 3.8-4.2★ rating — enough demand, enough complaints to improve on
- The best opportunity is always in the reviews — sort by 1-3 stars and read 50 complaints
- Target the #2 or #3 bestseller, not #1 — easier to dethrone, same demand
- Launch in October for Q4 — home decor, gifts & organizers 3x in November
- Start with Etsy to validate — lower ad costs, faster feedback loop than Amazon
🏷️ Tags
amazon etsy product-research ecommerce dropshipping fba private-label apify bestseller market-research product-validation keyword-research
Powered by Apify + Claude AI
