LLM News Video Production: Scraping, Scripting, and Video Generation

This workflow automates personalized news video creation with AI avatars, replacing manual scripting, filming, and editing that take 4-6 hours per video for news teams. The Scheduled News Trigger Cron node runs 3x daily, the Session Initializer Set node starts tracking, the Session Tracker Postgres node logs sessions, the News Source Manager Postgres node selects sources, the News Content Scraper HTTP Request node fetches via Apify, the Content Quality Validator If node filters content, the News Script Writer LangChain Agent node generates scripts using OpenAI GPT-4.1-mini, the Script Quality Gate If node checks length, the Avatar Selector Postgres node picks profiles, the Avatar Video Generator HTTP Request node creates via HeyGen, the Initial Processing Wait Wait node pauses, the Video Status Checker HTTP Request node polls, the Completion Checker If node verifies, the Video URL Validator If node confirms download, the Video Downloader HTTP Request node retrieves, the Video Storage Google Drive node uploads, the Session Completion Tracker Postgres node updates, the Success Notifier Slack node alerts, and the Success Response Set node summarizes. Error paths (If/Set nodes) route to Error Logger Postgres, Error Notifier Slack, and Error Response Set. It aids newsrooms or corporate comms (10-40 staff) producing 90+ videos monthly, enabling consistent, branded content without crews, reducing costs and scaling for global audiences with multilingual avatars.\n\nThis workflow saves 12-18 hours weekly on 90 videos, cutting production costs by 80%. Use cases include daily briefings for enterprises, social recaps for media firms. Suitable for small teams. Requires OpenAI ($0.03/1k tokens), HeyGen ($0.10/minute), Apify ($49/month starter), Postgres (free self-host, $15/month cloud), Google Drive ($1.99/month), Slack (free). Scalable to 300 videos/month with Pro tiers.\n\nInstall n8n via n8n.io or cloud.n8n.io. For OpenAI, get key at platform.openai.com (enable billing). For HeyGen, sign up at heygen.com, get API key. For Apify, create account at apify.com, get token. Set up Postgres at supabase.com (free tier). Enable Google Drive API at console.cloud.google.com (OAuth). For Slack, create webhook at slack.com/apps. Set env vars: OPENAI_API_KEY, HEYGEN_API_KEY, APIFY_TOKEN, POSTGRES_URL, GOOGLE_DRIVE_CREDENTIALS. Import JSON; scheduled trigger—no webhook. Configure Postgres nodes with table names (news_video_sessions, news_sources, avatar_profiles, avatar_error_logs).\n\nTest manually: Run workflow, check Slack alert, Drive video. Verify Postgres logs. Errors: Invalid key (retry), low content (fallback). Activate Schedule Trigger. Monitor dashboard weekly. Optimize script length; refresh tokens quarterly.", "businessValue": "Saves 12-18 hours/week generating 90 news videos", "setupTime": "45-60 minutes", "difficulty": "Intermediate", "requirements": ["OpenAI API ($0.03/1k tokens)", "HeyGen API ($0.10/minute)", "Apify API ($49/month starter)", "n8n instance"], "useCase": "Automated AI avatar news video production"