MARKET RESEARCH
Competitor complaint-spike alert to Slack
Runs daily, detects when a complaint theme in competitor app reviews spikes above its baseline, and posts an alert with example quotes to a product Slack channel.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule
- ActionScrape yesterday's competitor reviewsApify
- ActionTag each review with a complaint themeOpenAI
- LogicCompare theme counts to baseline in PostgresPostgres
- LogicBranch only if a theme spikes
- OutputPost spike alert with quotes to SlackSlack
What it does
This workflow watches competitor app-store reviews every day and fires only when something changes: a complaint theme whose daily volume jumps well above its rolling baseline. When that happens it posts a focused Slack alert naming the theme, the spike size, and a few real review quotes, so product hears about a competitor's meltdown the same day it starts.
When to use it
Use it when you don't want a weekly digest — you want to be pinged the moment a rival ships a bad update or has an outage that's blowing up their reviews, so you can react in real time.
How it works
- 1A daily schedule triggers the run each morning.
- 2Apify scrapes yesterday's reviews for each tracked competitor.
- 3OpenAI tags each review with a complaint theme and the run computes each theme's count.
- 4A logic step compares today's per-theme counts against the trailing baseline stored in Postgres and updates the baseline.
- 5If any theme exceeds its spike threshold, a Slack message is posted with the theme, the multiplier, and sample quotes; otherwise the run ends silently.
Set it up
What you configure once, before turning it on.
- 1Connect ApifyActors, scrapers, datasets.
- 2Connect OpenAIModels, embeddings, files.
- 3Connect PostgresAny Postgres URL — query, write, migrate.
- 4Connect SlackChannels, DMs, threads, mentions.
- 5Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 6Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 7Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Market Research workflows
Discover Adjacent Segments from BigQuery and Rank Expansion Bets
On a schedule, scans BigQuery public industry data for fast-growing NAICS sectors adjacent to your core segments, scores them as expansion bets.
Weekly Materiality-Ranked Filing Digest by Email
Each Friday, aggregates the week's regulatory filings across the coverage universe, ranks them by materiality.
Blend BigQuery TAM with Live Competitor Signals into a Notion Brief
On demand, sizes a chosen segment from BigQuery public data, gathers current competitor signals via Brave Search, and synthesizes a one-page market brief into Notion.
TAM Sizer from BigQuery Public Census Data by Segment
On a schedule, queries BigQuery public Census and business-pattern datasets to size the total addressable market for each of your target segments.
Agent-Driven Deep-Dive Filing Investigation to Notion
When a flagged filing arrives, an agent autonomously researches it across multiple sources, pulls supporting context, builds a thesis-impact write-up.
On-Demand Filing Diff Memo Published to Confluence
On a webhook trigger with a company and filing URL, fetches the document, diffs it against the prior filing.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.