MARKET RESEARCH
Generate a monthly competitive review-topic brief from BigQuery
An agent reads the month's app-store review topic shifts across all tracked competitors from BigQuery.
How it runs
The automated pipeline, trigger to output.
- TriggerMonthly schedule fires
- ActionQuery month's topic deltas + sentiment per appBigQuery
- LogicAgent separates signal from noise, groups themes
- ActionPublish narrative brief to ConfluenceConfluence
- OutputEmail summary + link to distribution listGmail
What it does
Produces a written competitive-intelligence brief, not just a chart. An agent queries the month's topic-shift data for every tracked competitor app in BigQuery, reasons about which movements are meaningful versus noise, ties shifts to known release events, and drafts a structured narrative: headline changes, per-competitor breakdown, and recommended responses. The brief is published and emailed.
When to use it
Use it when leadership wants prose they can read in five minutes rather than a dashboard to interpret. Good as a recurring monthly artifact for product marketing, strategy, or board prep.
How it works
- 1A monthly schedule kicks off the run.
- 2The agent queries BigQuery for the month's topic-share deltas, sentiment trends, and volume per competitor app.
- 3The agent analyzes the results, separating signal from noise and grouping shifts into themes.
- 4It drafts a structured brief with headlines, per-app sections, and suggested actions.
- 5The brief is published to a Confluence page.
- 6A link and executive summary are emailed to the distribution list via Gmail.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect ConfluenceSpaces, pages, blueprints.
- 3Connect GmailRead, draft, send, label.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Market Research workflows
Enrich Inbound Accounts with BigQuery Firmographics and Score Fit
When a new account row lands in Airtable, joins it against BigQuery public business datasets to attach firmographic attributes.
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.
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.
Hiring Surge Detector with Slack Alert
Detects when a target account's open-role count jumps above its recent baseline and posts a ranked Slack alert to the GTM channel so reps can act on a company that is clearly…
Tech-Stack Shift Inference from Job Descriptions
Reads new job descriptions for target accounts, uses an LLM to extract named technologies and infer stack changes.
Weekly Hiring-Intel Briefing for GTM
An agent reviews the week's accumulated hiring signals across all target accounts, writes a narrative briefing that infers each account's likely initiatives.
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.