Summarize Etsy review themes and rank a fix queue with Sheets and CSV

Description

Quick overview
Free n8n workflow that themes 1–3★ reviews and ranks which listing to fix first. No auto-replies and no Etsy API — you bring a CSV. Default is keyword rules (optional Gemini untested).

How it works
Starts manually and loads configuration for input mode (mock, CSV files, or Google Sheets) and output destination (CSV files or Google Sheets).
Pulls reviews from built-in sample data, reads and parses local reviews*.csv files, or reads rows from the Google Sheets tab named Reviews.
Optionally sends up to 40 reviews to the Google Gemini API for theme classification, and falls back to the built-in rules if the Gemini step is skipped or fails.
Applies rule-based keyword tagging to classify reviews into shipping, sizing, quality, description, packaging, or other, and flags empty or spammy reviews.
Aggregates only low-rated reviews (≤ the configured star threshold) into theme counts and ranks listings into a “Fix Queue” with suggested next actions.
Writes four outputs—By Review, Themes, Fix Queue, and Summary—either into corresponding Google Sheets tabs or as CSV files saved to the configured output folder.

Setup
Choose your input mode in the Config step: keep mode: "mock" for testing, or provide your own review export via local reviews*.csv files (mode: "files") or a Google Sheet Reviews tab (`mode: "sheet").
If using Google Sheets input or output, add a Google Sheets OAuth credential and replace PASTE_YOUR_SHEET_ID_HERE with your spreadsheet ID for the Reviews/By Review/Themes/Fix Queue/Summary tabs.
If using file input/output, run on self-hosted n8n with access to the configured filesFolder and outputFolder paths, and ensure the folders exist and are writable.
(Optional) To try Gemini theme classification, set themeEngine: "gemini" and add an HTTP Header Auth credential with header name x-goog-api-key and your Gemini API key.
Review and adjust minStarsForTheme and summaryLanguage in Config to control which reviews drive the Fix Queue and which language is used for the primary summary.

Additional info
What it does
Themes complaints: shipping, sizing, quality, description, packaging, other
Fix Queue: listings ranked by complaint-review count, with a short "update this…" suggestion
Four outputs: By Review, Themes, Fix Queue, Summary (EN + ZH)
Demo mode with built-in fake reviews; CSV / Sheet import structure included

What it does NOT do
No reply drafts, no sending, no Judge.me / Etsy API connection in v0.1

Honest limits
Tested with built-in fake reviews so far
CSV / Google Sheet import and themeEngine=gemini not live-tested by us
Keywords are mostly English; always human-read before editing listings

Free download:
https://stallkitstudio.gumroad.com/l/review-radar
Store: https://stallkitstudio.gumroad.com

Etsy, n8n and Judge.me are trademarks of their respective owners. Stallkit Studio is not affiliated with or endorsed by them.