Summarize weekly app store complaints with Apify, OpenAI and Slack

Description

Quick overview This workflow runs every Monday, scrapes the last 7 days of 1–2 star reviews from the App Store and Google Play via Apify, summarizes the main complaint themes with OpenAI, and posts a weekly digest to a Slack channel only when complaints exist. How it works Runs every Monday at 9:00 on a schedule trigger. Sends your App Store and Google Play app identifiers, country, rating filter (1–2 stars), and a 7-day lookback window to the Apify “App Store & Google Play Reviews Scraper” actor and retrieves the resulting review dataset. Aggregates the reviews into a single weekly payload, counting items per store and formatting up to 150 review lines with store, rating, version, and text for summarization. Stops if there are no matching reviews for the week. Uses OpenAI (gpt-5-mini) to produce a short Slack-ready digest listing 3–5 top complaint themes with estimated counts, a representative quote, and version callouts where relevant. Posts the digest to the selected Slack channel with a header showing total review count and the App Store vs Google Play breakdown. Setup Add an Apify credential (API token) and ensure the workflow can run the “cleanscrape/app-store-reviews-scraper” actor. Add an OpenAI API credential for the chat model used to summarize the reviews. Add a Slack credential with permission to post messages and make sure the target channel exists. Update the Settings values for your Google Play and App Store app links/IDs, store country, how many reviews to check, and the Slack channel name. Requirements Apify account. The Actor charges per review saved (about $0.20 per 1,000 reviews plus a small start fee); Apify's free plan includes monthly credit. OpenAI API key. Slack workspace and a channel for the digest. Customization Change the star ratings or the 7-day window in the Apify node's input. Check more reviews per run with reviewsToCheck in Settings. Send the digest to email, Microsoft Teams or Notion instead of Slack. Additional info The example Settings use the Strava app; replace them with your own app's links. Schedule times use the workflow's time zone. Made by CleanScrape, the developer of the Apify Actor used here. An n8n automation workflow template by CleanScrape.

Community Metrics

Categories

• Automation
• AI

Tags

• n8n
• workflow
• google-sheets
• slack
• code
• basic-llm-chain
• openai-chat-model
• structured-output-parser

Capabilities

• 6 nodes

Information