YouTube Content Pipeline
An automated YouTube topic scouting pipeline: hourly search for fresh AI news on the web and X/Twitter, idea deduplication, and pitch delivery to Telegram.
The workflow includes an hourly cron job that scans fresh AI news across the web and X/Twitter and pitches ideas to Telegram. A 90-day video catalog with view counts and topic analysis helps avoid re-covering topics, while all pitches are stored in SQLite with vector embeddings for semantic dedup.
Requirements
- Built-in
web_searchskill - x-research-v2 or a custom X/Twitter search skill
- knowledge-base skill for RAG
- Asana integration (or Todoist)
gogCLI for YouTube Analytics- Telegram topic for receiving pitches
- For the optional branch triggered by sharing a link in
#ai_trends, access to Slack and that channel
The skill links point to the ClawHub home page; the source does not provide exact installation pages or integration setup instructions.
>Как настроить
- Set up a Telegram topic for video ideas and configure it in OpenClaw.
- Install the knowledge-base skill and the x-research skill.
- Create a SQLite database for pitch tracking:
This is the table schema for SQLite. The source does not explain where to store the database or how to connect it to OpenClaw.
CREATE TABLE pitches (
id INTEGER PRIMARY KEY,
timestamp TEXT,
topic TEXT,
embedding BLOB,
sources TEXT
);
- Prompt OpenClaw:
Run an hourly cron job to:
1. Search web and X/Twitter for breaking AI news
2. Check against my 90-day YouTube catalog (fetch from YouTube Analytics via gog)
3. Check semantic similarity against all past pitches in the database
4. If novel, pitch the idea to my Telegram "video ideas" topic with sources
Also: when I share a link in Slack #ai_trends, automatically:
1. Research the topic
2. Search X for related posts
3. Query my knowledge base
4. Create an Asana card in Video Pipeline with a full outline
Source: hesamsheikh/awesome-openclaw-usecases and its contributors. License: MIT.
Copyright (c) 2026
Translation and editorial adaptation by ClawCases.
>Resources
>Related Use Cases
AI-Powered Earnings Tracker
Stay on top of earnings season across dozens of tech companies without manually checking multiple sources and remembering report dates for every AI/tech earnings report.
AI Video Editing via Chat
Describe your edit to an agent to trim videos, add music, subtitles, or crops — no timeline or GUI. Install two skills, then editing is done by conversation.
Persistent Hermes on Hugging Face Spaces
HermesFace packages Hermes as a Docker-based Hugging Face Space with a browser dashboard and messaging gateway, periodically syncing /opt/data to a private Dataset repository so conversations, skills, memory, and configuration survive container restarts.