MARKET RESEARCH
On-Demand Deep-Dive Brief for One App, Saved to Google Drive
Run manually for a single app: pulls its full BigQuery rank history, researches its competitor and release timeline on the web.
How it runs
The automated pipeline, trigger to output.
- TriggerManual run with target app
- ActionQuery full rank history from BigQueryBigQuery
- ActionResearch competitors and release timelineBrave Search
- ActionAgent correlates inflections and reasons on causesOpenAI
- OutputSave deep-dive brief to Google DriveGoogle Drive
What it does
This is the manual, analyst-grade option. You launch it for one specific app and it does the heavy lifting: queries BigQuery for the app's complete install-rank history, then runs agent-driven research across the web to reconstruct its competitor landscape and release timeline. The agent reasons over both — correlating each notable rank inflection to a release or competitor event — and produces a structured long-form brief, saved as a formatted document in Google Drive for sharing.
When to use it
Use it when a single app warrants a real investigation — a board update, a competitive teardown, or a build-versus-watch decision — and you want depth and reasoning rather than a templated alert.
How it works
- 1A manual trigger starts the run with the target app as input.
- 2A BigQuery query returns the app's full rank history.
- 3An agent step researches competitors and the release timeline via web search.
- 4The agent correlates rank inflections to events and reasons about causes.
- 5The finished deep-dive brief is saved as a Google Drive document.
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 Google DriveDocs, sheets, slides, files.
- 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
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.