Skip to main content

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

Workflow preview

Workflow preview
100%
Create & publish affiliate product videos with Sora-2, GPT & YouTube preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

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 ...

Best for

  • Content Creation automation workflows
  • Multimodal AI automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.stickynote, n8n-nodes-base.scheduletrigger, n8n-nodes-base.googlesheets, n8n-nodes-base.limit, @n8n/n8n-nodes-langchain.lmchatopenai, n8n-nodes-base.set, n8n-nodes-base.filter, n8n-nodes-base.httprequest

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Amjid Ali.

Original n8n.io source

1.1 Workflow description

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

πŸš€ 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


πŸ›  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 πŸ’Έ

πŸ‘‰ More AI + n8n Workflows & Support https://syncbricks.com

πŸ‘‰ Subscribe for Tutorials https://youtube.com/@syncbricks

πŸ‘‰ Connect with the creator (Amjid Ali) https://linkedin.com/in/amjidali


πŸ”– Knowledge Base Tags

ai_video_automation, affiliate_marketing, youtube_api, handsfree_automation, ecommerce_video_marketing, n8n_ai_agents, social_video_automation, product_video_generator, workflow_automation, marketing_scaling

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 2 - Sticky Note1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 3 - Sticky Note12

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 4 - Schedule Trigger

Type / Role
n8n-nodes-base.scheduleTrigger - scheduleTrigger
Config choices
Version 1.2

Block 5 - Sticky Note11

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 6 - Get row(s) in sheet

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 7 - Limit

Type / Role
n8n-nodes-base.limit - limit
Config choices
Version 1

Block 8 - OpenAI Chat Model1

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenAi - lmChatOpenAi
Config choices
Version 1.2

Block 9 - Get Product Details

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 10 - Partnership Active and Not Published

Type / Role
n8n-nodes-base.filter - filter
Config choices
Version 2.2

Block 11 - Get Product Details from Website

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 12 - Parse Product Data

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 13 - If

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.2

Block 14 - Update about Error

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 15 - Sora2 Prompt Generator

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 1.8

Block 16 - Text to Video2

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 17 - Wait4

Type / Role
n8n-nodes-base.wait - wait
Config choices
Version 1.1

Block 18 - Get Video4

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 19 - If4

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.2

Block 20 - Download Video

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 21 - Upload a video

Type / Role
n8n-nodes-base.youTube - youTube
Config choices
Version 1

Block 22 - Update Youtube Meta Data

Type / Role
n8n-nodes-base.youTube - youTube
Config choices
Version 1

Block 23 - Update row in sheet

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 24 - AI Agent for Meta Data of Youtube

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 1.8

Showing the first 24 of 34 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow Create & publish affiliate product videos with Sora-2, GPT & YouTube
Complexity advanced
Nodes 34
Categories Content Creation, Multimodal AI
Author Amjid Ali
Published 31 Oct 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/10372/10372.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Create & publish affiliate product videos with Sora-2, GPT & YouTube do?

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 ...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Content Creation, Multimodal AI use case.