Generate Social Media Content from Video Transcripts with Gemini AI & Airtable
Go to Workflow
Kurt Bijl
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.
This workflow was created by Kurt Bijl and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.