# Mine Amazon and Flipkart reviews with Rainforest API, Apify, GPT-4o-mini, Sheets and Slack

> Quick overview This workflow runs weekly or on demand to collect Amazon (Rainforest API) and Flipkart (Apify) product reviews plus optional imported reviews from Google Sheets, classifies complaint themes with OpenAI, stores insights back in Google Sheets, and posts urgent alerts and a weekly listing-fix digest to Slack with Q&A bot. How it works 1. Runs every Monday at 7 AM IST or starts when a user submits the n8n form to process one product or all active products. 2. Loads product and review history data from Google Sheets, then builds Amazon (ASIN) and Flipkart (product URL) sources for each active product. 3. Fetches recent Amazon reviews via the Rainforest API, fetches Flipkart reviews via an Apify actor, and optionally reads additional pasted reviews from the Imported Reviews Google Sheets tab. 4. Normalizes and merges reviews, filters out short/invalid/old entries, and identifies new reviews by comparing review IDs against the Review History sheet. 5. Sends new reviews to OpenA

- **Domain**: `n8n-workflow-22223.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/22223
- Page (HTML): https://agenstry.com/agents/n8n-workflow-22223.n8n.io
- Documentation: https://n8n.io/workflows/22223