{"product_id":"n8n-etsy-review-theme-analyzer-fix-queue-from-csv-google-sheets","title":"n8n Etsy Review Theme Analyzer: Fix Queue from CSV \u0026 Google Sheets","description":"\u003ch3\u003eTurn low-rated Etsy reviews into a ranked “Fix Queue” (CSV \u0026amp; Google Sheets)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow analyzes 1–3★ Etsy reviews, identifies the most likely themes (shipping, sizing, quality, packaging, and more), and produces a prioritized “Fix Queue” so you know exactly what to fix first—without using the Etsy API.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRun manually and load configuration\u003c\/strong\u003e to choose your input mode (mock sample data, local \u003ccode\u003ereviews*.csv\u003c\/code\u003e files, or a Google Sheet tab named \u003ccode\u003eReviews\u003c\/code\u003e) and your output destination (CSV files or Google Sheets).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollect and parse reviews\u003c\/strong\u003e from the selected source.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional theme classification with Google Gemini\u003c\/strong\u003e: you may send up to \u003cstrong\u003e40\u003c\/strong\u003e reviews to the Gemini API for classification. If the Gemini step is skipped or fails, the workflow automatically \u003cstrong\u003efalls back to built-in keyword rules\u003c\/strong\u003e (Gemini usage is optional; keyword rules are the default).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTag and flag reviews\u003c\/strong\u003e using rule-based keyword tagging, including detection for \u003cstrong\u003eempty or spammy\u003c\/strong\u003e reviews.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuild theme counts only from low ratings\u003c\/strong\u003e (≤ your configured star threshold) and generate a ranked \u003cstrong\u003eFix Queue\u003c\/strong\u003e with suggested next actions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrite four outputs\u003c\/strong\u003e: \u003cstrong\u003eBy Review\u003c\/strong\u003e, \u003cstrong\u003eThemes\u003c\/strong\u003e, \u003cstrong\u003eFix Queue\u003c\/strong\u003e, and \u003cstrong\u003eSummary\u003c\/strong\u003e—as Google Sheets tabs or as CSV files.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSpot recurring issues in \u003cstrong\u003e1–3★\u003c\/strong\u003e reviews and prioritize product\/process changes.\u003c\/li\u003e\n  \u003cli\u003eFeed Etsy review exports into n8n using \u003cstrong\u003eCSV files\u003c\/strong\u003e for quick internal analysis.\u003c\/li\u003e\n  \u003cli\u003eUse \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e as a lightweight review dashboard for SaaS operators and ecommerce teams.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic\u003c\/strong\u003e used: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003ccode\u003ehttp request\u003c\/code\u003e, \u003ccode\u003egoogle sheets\u003c\/code\u003e, and \u003ccode\u003econvert to file\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003eNo auto-replies; no Etsy API integration—reviews come from \u003cstrong\u003eyour CSV export\u003c\/strong\u003e or the \u003cstrong\u003eGoogle Sheets “Reviews”\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003eGemini integration via \u003ccode\u003ehttp request\u003c\/code\u003e (optional, up to 40 reviews).\u003c\/li\u003e\n\u003c\/ul\u003e\n","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46223949594803,"sku":"N8N-20899","price":64.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/PFPHAaaR659zZwy8JqqJh_2KQzJpaD.png?v=1791969579","url":"https:\/\/buyflowscripts.com\/products\/n8n-etsy-review-theme-analyzer-fix-queue-from-csv-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}