Generate social media content from video transcripts with Gemini AI & Airtable

🎬 Social Media Content Generator

Workflow Overview Automated social media content creation from video transcripts

🎯 Trigger: Airtable Webhook - Action: Receives webhook from Airtable automation - Data: RecordId and action type (e.g., "post-ig") - Purpose: Starts the content generation pipeline

📊 Step 1: Fetch Record - Node: Airtable (Get Record) - Action: Retrieves full record data using RecordId - Data: Name, transcript, and other fields

📁 Step 2: Create Google Drive Folder - Node: Google Drive (Create Folder) - Action: Creates blue folder in /tutorials directory - Name: Uses record Name field - Updates: Stores folder ID back to Airtable

🤖 Step 3: AI Content Analysis - Node: AI Agent with Google Gemini 2.5 Flash - Input: Video transcript from Airtable - Structured Output: JSON with all social formats: - YouTube title & description - YouTube thumbnail text - Twitter thread (array) - LinkedIn post - Instagram caption - TikTok caption - YouTube Shorts caption - Relevant tags

💾 Step 4: Save Transcript File - Node: Google Drive (Create from Text) - Action: Saves transcript as text file - Location: Inside the created folder - Name: Uses record Name field

📋 Step 5: Update Airtable Results - Node: Airtable (Update Record) - Data: All AI-generated social media content - Special: Twitter thread array joined with newlines