CONTENT CREATION

Detect Decaying Pages from Analytics and Draft Refresh Briefs

On a weekly schedule, scans your published pages for organic-traffic decline, re-crawls the decayed URLs, and writes a prioritized refresh brief for each one into Notion.

CategoryContent Creation
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekly schedule fires
  • ActionQuery 90-day traffic deltas per URLPostgreSQLPostgres
  • LogicKeep URLs with significant decline, rank by lost sessions
  • ActionRe-crawl decayed pages for current contentFirecrawl
  • ActionDraft structured refresh briefOpenAI
  • OutputCreate brief in Notion refresh queueNotionNotion

What it does

It finds pages whose organic traffic has slid over the trailing 90 days, re-reads what's actually on each page, and produces a concrete refresh brief — what's stale, what to add, and which keywords slipped — so writers start from a plan instead of a hunch.

When to use it

Run it when you have a library of evergreen content and no systematic way to know which posts are quietly losing rankings. Ideal for content teams that publish faster than they audit and want a steady weekly queue of high-leverage updates rather than ad-hoc rewrites.

How it works

  1. 1A weekly schedule fires the run.
  2. 2A Postgres query pulls per-URL traffic for the last 90 vs. prior 90 days from your warehoused analytics table.
  3. 3A logic step keeps only URLs with a meaningful decline (e.g. >25% drop, minimum traffic floor) and ranks them by lost sessions.
  4. 4Firecrawl re-crawls each surviving URL to capture current title, headings, and body.
  5. 5OpenAI compares the live content against the decline signal and drafts a structured brief: stale claims, missing subtopics, suggested new sections, and target keywords.
  6. 6Each brief is written as a new page in a Notion "Content Refresh Queue" database, tagged with priority and lost-traffic estimate.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect PostgresAny Postgres URL — query, write, migrate.
  2. 2
    Connect FirecrawlCrawl, scrape, structured extract.
  3. 3
    Connect OpenAIModels, embeddings, files.
  4. 4
    Connect NotionPages, databases, comments.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.