CONTENT CREATION
Nightly backfill of missing hero images on published posts
Runs nightly, queries your Postgres CMS for published posts missing a hero image, generates a palette-constrained illustration for each, uploads to R2, and updates the post record.
How it runs
The automated pipeline, trigger to output.
- TriggerNightly schedule fires
- ActionQuery Postgres for published posts missing heroPostgres
- ActionBuild palette-locked prompt per post
- ActionRender illustration via ReplicateReplicate
- ActionUpload image to public R2 bucketCloudflare R2
- OutputUpdate post row with hero URL and timestampPostgres
What it does
Closes the gap on older content that shipped without art. On a schedule, it finds published posts that lack a hero image, generates an on-brand illustration for each, stores it in R2, and updates the database so the site renders the new art on next load.
When to use it
Use it after adopting hero images on a blog that has a backlog of imageless posts, or as a safety net that catches any post that slipped through without art. It steadily improves the whole archive without manual effort.
How it works
- 1A nightly schedule trigger starts the run.
- 2A Postgres query selects published posts where the hero image column is null, capped at a nightly batch size to control cost.
- 3For each post, a prompt is built from its title and excerpt with the brand palette and style locked in.
- 4Replicate renders the illustration.
- 5The image is uploaded to a public R2 bucket.
- 6The post row is updated with the new hero URL and a generated-at timestamp so it is not reprocessed.
Set it up
What you configure once, before turning it on.
- 1Connect PostgresAny Postgres URL — query, write, migrate.
- 2Connect ReplicateImage, video, and model inference.
- 3Connect Cloudflare R2Object storage, S3-compatible.
- 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.