MARKET RESEARCH
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.
How it runs
The automated pipeline, trigger to output.
- TriggerMonthly discovery schedule fires
- ActionCompute multi-year sector growth rates in BigQueryBigQuery
- LogicFilter to adjacent, high-growth, untargeted sectors
- ActionScore and rank candidates as expansion bets via OpenAIOpenAI
- OutputEmail ranked expansion shortlist via GmailGmail
What it does
Surfaces where to grow next. It scans BigQuery public industry datasets for sectors adjacent to your current segments that show high establishment growth or favorable size distribution, scores each as a potential expansion bet against your fit criteria, and emails leadership a ranked shortlist of the most promising adjacent markets.
When to use it
When you want a steady pipeline of expansion ideas grounded in real industry growth data, rather than waiting for a planning offsite. Run it monthly to keep an evergreen shortlist of where the addressable market is opening up.
How it works
- 1A scheduled trigger fires on your cadence (e.g. monthly).
- 2A BigQuery action queries multi-year County Business Patterns data to compute growth rates by NAICS sector.
- 3A logic step filters to sectors adjacent to your core segments and above a growth floor, excluding ones you already target.
- 4An OpenAI action scores each candidate on growth, fit, and accessibility, then ranks them with a short rationale.
- 5An output step emails the ranked expansion shortlist to your distribution list via Gmail.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect OpenAIModels, embeddings, files.
- 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
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.
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.
New Earnings-Call Theme Digest to Slack
When a tracked competitor posts a new earnings-call transcript, summarizes the top three strategic themes and any guidance changes.
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.
