Generate Social Media Content from Video Transcripts with Gemini AI & Airtable

Description

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