See llms.txt for all machine-readable content.

Back to Templates

Summarize weekly app store complaints with Apify, OpenAI and Slack

Created by

Created by: CleanScrape || cleanscrape
CleanScrape

Last update

Last update a day ago

Categories

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

  1. Runs every Monday at 9:00 on a schedule trigger.
  2. 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.
  3. 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.
  4. Stops if there are no matching reviews for the week.
  5. 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.
  6. Posts the digest to the selected Slack channel with a header showing total review count and the App Store vs Google Play breakdown.

Setup

  1. Add an Apify credential (API token) and ensure the workflow can run the “cleanscrape/app-store-reviews-scraper” actor.
  2. Add an OpenAI API credential for the chat model used to summarize the reviews.
  3. Add a Slack credential with permission to post messages and make sure the target channel exists.
  4. 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.