🎬 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 --- 🎯 Result: Complete social media content suite ready for multi-platform publishing, organized in Google Drive with all data stored in Airtable.
