MARKET RESEARCH
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.
How it runs
The automated pipeline, trigger to output.
- TriggerOperator starts run for a chosen segment
- ActionSize the segment from BigQuery public datasetsBigQuery
- ActionGather competitor and news signals via Brave SearchBrave Search
- LogicDedupe and rank search results by relevance and recency
- ActionSynthesize TAM plus signals into a one-page briefOpenAI
- OutputCreate market brief as a Notion pageNotion
What it does
Pairs hard sizing with live market context for a single segment. You kick it off for a target segment; it pulls the quantitative TAM from BigQuery public datasets, then runs Brave Search to gather recent competitor activity, funding, and product moves, and merges both into a single readable market brief published to Notion.
When to use it
When someone asks "how big is this segment and who's already there?" before a build/buy/enter decision. Good for ad-hoc strategy questions where you want numbers and narrative in one artifact.
How it works
- 1A manual trigger starts the run with the chosen segment as input.
- 2A BigQuery action returns the segment's establishment count, employment, and size-band distribution.
- 3A Brave Search action gathers recent news and competitor mentions for the segment's keywords.
- 4A logic step dedupes and ranks the search results, keeping the most relevant and recent items.
- 5An OpenAI action synthesizes the TAM figures and competitor signals into a structured one-page brief.
- 6An output step creates the brief as a new Notion page.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect Brave SearchWeb, news, image, video search.
- 3Connect OpenAIModels, embeddings, files.
- 4Connect NotionPages, databases, comments.
- 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
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.
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.