[PR #478] [CLOSED] Add AI Content Factory for AgroDrone Europe with human-in-the-loop review #6798

Closed
opened 2026-05-31 14:18:07 -05:00 by GiteaMirror · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/Shubhamsaboo/awesome-llm-apps/pull/478
Author: @ponomarevs123
Created: 2/8/2026
Status: Closed

Base: mainHead: claude/create-content-factory-k9pkp


📝 Commits (4)

  • 623558a Add AI Content Factory for AgroDrone Europe
  • 51371a4 Add FastAPI version and n8n workflow for content factory
  • da930d3 Add RSS news feeds and AI topic planner for autonomous content pipeline
  • 82d40c9 Add human-in-the-loop review, image generation, and social media pipeline

📊 Changes

9 files changed (+2320 additions, -0 deletions)

View changed files

advanced_ai_agents/single_agent_apps/ai_content_factory/README.md (+217 -0)
advanced_ai_agents/single_agent_apps/ai_content_factory/content_factory.py (+173 -0)
advanced_ai_agents/single_agent_apps/ai_content_factory/content_factory_api.py (+614 -0)
advanced_ai_agents/single_agent_apps/ai_content_factory/media_generator.py (+283 -0)
advanced_ai_agents/single_agent_apps/ai_content_factory/n8n_workflow_example.json (+280 -0)
advanced_ai_agents/single_agent_apps/ai_content_factory/news_fetcher.py (+176 -0)
advanced_ai_agents/single_agent_apps/ai_content_factory/requirements.txt (+9 -0)
advanced_ai_agents/single_agent_apps/ai_content_factory/review_queue.py (+318 -0)
advanced_ai_agents/single_agent_apps/ai_content_factory/rss_feeds.py (+250 -0)

📄 Description

Summary

This PR introduces a complete content production pipeline for AgroDrone Europe (agrodroneeurope.com) with human-in-the-loop review at three critical stages: news approval, content review, and social media validation. The system automates content generation from RSS feeds through to multi-platform social media distribution while maintaining editorial control.

Key Changes

  • Streamlit UI (content_factory.py): Standalone interface for generating SEO-optimized content with multi-agent AI coordination (Researcher → SEO Writer → Editor)

  • FastAPI v2 Server (content_factory_api.py): Production-ready REST API with 8-step pipeline:

    1. RSS news fetching from 28 sources
    2. Human news review queue
    3. AI content generation (blog posts, landing pages, case studies, FAQs)
    4. Human content review queue
    5. DALL-E 3 image generation
    6. Social media pack creation (LinkedIn, Instagram, Facebook, TikTok)
    7. Human social media review queue
    8. Platform publishing
  • News Fetcher (news_fetcher.py): Aggregates 28 RSS feeds across German agriculture, drone regulation, and EU policy; AI topic planner suggests content ideas from current news

  • Review Queue System (review_queue.py): SQLite-backed persistent queues for news, content, and social media with approval/rejection workflow

  • Media Generator (media_generator.py):

    • DALL-E 3 image generation (horizontal for web, vertical for social)
    • OpenAI TTS voiceover with 6 voice options
    • ffmpeg-based vertical video assembly (9:16 MP4)
  • RSS Feed Configuration (rss_feeds.py): 28 curated German-language feeds covering crop protection, seeding, NDVI monitoring, drone regulation, and EU policy

  • n8n Integration: Ready-to-import workflow with form-based human review steps, cron scheduling, and platform-specific publishing nodes

  • Comprehensive Documentation (README.md): Full pipeline overview, API reference, curl examples, and n8n setup instructions

Notable Implementation Details

  • Multi-agent coordination: Researcher gathers sources → SEO Writer creates content → Editor reviews for brand consistency and SEO optimization
  • Persistent state: SQLite queues survive server restarts; all review decisions are logged
  • Flexible API keys: Support for environment variables or per-request API keys
  • Optional media generation: Image and video generation are non-blocking; content generation succeeds even if media fails
  • Language support: German and English content generation with locale-aware instructions
  • n8n-ready: API designed for webhook integration with form-based human review flows

https://claude.ai/code/session_01DXMU871gHRQy4H67W2rpP4


🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/Shubhamsaboo/awesome-llm-apps/pull/478 **Author:** [@ponomarevs123](https://github.com/ponomarevs123) **Created:** 2/8/2026 **Status:** ❌ Closed **Base:** `main` ← **Head:** `claude/create-content-factory-k9pkp` --- ### 📝 Commits (4) - [`623558a`](https://github.com/Shubhamsaboo/awesome-llm-apps/commit/623558a2e12929feffa58ff200ffa6930734cd12) Add AI Content Factory for AgroDrone Europe - [`51371a4`](https://github.com/Shubhamsaboo/awesome-llm-apps/commit/51371a4a5f307181c8042371031e6e3ca3c80d19) Add FastAPI version and n8n workflow for content factory - [`da930d3`](https://github.com/Shubhamsaboo/awesome-llm-apps/commit/da930d329515c2b3019e53c12a91e6867bcc9f8e) Add RSS news feeds and AI topic planner for autonomous content pipeline - [`82d40c9`](https://github.com/Shubhamsaboo/awesome-llm-apps/commit/82d40c98b40a962a903c01a89fb16144e5c200e3) Add human-in-the-loop review, image generation, and social media pipeline ### 📊 Changes **9 files changed** (+2320 additions, -0 deletions) <details> <summary>View changed files</summary> ➕ `advanced_ai_agents/single_agent_apps/ai_content_factory/README.md` (+217 -0) ➕ `advanced_ai_agents/single_agent_apps/ai_content_factory/content_factory.py` (+173 -0) ➕ `advanced_ai_agents/single_agent_apps/ai_content_factory/content_factory_api.py` (+614 -0) ➕ `advanced_ai_agents/single_agent_apps/ai_content_factory/media_generator.py` (+283 -0) ➕ `advanced_ai_agents/single_agent_apps/ai_content_factory/n8n_workflow_example.json` (+280 -0) ➕ `advanced_ai_agents/single_agent_apps/ai_content_factory/news_fetcher.py` (+176 -0) ➕ `advanced_ai_agents/single_agent_apps/ai_content_factory/requirements.txt` (+9 -0) ➕ `advanced_ai_agents/single_agent_apps/ai_content_factory/review_queue.py` (+318 -0) ➕ `advanced_ai_agents/single_agent_apps/ai_content_factory/rss_feeds.py` (+250 -0) </details> ### 📄 Description ## Summary This PR introduces a complete content production pipeline for AgroDrone Europe (agrodroneeurope.com) with human-in-the-loop review at three critical stages: news approval, content review, and social media validation. The system automates content generation from RSS feeds through to multi-platform social media distribution while maintaining editorial control. ## Key Changes - **Streamlit UI** (`content_factory.py`): Standalone interface for generating SEO-optimized content with multi-agent AI coordination (Researcher → SEO Writer → Editor) - **FastAPI v2 Server** (`content_factory_api.py`): Production-ready REST API with 8-step pipeline: 1. RSS news fetching from 28 sources 2. Human news review queue 3. AI content generation (blog posts, landing pages, case studies, FAQs) 4. Human content review queue 5. DALL-E 3 image generation 6. Social media pack creation (LinkedIn, Instagram, Facebook, TikTok) 7. Human social media review queue 8. Platform publishing - **News Fetcher** (`news_fetcher.py`): Aggregates 28 RSS feeds across German agriculture, drone regulation, and EU policy; AI topic planner suggests content ideas from current news - **Review Queue System** (`review_queue.py`): SQLite-backed persistent queues for news, content, and social media with approval/rejection workflow - **Media Generator** (`media_generator.py`): - DALL-E 3 image generation (horizontal for web, vertical for social) - OpenAI TTS voiceover with 6 voice options - ffmpeg-based vertical video assembly (9:16 MP4) - **RSS Feed Configuration** (`rss_feeds.py`): 28 curated German-language feeds covering crop protection, seeding, NDVI monitoring, drone regulation, and EU policy - **n8n Integration**: Ready-to-import workflow with form-based human review steps, cron scheduling, and platform-specific publishing nodes - **Comprehensive Documentation** (`README.md`): Full pipeline overview, API reference, curl examples, and n8n setup instructions ## Notable Implementation Details - **Multi-agent coordination**: Researcher gathers sources → SEO Writer creates content → Editor reviews for brand consistency and SEO optimization - **Persistent state**: SQLite queues survive server restarts; all review decisions are logged - **Flexible API keys**: Support for environment variables or per-request API keys - **Optional media generation**: Image and video generation are non-blocking; content generation succeeds even if media fails - **Language support**: German and English content generation with locale-aware instructions - **n8n-ready**: API designed for webhook integration with form-based human review flows https://claude.ai/code/session_01DXMU871gHRQy4H67W2rpP4 --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
GiteaMirror added the pull-request label 2026-05-31 14:18:07 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/awesome-llm-apps#6798