CONTENT CREATION
Detect Decaying Evergreen Pages and Queue Rewrites in Notion
Runs weekly against BigQuery search analytics to find evergreen URLs whose organic clicks dropped versus their trailing baseline.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly Monday schedule
- ActionQuery trailing 28-day vs 12-week baseline clicksBigQuery
- LogicKeep pages down >25% with real baseline traffic
- ActionDraft rewrite brief per pageOpenAI
- OutputCreate prioritized rewrite card in NotionNotion
What it does
Every Monday it scans your Search Console export in BigQuery, compares each page's last-28-day organic clicks against its prior 12-week median, and flags pages that have lost meaningful traffic. Each flagged page becomes a Notion task with the decay percentage, current rank, and a one-line rewrite brief.
When to use it
Use it when you have a library of evergreen articles and no systematic way to catch the ones quietly sliding down the SERP. It turns "we should refresh old posts someday" into a ranked, ready-to-assign queue.
How it works
- 1A weekly schedule fires the workflow Monday morning.
- 2A BigQuery query pulls per-URL clicks for the trailing 28 days plus the 12-week median baseline.
- 3A logic step keeps only pages down more than 25 percent that still had real traffic at baseline, filtering out noise from low-volume URLs.
- 4OpenAI drafts a short rewrite brief per page — what likely went stale and what to update.
- 5The workflow creates one Notion database card per page with decay, brief, and priority, ready for the content team to pick up.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect OpenAIModels, embeddings, files.
- 3Connect NotionPages, databases, comments.
- 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.