CONTENT CREATION
Alert Slack When a Tracked Evergreen Page Loses Its Top-3 Ranking
Checks daily whether any of your priority evergreen pages fell out of the top 3 search positions for its target query.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily morning schedule
- ActionPull yesterday's avg position per tracked pageBigQuery
- LogicKeep pages that dropped out of top 3
- ActionSummarize cause and recommend actionOpenAI
- OutputPost triage alert to Slack channelSlack
What it does
It watches a defined list of high-value evergreen pages and their target keywords. Each day it reads current ranking data from BigQuery, detects pages that dropped below position 3, identifies which competitor URL now outranks them, and posts a Slack alert so the owner can react before traffic erodes further.
When to use it
Use it for your money pages — the handful of evergreen guides that drive pipeline. A weekly batch is too slow for these; you want same-day notice when a ranking slips so you can investigate while it's still recoverable.
How it works
- 1A daily morning schedule triggers the run.
- 2BigQuery returns yesterday's average position per tracked page and query.
- 3A logic step compares each against the prior day and keeps pages that crossed from top-3 into position 4 or worse.
- 4OpenAI summarizes the likely cause and drafts a recommended next action per page.
- 5The workflow posts a Slack message to the content channel tagging the page owner, with the new top-ranking competitor URL.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 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 Content Creation workflows
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.
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.
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.
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.
Research-driven localized hero banners tuned per market
An agent researches cultural and seasonal cues for each target market, adapts the master hero concept to fit local context, generates a tailored image per locale.
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.