CONTENT CREATION
Weekly localized clip performance roundup by market
Each week, pulls engagement metrics for published demo clips, compares performance across markets.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly roundup schedule fires
- ActionPull engagement metrics for published clips
- ActionStore metrics in BigQuery for historyBigQuery
- LogicGroup by market and rank top vs. laggard clips
- OutputPost per-market roundup to SlackSlack
What it does
Closes the loop on localized clip distribution by reporting how each market's clips actually performed, week over week, so you know which markets and which clips are landing.
When to use it
Use once you are publishing localized clips at volume and need a recurring read on what is working per market — without manually pulling numbers from each platform.
How it works
- 1A weekly schedule fires the workflow.
- 2It reads the published-clips registry and pulls the latest engagement metrics for each into a working set.
- 3The metrics are written to a BigQuery table for historical tracking.
- 4A logic step groups clips by market and ranks them, identifying top performers and laggards per region.
- 5A concise per-market roundup is composed.
- 6The roundup is posted to the team's Slack channel.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect SlackChannels, DMs, threads, mentions.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Content Creation workflows
On-demand: turn a blog URL into narrated B-roll clips
Accepts a blog URL via webhook, scrapes the article, generates a B-roll clip per paragraph with Replicate and a voiceover with ElevenLabs.
Sync a Figma master frame into localized hero renders
Pulls the current master hero frame and its text layers from Figma, generates a localized image variant for each locale defined in Airtable.
Build a Dropbox B-roll library from exported blog drafts
Triggers when a new blog draft file lands in a Dropbox folder, generates a Replicate B-roll clip for each paragraph.
Generate B-roll clips when a blog post is marked Ready in Notion
Watches a Notion blog database for posts flipped to 'Ready', splits the body into paragraphs, and generates a short B-roll video clip for each paragraph with Replicate.
Weekly: clip last week's top blog paragraph and post to socials
Runs on a weekly schedule, picks the highest-traffic paragraph from the past week's posts, generates one polished B-roll clip with Replicate.
On-Demand Screenshot Freshness Report from a Slack Command
A writer requests a freshness check in Slack for a specific docs page; the workflow inspects every screenshot on that page, scores each by age and version gap.
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.