MARKET RESEARCH
Earnings-Call Theme Extraction into a Competitor Comparison Grid
Scrapes the latest earnings-call transcripts for your tracked competitor set, extracts recurring strategic themes with an LLM.
How it runs
The automated pipeline, trigger to output.
- TriggerEarnings-season schedule fires
- ActionRead tracked competitors + transcript URLsAirtable
- ActionScrape each transcript to clean textFirecrawl
- ActionExtract themes, quotes, sentiment per companyOpenAI
- LogicNormalize to one row per company-theme
- OutputUpsert rows into comparison gridAirtable
What it does
Keeps a living comparison grid of what your competitors are actually talking about on their earnings calls. For each company in a tracked list, it pulls the most recent transcript, distills the management commentary into a fixed set of strategic themes (pricing, AI, margins, headcount, guidance, churn, etc.), and lands one row per company-theme into an Airtable grid you can pivot and filter.
When to use it
Run it after each earnings season when you need a structured read on competitive positioning rather than reading ten transcripts by hand. Useful for product strategy, competitive intelligence, and board-prep decks.
How it works
- 1A schedule kicks off the run during earnings season.
- 2The flow reads the tracked competitor list and each company's transcript URL from an Airtable base.
- 3Firecrawl scrapes each transcript page into clean text.
- 4OpenAI extracts the named themes per company, returning a structured JSON array with a verbatim supporting quote and a sentiment tag for each theme.
- 5The flow normalizes results into one row per company-theme.
- 6Rows are upserted into the Airtable comparison grid, keyed on company plus quarter so re-runs update in place.
Set it up
What you configure once, before turning it on.
- 1Connect AirtableBases, tables, views, automations.
- 2Connect FirecrawlCrawl, scrape, structured extract.
- 3Connect OpenAIModels, embeddings, files.
- 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.
