{"product_id":"triage-app-store-reviews-with-apify-openai-slack-alerts","title":"Triage App Store Reviews with Apify + OpenAI, Slack Alerts","description":"\u003ch3\u003eTriage App Store \u0026amp; Google Play reviews automatically—send the right alerts to Slack with Apify + OpenAI\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls fresh App Store and Google Play reviews via \u003cstrong\u003eApify\u003c\/strong\u003e every 12 hours, deduplicates them in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, classifies sentiment and topics with \u003cstrong\u003eOpenAI\u003c\/strong\u003e (or a rules fallback), drafts reply text, and routes low-star, unanswered reviews to the right \u003cstrong\u003eSlack\u003c\/strong\u003e channels.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on schedule:\u003c\/strong\u003e executes twice daily (every 12 hours).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches new reviews:\u003c\/strong\u003e calls the Apify actor \u003cem\u003e“App Reviews Unified”\u003c\/em\u003e for your configured iOS and Android app IDs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack on failures\/no data:\u003c\/strong\u003e alerts Slack if the Apify request fails or returns no reviews.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates with Google Sheets:\u003c\/strong\u003e reads an existing review log from Google Sheets and keeps only reviews not yet logged (requires a \u003cstrong\u003e“Review ID”\u003c\/strong\u003e column).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies \u0026amp; drafts replies:\u003c\/strong\u003e optionally sends each new review to \u003cstrong\u003eOpenAI\u003c\/strong\u003e to assign topic and sentiment, create a short summary, and draft a public reply; if AI is disabled or invalid JSON is returned, it falls back to keyword rules.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs results:\u003c\/strong\u003e appends newly found reviews (including classification fields) to Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes critical reviews to Slack:\u003c\/strong\u003e filters for \u003cstrong\u003elow-star\u003c\/strong\u003e and \u003cstrong\u003eunanswered\u003c\/strong\u003e reviews and routes them by topic:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003ebugs\/login\/performance\u003c\/strong\u003e → engineering Slack channel\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003ebilling\u003c\/strong\u003e → billing Slack channel\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eeverything else\u003c\/strong\u003e → support Slack channel\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams that want faster response times to negative App Store reviews.\u003c\/li\u003e\n  \u003cli\u003eSupport\/engineering workflows that route issues to the correct team automatically.\u003c\/li\u003e\n  \u003cli\u003eOperators who need an auditable review history with classification fields in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify\u003c\/strong\u003e: “App Reviews Unified” actor (HTTP Header Auth using \u003ccode\u003eAuthorization: Bearer \u0026lt;your token\u0026gt;\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth connection for reading existing logs and appending new reviews (dedupe via “Review ID”).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e: topic\/sentiment, summary, and reply drafting; keyword-rule fallback if AI is disabled\/invalid output.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e: alerts on Apify failures\/no reviews and routing for low-star unanswered reviews.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/tools\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eslack\u003c\/code\u003e, \u003ccode\u003efilter\u003c\/code\u003e, \u003ccode\u003eswitch\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46275637870771,"sku":"N8N-21479","price":2.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/J0mO516Siamyk9fumvlWD_0lcJbzWT.png?v=1792832908","url":"https:\/\/buyflowscripts.com\/products\/triage-app-store-reviews-with-apify-openai-slack-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}