Content Repurposing Planner
Turn one big published asset into a full, owned-and-dated plan of social posts, email snippets, carousels, and video scripts - with a human approval gate before anything hits your production queue.
A private internal tool where you drop in one pillar asset, an AI proposes a tailored set of derivatives per channel, your content lead edits and approves them, and approved derivatives become tasks with owners and dates - exportable as CSV to your calendar or board.
Before you start
- A free Supabase account
- A free Vercel account
- A free Resend account
- Your channel-format cheat sheet (length/specs per channel) handy
The problem this kills
You publish a great pillar post - a deep blog article, a webinar, a research report - and then it just sits there. You meant to slice it into a week of LinkedIn posts, a carousel, an email blurb, and a short video script. But there was no plan, no owner, no date, so the big asset got mined once and abandoned. Multiply that across a year of content and you've left most of your best work on the table.
The other failure mode is the opposite: someone repurposes the same asset twice by accident, or two people draft the same LinkedIn post because nobody could see what was already planned.
This tool fixes both. One asset in, a complete derivative plan out - reviewed by a human, owned, dated, and de-duplicated.
What you'll build
A small private web app for your content team:
- Add a source "pillar" asset by pasting text or a URL.
- The AI proposes a set of derivatives for each channel you repurpose to - respecting the exact length and format specs from your own channel cheat sheet.
- Your content lead reviews the proposed list, edits titles, owners, and dates, drops the ones that don't fit, and approves.
- Only approved derivatives become real tasks - each one linked back to its source asset so you can track what came from where.
- Export the whole plan as a CSV in the exact columns your content calendar or board expects.
Everything is gated behind login, every team member only sees their own organization's data, and there's a full audit trail of who proposed, edited, and approved what.
What's inside the Implementation Plan
The plan is a single markdown file you paste into Claude Code (a free AI coding assistant). It walks the AI through building the whole tool step by step, with a ready-to-copy prompt at the end of every step.
The best part: the plan opens by interviewing you about your business - your channels, your real content types, your naming conventions, your approval rules, your peak volumes, and your messy edge cases. It then reflects a short tailored spec back to you for a thumbs-up before building anything. You get a tool shaped around how your team actually works, not a generic template you have to bend yourself into.
Inside you'll find: the discovery interview, the data model, the AI-drafting step, the human approval gate, the audit trail, the duplicate guard, the CSV export, and a clear "how to know it works" checklist.
The governance it includes (this is the point)
- Login so only your team can use the tool.
- Row-level security so each organization only ever sees its own assets and plans.
- A complete audit trail - who proposed, edited, approved, and exported, and when.
- A hard human-in-the-loop approval gate - the AI only drafts; nothing becomes a real task until your content lead reviews and approves.
- A duplicate guard keyed on source asset + channel + format so the same derivative can never be planned twice.
Who it's for
Content managers and marketing ops people who publish great work and then never fully repurpose it - and who want a repeatable, accountable process instead of good intentions. No coding experience needed.
You've got this - paste the first prompt and let the interview tailor the rest.