Faceless Video AI Automation with Google Sheets and PiAPI

This workflow is for content creators or marketers who want to quickly create short, faceless videos for social media. It is perfect for those who need to generate many videos without showing faces and use AI to create varied content. This workflow automates faceless video creation from a Google Sheet. It uses AI to generate scene concepts, image prompts, video prompts, and captions. It then creates images, videos, and sound, merges them, and builds a complete video. Finally, it records the video link back into the Google Sheet. 1. Google Sheets: Prepare a Google Sheet with video ideas, styles, and "pending" status. 2. AI Credentials: Set up API keys for OpenAI (or compatible LLM), PiAPI (Flux for images, Kling for videos), ElevenLabs (audio), and Creatomate (video editing). 3. Google Drive: Create a Google Drive folder for audio uploads. 4. Creatomate Template: Design a Creatomate template with placeholders for video clips, audio tracks, and text captions. Active accounts and API keys for: Google Sheets, OpenAI (or compatible LLM), PiAPI (for image and video generation), ElevenLabs (for audio generation), and Creatomate (for video assembly). A Google Drive account is also needed. You can customize the initial video ideas, styles, and number of scenes in the Google Sheet. You can also adjust the AI prompts for scene generation, image generation, video motion, and captions. Change the AI models used (e.g., different OpenAI models, other image/video generation APIs). You have full control over the Creatomate video template to change layouts, fonts, and effects. Key Technologies: n8n,Google Sheets,OpenAI (GPT-4.1),PiAPI (Flux, Kling),ElevenLabs,Creatomate,Google Drive Automation Value: Automates the entire video creation process from idea to final video. Saves significant time in content production for social media or similar needs. Eliminates manual effort in generating prompts, images, videos, and audio. Allows for rapid scaling of video content generation. Reduces costs associated with manual content creation or expensive stock media subscriptions by using AI. Ensures consistency in video style and branding through templated generation.