{"product_id":"n8n-workflow-amazon-flipkart-review-mining-slack-alerts","title":"n8n Workflow: Amazon \u0026 Flipkart Review Mining + Slack Alerts","description":"\u003ch3\u003eMine Amazon \u0026amp; Flipkart reviews, detect complaint themes with OpenAI, and get Slack alerts automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically pulls recent customer reviews from \u003cstrong\u003eAmazon (via Rainforest API)\u003c\/strong\u003e and \u003cstrong\u003eFlipkart (via Apify)\u003c\/strong\u003e, analyzes complaint themes using \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e, saves insights to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends \u003cstrong\u003eurgent Slack alerts\u003c\/strong\u003e plus a weekly digest with a Q\u0026amp;A bot.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly (Monday 7:00 AM IST)\u003c\/strong\u003e or can start on-demand when you submit the n8n form to process one product or all active products.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads product \u0026amp; history from Google Sheets\u003c\/strong\u003e to build Amazon (ASIN) and Flipkart (product URL) review sources for each active product.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches reviews\u003c\/strong\u003e: pulls Amazon reviews via \u003cstrong\u003eRainforest API\u003c\/strong\u003e, Flipkart reviews via an \u003cstrong\u003eApify actor\u003c\/strong\u003e, and optionally imports extra pasted reviews from the \u003cstrong\u003eImported Reviews\u003c\/strong\u003e tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes, merges, and filters\u003c\/strong\u003e reviews by removing short\/invalid\/old entries and identifying \u003cstrong\u003enew reviews\u003c\/strong\u003e by comparing review IDs against the \u003cstrong\u003eReview History\u003c\/strong\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies complaints with OpenAI\u003c\/strong\u003e in per-product batches, tagging each review with complaint theme, sentiment, severity, action type, and a supporting quote—then appends results to \u003cstrong\u003eReview Insights\u003c\/strong\u003e and \u003cstrong\u003eReview History\u003c\/strong\u003e in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts Slack alerts\u003c\/strong\u003e immediately for \u003cstrong\u003esevere low-rated complaints\u003c\/strong\u003e or any \u003cstrong\u003esafety\/health\u003c\/strong\u003e issue.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates weekly listing-fix output\u003c\/strong\u003e by analyzing the \u003cstrong\u003elast 90 days\u003c\/strong\u003e of insights, ranking top complaint themes and trends, and using OpenAI to produce evidence-based listing rewrites (plus a Slack digest with Q\u0026amp;A bot).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBrands and SaaS operators monitoring \u003cstrong\u003eAmazon \u0026amp; Flipkart\u003c\/strong\u003e customer feedback for fast issue response.\u003c\/li\u003e\n  \u003cli\u003eE-commerce automation engineers building a repeatable \u003cstrong\u003ereview mining + alerting\u003c\/strong\u003e pipeline in n8n.\u003c\/li\u003e\n  \u003cli\u003eTeams using Google Sheets to track “what changed” and OpenAI-driven theme categorization over time.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Amazon via \u003cstrong\u003eRainforest API\u003c\/strong\u003e, Flipkart via \u003cstrong\u003eApify\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (product inputs, Imported Reviews, Review Insights, Review History), and \u003cstrong\u003eSlack\u003c\/strong\u003e notifications.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI analysis:\u003c\/strong\u003e \u003cstrong\u003egpt-4o-mini\u003c\/strong\u003e for complaint theme\/sentiment\/severity\/action tagging and evidence-based listing rewrite generation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e \u003cem\u003eset, code, merge, slack, filter, split out\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46359720853683,"sku":"N8N-22223","price":11.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/RKik96w6RWeS_byorjycB_nY6jJgWj.png?v=1793696792","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-amazon-flipkart-review-mining-slack-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}