n8n Workflow: Amazon & Flipkart Review Mining + Slack Alerts

Mine Amazon & Flipkart reviews, detect complaint themes with OpenAI, and get Slack alerts automatically

This n8n workflow automatically pulls recent customer reviews from Amazon (via Rainforest API) and Flipkart (via Apify), analyzes complaint themes using OpenAI (gpt-4o-mini), saves insights to Google Sheets, and sends urgent Slack alerts plus a weekly digest with a Q&A bot.

What this workflow does

• Runs weekly (Monday 7:00 AM IST) or can start on-demand when you submit the n8n form to process one product or all active products.
• Loads product & history from Google Sheets to build Amazon (ASIN) and Flipkart (product URL) review sources for each active product.
• Fetches reviews: pulls Amazon reviews via Rainforest API, Flipkart reviews via an Apify actor, and optionally imports extra pasted reviews from the Imported Reviews tab in Google Sheets.
• Normalizes, merges, and filters reviews by removing short/invalid/old entries and identifying new reviews by comparing review IDs against the Review History sheet.
• Classifies complaints with OpenAI in per-product batches, tagging each review with complaint theme, sentiment, severity, action type, and a supporting quote—then appends results to Review Insights and Review History in Google Sheets.
• Posts Slack alerts immediately for severe low-rated complaints or any safety/health issue.
• Generates weekly listing-fix output by analyzing the last 90 days of insights, ranking top complaint themes and trends, and using OpenAI to produce evidence-based listing rewrites (plus a Slack digest with Q&A bot).

Use cases

• Brands and SaaS operators monitoring Amazon & Flipkart customer feedback for fast issue response.
• E-commerce automation engineers building a repeatable review mining + alerting pipeline in n8n.
• Teams using Google Sheets to track “what changed” and OpenAI-driven theme categorization over time.

Technical details

• Integrations: Amazon via Rainforest API, Flipkart via Apify, Google Sheets (product inputs, Imported Reviews, Review Insights, Review History), and Slack notifications.
• OpenAI analysis: gpt-4o-mini for complaint theme/sentiment/severity/action tagging and evidence-based listing rewrite generation.
• n8n nodes used: set, code, merge, slack, filter, split out.