Create & approve POV videos with AI, ElevenLabs & multi-posting (TikTok/IG/YT)

POV Video Creator: Automating TikTok-Style Instagram Video Automation, Approval, and Multi-Platform Posting Using AI, ElevenLabs, Google Sheets, and Social Media APIs Description What Problem Does This Solve? 🎥 This workflow automates the creation, rendering, approval, and posting of TikTok-style POV (Point of View) videos to Instagram, with cross-posting to Facebook and YouTube. It eliminates manual video production, approval delays, and inconsistent posting schedules. It ensures high-quality content creation and distribution for social media managers and content creators Target audience: Social media managers, content creators, small to medium-sized businesses, and n8n users familiar with AI tools, Google Sheets, and social media APIs What Does It Do? 🌟 - Generates daily POV video ideas using OpenAI - Creates images, videos, and audio with PIAPI.ai and ElevenLabs - Renders final videos with Creatomate - Manages approvals via email and Google Sheets - Posts approved videos to Instagram, Facebook, and YouTube - Tracks progress in a Google Sheet for transparency Key Features - AI-driven idea generation and script creation - Automated media production with image, video, and audio synthesis - Email-based approval system for quality control - Cross-platform posting to Instagram, Facebook, and YouTube - Real-time tracking in Google Sheets and Google Drive - Error handling for rendering and posting failures Setup Instructions Prerequisites - n8n Instance: Self-hosted or cloud n8n instance - API Credentials: - OpenAI API: API key for idea generation, stored in n8n credentials - PIAPI.ai API: API key for image and video generation, stored in n8n credentials - ElevenLabs API: API key for audio generation, stored in n8n credentials - Creatomate API: API key for video rendering, stored in n8n credentials - Google Sheets/Drive API: OAuth2 credentials from Google Cloud Console with Sheets and Drive scopes - Gmail API: OAuth2 credentials from Google Cloud Console with Gmail scope - Instagram Graph API: User Access Token with instagramcontentpublish permission from a Facebook App - Facebook Graph API: Access Token from the same Facebook App - YouTube API: OAuth2 credentials for YouTube uploads - Google Sheet: A sheet named "POV Videos" with a tab "Instagram" and columns: Timestamp, ID, Subject, Topic, Caption, POVStatus, Prompt, PublishStatus, Link, Final Video, Approval, rownumber - Creatomate Template: A pre-configured template with video, audio, and text elements Installation Steps 1. Import the Workflow: - Copy the workflow JSON from the “Template Code” section (to be provided) - Import it into n8n via “Import from File” or “Import from URL” 2. Configure Credentials: - Add API credentials in n8n’s Credentials section for OpenAI, PIAPI.ai, ElevenLabs, Creatomate, Google Sheets/Drive, Gmail, Instagram Graph, Facebook Graph, and YouTube - Assign credentials to respective nodes. For example: - In "Text-to-Image", use PIAPI.ai credentials: {{ $credentials.PIAPI }} - In "Render with Creatomate", use Creatomate credentials: {{ $credentials.Creatomate }} - In "Send Approval Request", use Gmail credentials 3. Set Up Nodes: - Schedule Trigger: Configure to run daily - Approval Email (Send Approval Request): Customize the HTML email template with approval/rejection links - Post to Social Media Nodes (Instagram Container, Facebook Posts, Post YouTube): Configure with your Instagram Business Account ID, Facebook Page ID, and YouTube channel details 4. Configure Google Sheet and Drive: - Create "POV Videos" Google Sheet with "Instagram" tab and specified columns - Share the sheet with your Google Sheets credential email - Create "Audio" and "Video" folders in Google Drive, noting their IDs 5. Test the Workflow: - Run manually to verify idea generation, media creation, and posting - Check email notifications, Google Sheet updates, and social media posts 6. Schedule the Workflow: - Enable "Schedule Trigger" and "Schedule Trigger1" for daily runs - Enable "Get Latest Approved Video" to poll at 7 PM daily How It Works High-Level Steps 1. Generate Video Ideas: Creates daily POV video concepts with OpenAI 2. Create Media: Produces images, videos, and audio using AI tools 3. Render Video: Combines media into a final video with Creatomate 4. Manage Approvals: Sends approval emails and processes decisions 5. Post to Platforms: Publishes approved videos to Instagram, Facebook, and YouTube Detailed Descriptions Detailed node descriptions are available in the sticky notes within the workflow (to be provided). Below is a summary of key actions Node Names and Actions Video Idea Generation and Script Creation - Schedule Trigger: Initiates daily workflow - Get Title: Fetches pending video ideas from Google Sheet - Generate Topics: Uses OpenAI to create a new video idea - Format Row: Structures the idea into a Google Sheet row - Insert new Prompt, Caption and Title/Topic: Adds the idea to Google Sheet - Generate Ideas: Produces 3 POV sequences - Generate Script: Expands a sequence into a detailed script - Set Topics: Stores the script for media creation Media Creation - Text-to-Image: Generates an image with PIAPI.ai - Get Image: Retrieves the generated image - Generate Video Prompt: Creates a video prompt from the image - Generate Video: Produces a 5-second video with PIAPI.ai - Access Videos: Retrieves the video URL - Store Video: Updates Google Sheet with video URL - Generate Sound Prompt: Creates an audio prompt - Text-to-Sound: Generates a 20-second audio clip with ElevenLabs - Store Sound: Uploads audio to Google Drive - Allow Access: Sets audio file permissions Video Rendering - Merge: Combines script, video, and audio data - List Elements: Formats data for Creatomate - Render with Creatomate: Renders the final video - Check Video Status: Routes based on render success/failure Storage and Notification - Google Drive: Uploads the rendered video - New Render Video Alert: Sends success email - Failed Render: Sends failure email - Render Video Link: Updates Google Sheet with final video URL Approval Process - Approval Email: Sends approval request email - Handle Approval/Rejection1: Processes approval/rejection via webhook - Video Update1: Updates Google Sheet with approval status Social Media Posting - Get Latest Approved Video: Polls for approved videos - Check Approval: Routes based on approval status - Instagram Container: Creates Instagram media container - Post to Instagram: Publishes to Instagram - Facebook Posts: Posts to Facebook - Download Video: Downloads video for YouTube - Post YouTube: Uploads to YouTube - Mark Rejected: Updates status for rejected videos - Update Google Sheet: Updates publish status Customization Tips - Expand Platforms: Add nodes to post to other platforms - Modify Approval Email: Update the Send Approval Request node to customize the HTML template - Alternative Notifications: Add nodes for Slack or Telegram alerts - Adjust Video Duration: Modify Generate Video node to change duration (default: 5 seconds)