Bulk auto-publish videos to social networks with AI copy and client approval

This workflow automates batch video publishing prep from a Google Drive folder with AI-generated, platform-specific copy and a simple approval queue in Google Sheets. Perfect for Agencies, content creators or Teams


---

What This Workflow Does

1. Fetches videos from a Google Drive folder You provide a folder ID and the workflow lists all files, filtering to keep only .mp4.

2. Builds a simple publishing calendar You configure: - Start date - Cadence (daily, 5/week, 3/week) - Timezone - One Publish Hour shared across all selected platforms

The workflow creates: - Schedule Date - Schedule DateTime for each video

3. Analyzes each video with AI Gemini performs a structured analysis of the video to understand: - What happens in the content - Key topics - Tone - Audience intent