MARKET RESEARCH
Weekly cross-interview theme rollup to Slack
On a weekly schedule, this scans the past week of logged interview themes in Airtable, clusters the recurring jobs-to-be-done across calls, and posts a ranked digest to Slack.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule
- ActionQuery last 7 days of themesAirtable
- LogicStop if too few interviews
- ActionCluster and rank recurring jobsOpenAI
- OutputPost ranked digest to SlackSlack
What it does
Aggregates the week's individual interview findings into one cross-cutting picture. It reads every theme logged in your Airtable research base over the last seven days, clusters them into recurring jobs-to-be-done, ranks each cluster by how many distinct interviews mentioned it, and posts a ranked digest to a Slack channel so the whole team sees what customers keep asking for.
When to use it
Use it when single-interview notes pile up faster than anyone can synthesize them, and you need a Monday-morning view of which jobs are trending across the corpus rather than what one person said.
How it works
- 1A weekly schedule triggers the rollup.
- 2The flow queries Airtable for all theme records created in the last seven days.
- 3A logic step bails early if too few interviews were logged to be worth summarizing.
- 4OpenAI clusters the raw themes into recurring jobs and ranks them by interview frequency.
- 5A formatted ranked digest is posted to the team's research Slack channel with counts and example quotes.
Set it up
What you configure once, before turning it on.
- 1Connect AirtableBases, tables, views, automations.
- 2Connect OpenAIModels, embeddings, files.
- 3Connect SlackChannels, DMs, threads, mentions.
- 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.