🎬 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.