MARKET RESEARCH
VoC sentiment trend pipeline to a warehouse dashboard
Weekly, it scrapes G2 and Reddit for you and your competitors, scores each snippet on sentiment and theme with OpenAI.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule
- ActionScrape G2 + Reddit for brand and rivalsApify
- ActionScore sentiment + tag theme per snippetOpenAI
- LogicNormalize into flat dashboard schema
- ActionAppend weekly-partitioned rows to BigQueryBigQuery
- OutputSlack the refreshed dashboard + top swingSlack
What it does
It builds the data layer behind positioning decisions. Each week it collects voice-of-customer snippets across G2 and Reddit for your brand and rivals, scores them for sentiment and tags them by theme, and appends structured rows to a BigQuery table. Over time this becomes a queryable trend of how perception shifts by competitor and topic.
When to use it
Use it when you want a durable, charted record of sentiment and theme movement to power a recurring dashboard, instead of one-off memos that aren't comparable quarter to quarter.
How it works
- 1A weekly schedule trigger starts the collection.
- 2Apify scrapes G2 reviews and Reddit threads for your brand and competitor set.
- 3OpenAI scores each snippet for sentiment (-1 to 1) and assigns a theme tag and source.
- 4A logic step normalizes the records into a flat, dashboard-ready schema.
- 5The rows are appended to a BigQuery table partitioned by week.
- 6A Slack note links the refreshed dashboard and flags the biggest week-over-week swing.
Set it up
What you configure once, before turning it on.
- 1Connect ApifyActors, scrapers, datasets.
- 2Connect OpenAIModels, embeddings, files.
- 3Connect BigQueryDatasets, queries, schemas.
- 4Connect SlackChannels, DMs, threads, mentions.
- 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.
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.
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.