MARKET RESEARCH
On-demand competitor review topic-shift report via webhook
Accepts a webhook request naming a competitor app and version range, scrapes those reviews, classifies and loads them into BigQuery, runs the topic-shift comparison.
How it runs
The automated pipeline, trigger to output.
- TriggerWebhook with app id + two versionsHTTP webhook
- ActionScrape reviews for both versionsApify
- ActionClassify reviews into topics + sentimentOpenAI
- ActionLoad to BigQuery and compute version deltaBigQuery
- LogicRank shifts and assemble report payload
- OutputWrite report to Drive and return share linkGoogle Drive
What it does
Gives analysts an ad-hoc way to run the topic-shift analysis for any competitor app and any pair of versions on demand, without waiting for the scheduled jobs. A request specifies the app and the two versions to compare; the flow fetches the reviews, classifies them, lands them in BigQuery, computes the shift, and writes the result back so the requester gets an answer in one round trip.
When to use it
Use it for one-off competitive questions — a stakeholder asks 'what changed in their reviews between 4.2 and 4.3?' and you want an evidence-backed answer fast, reusing the same pipeline the scheduled jobs run on.
How it works
- 1A webhook receives the app id and the two versions to compare.
- 2Apify scrapes reviews for both target versions of the app.
- 3OpenAI classifies the reviews into the topic taxonomy with sentiment.
- 4Rows are loaded into BigQuery and the version-to-version topic delta is computed.
- 5A logic step ranks the shifts and assembles a concise report payload.
- 6The report is written to a Google Drive doc and the share link is returned in the webhook response.
Set it up
What you configure once, before turning it on.
- 1Connect HTTP webhookTrigger any URL on agent actions.
- 2Connect ApifyActors, scrapers, datasets.
- 3Connect OpenAIModels, embeddings, files.
- 4Connect BigQueryDatasets, queries, schemas.
- 5Connect Google DriveDocs, sheets, slides, files.
- 6Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 7Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 8Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Market Research workflows
Weekly Materiality-Ranked Filing Digest by Email
Each Friday, aggregates the week's regulatory filings across the coverage universe, ranks them by materiality.
Earnings Keyword-Spike Alert into Linear
Scans new earnings-call transcripts for a set of strategic keywords you care about, and when a competitor's mention frequency spikes above its historical baseline.
Allocate Sales Territory TAM from BigQuery Geo Data to HubSpot
When triggered by a webhook, queries BigQuery public ZIP-level business data to compute TAM per sales territory.
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.
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.
Cross-Competitor Theme-Shift Analyst
An agent that gathers the latest earnings transcripts across all tracked competitors, compares this quarter's themes against the prior quarter stored in Coda.
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.