Templates / Create & publish affiliate product videos with Sora-2, GPT & YouTube

Create & publish affiliate product videos with Sora-2, GPT & YouTube

Needs changes

by Amjid Ali βœ“ Β· 576 views Β· created 2025-10-31 Β· Content Creation, Multimodal AI

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What to replace before upgrading

Removed in 3.0Replace with
AI Agent v1 (old agent modes)
Sora2 Prompt Generator (v1.8), AI Agent for Meta Data of Youtube (v1.8)
Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Nodes used (14)

Google SheetsOpenAI Chat ModelAI AgentYouTubeStructured Output ParserTelegram

What it does

πŸš€ Affiliate AI-Powered Video Funnel Fully Automated Product Video Creation & Publishing Turn your affiliate links or product catalog into a 24/7 AI video marketing machine. This n8n workflow auto-creates human-presenter promo videos using AI and publishes them directly to YouTube with SEO β€” completely hands-free. βœ… --- 🎯 What This Automation Does πŸ”„ Fetches product or affiliate data from Google Sheets / Airtable / Database πŸŽ™οΈ Generates human-presenter video prompts (Sora-style) using AI Agents 🎬 Renders promotional videos automatically via AI video generation ⏳ Polls render completion & handles errors safely πŸ“€ Uploads videos to YouTube (draft, unlisted, or public) 🧠 Auto-generates SEO metadata (titles, descriptions, tags, hashtags) βœ… Human approval flow before public publishing πŸ“ Updates catalog status to prevent duplicates ⏱️ Runs daily, weekly, or per request via form or trigger This workflow eliminates all repetitive editing, uploading, and SEO work β€” your channel grows while you sleep. πŸ˜΄πŸ“ˆ --- πŸ§‘β€πŸ« Step-by-Step Video Tutorial πŸŽ₯ Complete Implementation Demo πŸ‘‰ https://youtu.be/pOxcVbYdr0w πŸ“Œ Covers full setup, rendering, approval, publishing, and automation scheduling. --- 🌐 Useful Links πŸ› οΈ n8n Hosting / Setup Support: https://syncbricks.com πŸ“š YouTube Data API Docs: https://developers.google.com/youtube/v3 πŸ€– Kai / AI Render Service: (any Sora-style provider you choose) 🧠 AI Prompt Docs (OpenAI etc.): https://platform.openai.com/docs/api-reference --- πŸ›  Prerequisites βœ… n8n (Self-Hosted or Cloud) βœ… AI Agent inside n8n configured βœ… YouTube API credentials βœ… Product/Affiliate data source: Google Sheets OR Airtable OR Database βœ… AI Video Rendering: Sora-style provider API πŸ“ Recommended product fields: > Title, Summary, Brand, Landing Page, Affiliate Link (if using monetization) --- πŸ“‹ How This Workflow Works β€” Step by Step 1️⃣ Product Input & Filtering Fetch unpublished product/item Skip rows marked β€œPublished” or with error codes Ideal for drip publishing content every day 2️⃣ AI Promo Script + Presenter Prompt Converts product benefits β†’ human script Adds overlays + camera movement + style cues Presenter looks professional, friendly & trusted 3️⃣ AI Video Rendering Send prompt, wait for result Retry & timeout safety built-in 4️⃣ YouTube Upload Uploads automatically as Unlisted βœ… Sends Human-In-The-Loop (HITL) approval After approval β†’ Public Publish 5️⃣ SEO Enhancement Generates tags, hashtags & optimized titles Inserts affiliate link into description Updates video via YouTube API 6️⃣ Mark As Published Saves record in sheet/db Avoids duplicate publishing --- πŸ’° Affiliate / Monetization Features πŸ›’ Add PartnerStack / Amazon Associates links πŸ”— Auto-insert affiliate URLs per product 🧩 Optional dynamic UTM tracking πŸ“ˆ Ready for performance dashboards (CTR, views) You create zero videos, yet grow daily affiliate revenue. πŸ”₯ --- πŸ’‘ Advanced Customizations | Idea | Benefit | | ------------------------------- | ------------------------------- | | Multi-platform publishing | Expand reach beyond YouTube | | Multi-language voice & captions | Increase global audience | | Category-based styles | Better storytelling per product | | Bulk overnight generation | Boost weekly content output | | Analytics integration | Track growth & ROI easily | --- ⚠️ Troubleshooting | Issue | Fix | | ----------------- | ------------------------------ | | No video returned | Check AI render provider quota | | Upload fails | Verify YouTube OAuth scopes | | Duplicate uploads | Confirm Published tag update | | Video quality | Adjust prompt style profile | --- πŸ™Œ Why This Template You can scale affiliate & product-based video content without editing tools, creators, or extra headcount: βœ… Saves hours per video βœ… Builds traffic and trust automatically βœ… Generates recurring affiliate income βœ… Turns your product list into a money-making content engine --- πŸš€ Get Started in Minutes Import the workflow β†’ Connect APIs β†’ Approve β†’ Publish β†’ Earn πŸ’Έ οΏ½

View the original on n8n.io β†’ Check your own copy

Get the weekly β€œwhat broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.