ContentPilot | Agentic AI YouTube-to-Social Content Repurposing Engine

Project Overview

An end-to-end content distribution system built using Relevance AI and Notion. This automated workflow transforms a single long-form video or podcast episode into publication-ready drafts across multiple social media platforms within minutes, significantly reducing manual copywriting overhead.

The Challenge

Content creators, B2B founders, and marketing teams often spend 10 to 15 hours every week manually reviewing long videos, extracting transcripts, and rewriting them into platform-specific formats like X threads, LinkedIn carousels, and short-form video scripts. This operational bottleneck can constrain brand visibility and posting consistency.

The Solution

An intelligent AI agent pipeline designed to streamline the content extraction, generation, and organization process:

Automated Extraction & Ingestion: Ingests a designated YouTube URL as a trigger, utilizing a multi-layered tool stack (Video Data Extractor, Get Metadata & Subtitles, and Transcription Service) to securely pull and process video assets.

AI Processing Agent: Leverages advanced LLMs (such as GPT-4o or Claude via Relevance AI) to analyze the core message, tone, and key takeaways.

Structured Generation: Automatically formats output into platform-ready assets:

Centralized Content Hub: Automatically organizes and routes generated assets into designated database properties within the client’s Notion workspace for final human review and scheduling.

Tech Stack & Integrations

AI & Agent Orchestration: Relevance AI, OpenAI / Claude API

Data Ingestion: YouTube Data API & Subtitle Parsers

Content Hub & Database: Notion API

Workflow Logic: No-code agent architecture with strict structured JSON output parsing

Estimated Business Impact & Results

Time Efficiency: Designed to save content teams dozens of hours of manual copywriting and content slicing per month.

Workflow Consistency: Helps scale brand posting frequency across multiple channels without requiring immediate headcount expansion.

Streamlined Operations: Centralizes drafts in an organized Notion dashboard for rapid human review, approval, and scheduling.