Create & publish affiliate product videos with Sora-2, GPT & YouTube
Needs changesNeeds 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.0 | Replace 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)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Limit
n8n-nodes-base.limit - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Edit Fields (Set)
n8n-nodes-base.set - Filter
n8n-nodes-base.filter - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - Wait
n8n-nodes-base.wait - YouTube
n8n-nodes-base.youTube - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Telegram
n8n-nodes-base.telegram
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 πΈ οΏ½