Alexandru Burca
Automation consultant with 5+ years of experience helping Sales & Marketing teams streamline processes, reduce manual work, and improve efficiency using n8n and other workflow automation tools. I design custom automations, integrate multiple platforms, and optimize complex workflows for scalability and reliability.
Templates by Alexandru Burca
Generate news digest videos from WordPress to YouTube with Shotstack
Daily News Digest Video Generator for YouTube Shorts Instalations Instructions Youtube Instalation Instructions Overview This workflow automatically creates and publishes daily news digest videos from WordPress articles to YouTube. It runs every evening at 7 PM, compiling the day's top stories from a news portal into a professionally formatted vertical video (1080x1920px) optimized for social media platforms like YouTube Shorts. --- What It Does 🕐 Scheduled Trigger Runs automatically every day at 19:00 (7 PM) 📰 Fetches Today's Articles Retrieves all published WordPress posts from the current day ✅ Validates Content Ensures there are at least 3 articles before proceeding 🎬 Video Detection Scans article content HTML for embedded videos Extracts MP4 URLs from WordPress video players Parses wp-playlist-script JSON data Falls back to <video> and <source> tag detection 🧹 Data Processing Extracts article titles, links, and featured media IDs Decodes HTML entities: Converts &8211; to –, " to ", etc. Fetches featured images from WordPress Media API Assigns default images for articles without featured media Calculates reading time per article (3-7 seconds based on word count) Cleans text: Removes HTML tags and normalizes whitespace 🎥 Video Generation (via Shotstack API) Intro Slide (3 seconds) Black background Large logo (centered) Title on center Current date in DD-MM-YYYY format News Slides (3-7 seconds each) Each article is displayed with: Background: Video (if available) or featured image, cropped to fit Dark overlay: 40% opacity black layer for text readability Article headline: Large white text at top Small logo: Top-right corner Pagination counter: Bottom-right white badge (e.g., "1 / 22") CTA button: Centered CTA Background music: Subtle looped audio track Transitions: Smooth fade in/out between slides Outro Slide (3 seconds) Identical to intro slide Provides clean ending to the video ⏳ Processing Wait Waits 30 seconds for Shotstack to render the video Polls Shotstack API to verify video completion 📥 Download Video Retrieves the finished MP4 file from Shotstack Downloads video data for YouTube upload 📤 YouTube Upload Automatically uploads to YouTube with: Title: "Daily Digest - [Day] [Weekday], [Year]" Description: Same as title Category: News & Politics Made for kids: Yes Tags: dailydigest --- ✨ Key Features Intelligent Content Handling ✅ Automatic video/image detection and intelligent media selection ✅ Dynamic reading time calculation for optimal viewer engagement ✅ HTML entity cleaning for proper text display (WordPress compatibility) ✅ Fallback default images for articles without media ✅ Video background support with automatic muting Professional Video Production ✅ Vertical format optimized for mobile viewing (1080x1920px) ✅ Professional branding with logos and consistent styling ✅ Smooth fade transitions between slides ✅ Background music with looping support ✅ Dynamic pagination counters ✅ Call-to-action buttons for engagement Customization ✅ Centralized variables for easy branding updates ✅ Configurable logos, colors, and text ✅ Adjustable reading time calculation ✅ Flexible date formatting ✅ Customizable audio track 🎯 Use Cases Perfect for: 📰 News websites wanting to repurpose daily articles 📱 Media outlets creating social media content 🎥 Content creators automating video production 🔄 Publishers maximizing content distribution 📊 Marketing teams driving traffic from social platforms --- 🔧 Customization Options Easy Changes Update logos by changing logobig and logosmall URLs Modify branding colors via buttonbgcolor variable Adjust button text with button_text variable Change video title with dailydigesttext variable Update background music by replacing audio URL Advanced Customization Adjust reading time formula in calculateReadingTime() function Modify date format in getRomanianDate() function Change video dimensions (currently 1080x1920) Update font family and sizes Adjust overlay opacity and colors Modify transition effects --- 📋 Prerequisites Required Credentials WordPress API - Access your WordPress site Shotstack API - API key for video rendering (Stage environment) YouTube OAuth2 - Authenticated YouTube account for uploads
By Alexandru BurcaAI Telegram-to-WordPress publishing with GPT-4 & media handling
AI-powered automation that rewrites, enhances, and publishes Telegram RSS content directly to your WordPress news site, including image/video upload and category mapping. Who’s it for This workflow is designed for content creators, news publishers, and social media managers who share updates on Telegram and want to automatically republish them as formatted articles on WordPress. It’s ideal for news portals, agencies, or blogs that manage content across multiple channels. Features Multi-Channel Telegram RSS Monitoring Automatic Category Assignment Duplicate Prevention System (GUID Matching) Media Download + Type Detection (Image / Video) Full AI Article Rewriting (GPT-4O) -- Stage 1: Full rewrite with structure -- Stage 2: Context enhancement Media Handling Logic WordPress Publish How it works / What it does Fetches new posts from a Telegram channel feed (via RSS). Uses OpenAI to rewrite the text into a polished news-style article. Detects whether the content includes images or videos and downloads them. Uploads the media to WordPress and links it to the post. Automatically publishes the formatted article to WordPress with the correct category and excerpt. Set up steps Setup takes around 10–15 minutes. You’ll need API keys for OpenAI and WordPress Application Passwords. Add your Telegram RSS feed URL and WordPress site URL in the relevant nodes. (Optional) Adjust tone or rewrite style in the OpenAI node and category mapping in the Switch node. All configuration details are included in sticky notes inside the workflow. Requirements WordPress site with REST API access and Application Password OpenAI API key Telegram channels RSS URL How to customize the workflow You can easily adjust the writing style in the OpenAI node, change categories in the Switch node, or schedule how often the workflow checks Telegram for new posts.
By Alexandru Burca