LLM Google VEO3 Viral Video Idea Generation, Production, and Publishing

This workflow automates video content creation using Google VEO3, utilizing Schedule Trigger, AI Agent, HTTP Request, Google Sheets, Google Drive, and Email nodes. It generates viral video ideas, crafts cinematic prompts, produces videos, logs metrics, and sends notifications, perfect for social media automation. Install n8n from n8n.io for self-hosting or sign up at cloud.n8n.io for hosted setup. Create a Google Cloud account at console.cloud.google.com, enable Vertex AI API, and generate OAuth2 credentials for HTTP Request nodes ('VEO3 Generator', 'Video Fetcher'). Set up a Google Sheets document with OAuth2 credentials for Google Sheets nodes ('Production Logger', 'Completion Logger', 'Error Logger'). Configure a Google Drive account with OAuth2 credentials for the Google Drive node ('Drive Publisher'). Set up an SMTP server for the Email node ('Notification System'). In the Set node ('Security Configuration'), define environment variables: GOOGLE_PROJECT_ID, GOOGLE_ACCESS_TOKEN, GOOGLE_CLOUD_REGION, and GOOGLE_DRIVE_FOLDER_ID. Adjust the Schedule Trigger node’s cron expression (default: every 2 hours) via CONTENT_SCHEDULE_CRON. Test by manually running the workflow in n8n. Check Google Sheets ('Completion Logger') for production_status='completed', final_output URL, and processing_duration_minutes. Verify video uploads in Google Drive and success emails from the Email node. Missing GOOGLE_ACCESS_TOKEN causes a 401 error in HTTP Request nodes, logged in Google Sheets ('Error Logger'). Invalid prompts trigger failures in the Condition node ('Prompt Validator'). Deploy by activating the workflow, ensuring environment variables are set. Monitor Google Sheets for execution_id, idea, and video_parameters. If video data is corrupt, the Condition node ('Video Integrity Validator') routes to the Error Processor, logging details for debugging.