Build Fully Automated Multi-Channel YouTube Ambient Content Pipeline

Job Description I’m looking for an experienced Zapier automation expert to complete and fix a partially built (≈40%) autonomous YouTube content system. The system generates and publishes ambient music videos automatically across 10 different YouTube channels, each with a unique musical identity. 🎯 Final Goal (Must Be 100% Autonomous) After initial setup, the system must run with zero manual intervention. Publish 2 videos per week (Tuesday & Friday at 7:00 PM UTC) Generate 16 videos per month: 8 long-form videos 8 YouTube Shorts Each video has a random duration: 3h / 5h / 8h / 12h / 18h Monthly approval workflow: Videos upload as Unlisted Reviewed once per month Then manually switched to Public CRITICAL RULE (Anti-Duplication) Within the same channel, the same “environment” must NOT repeat for 50–70 consecutive publications This is mandatory to avoid YouTube duplicate-content flags ⚙️ Current Zap Status (Blocking Issues) Step 1 — Schedule Trigger ✅ Working Tuesdays & Fridays at 7:00 PM UTC No changes needed Step 2 — Zapier Tables (Find Record) ❌ Error: “Please set up the required fields” Missing filter configuration: field_data_key field_0_operator field_0_value Table ID: 01KECN6G1QD05XRJ2XFPHWHKB5 I will provide the table schema / columns Step 3 — ChatGPT Brief Generation ❌ Error: Authentication expired (Auth ID: 61189999) Must reconnect ChatGPT Prompt references a non-existent field Entire prompt must be replaced with my final master prompt Fix field mapping from Step 2 Step 4 — MusicGPT ⚠️ Auth connected, but no configuration Must map ChatGPT → MusicGPT Duration: 25–30 min Seamless / imperceptible loop Must test successfully Steps 5–9 — Missing Authentications & Configuration ❌ No accounts connected, no fields mapped Accounts to connect: Step 5: Runway (Video AI) Step 6: Creatomate Step 7: YouTube (Long-form) Step 8: YouTube (Shorts — same account) Step 9: Gmail 🔧 Required Field Mapping & Configuration Step 4 — MusicGPT Input: ChatGPT “Music Prompt” Duration: 25–30 min Loop: seamless Output: Audio file URL Step 5 — Runway Video AI Input: ChatGPT “Video Prompt” Duration: 25–30 min Continuous motion Output: Video file URL Step 6 — Creatomate (Compositing) Inputs: MusicGPT audio Runway video Loop audio & video to final duration (3h / 5h / 8h / 12h / 18h) Generate: Final long-form MP4 Thumbnail image Shorts clip (60s, 9:16) Output: Final MP4 Shorts MP4 Thumbnail image Step 7 — YouTube Upload (Long-Form) Video: Creatomate MP4 Title: ChatGPT Title Description: ChatGPT Description Tags: ChatGPT SEO Tags Thumbnail: Creatomate thumbnail Category: Music (10) Privacy: Unlisted Upload to correct channel (from Step 2) Step 8 — YouTube Upload (Shorts) Video: 60s vertical clip (9:16) Same title, description, tags Privacy: Unlisted Upload to same channel ⚠️ Question to resolve: Should Step 8 remain as a separate upload (Long + Shorts)? My intent is YES, unless you strongly recommend otherwise based on best practices. Step 9 — Gmail Notification Subject: [Channel Name] New Video | PENDING APPROVAL Body must include: Video title Environment Duration Mood Link to YouTube video Approval context (monthly review)