Библиотека / Отчёты, аналитика и дашборды
Отчёты, аналитика и дашборды
Сводка тем отзывов Etsy и ранжирование очереди исправлений в Sheets с помощью Gemini
Запускается вручную: классифицирует низкие оценки отзывов Etsy по темам жалоб с помощью правил по ключевым словам или Gemini, затем формирует ранжированную очередь исправлений в Sheets или CSV без подготовки ответов.
Что делает
## Review Radar for Etsy Shops v0.1 Find complaint themes and a ranked Fix Queue from shop reviews. This workflow does not draft or send review replies. Default Config: themeEngine: "rules", mode: "mock", output: "files". No Etsy API and no Gemini unless you opt in. ### How it works 1. Load reviews from mock data, a CSV folder, or a Google Sheet Reviews tab. 2. Classify each review into themes (shipping, sizing, quality, description, packaging, other) with keyword rules — or optional Gemini. 3. Keep ★ ≤ minStarsForTheme (default 3) for theme aggregation; flag spam/empty rows. 4. Write four outputs: By Review, Themes, Fix Queue (listings ranked by complaint volume), and Summary. ### Setup 1. Import this workflow and click Test workflow with the defaults (mock + rules). 2. Self-hosted: CSVs land under outputFolder (default /home/node/.n8n-files/review-radar/). On n8n Cloud, inspect the Rows: nodes. 3. Your data: set mode to "files" (CSV reviews*.csv) or "sheet" (paste your Sheet URL; tabs Reviews plus the four output tabs). Set output to "files" or "sheet". 4. Optional Gemini: create Header Auth named x-goog-api-key, select it on Gemini classify (optional), set themeEngine: "gemini". Free-tier rate limits apply; themes can be wrong — always read the weekly report yourself. On failure the flow falls back to rules. Etsy and n8n are trademarks of their respective owners. Stallkit Studio is not affiliated with them. Not legal advice; not a substitute for reading all reviews.
Шаги
- Run
- Config
- Mode = mock?
- Mock reviews (fake data)
- Mode = files?
- Read reviews CSV
- Parse reviews CSV
- Normalize files reviews
- Read Reviews sheet
- Normalize sheet reviews
- Theme engine = gemini?
- Prep Gemini (optional)
- Gemini classify (optional)
- Merge Gemini / fallback rules
Всего шагов: 36.
Похожие автоматизации
Веб-скрейпинг и исследованияПарсинг объявлений Etsy с Bright Data и GeminiШагов: 15Веб-скрейпинг и исследованияСбор данных о товарах Etsy с Bright Data и GeminiШагов: 47RAG и базы знанийПубликация отзывов Etsy в Slack с OpenAI RAGШагов: 11Публикации в соцсетяхPost Etsy and Shopify products to Pinterest and Instagram with SocialRobot and OpenAIШагов: 33