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. An n8n automation workflow template by Kurt Bijl.

Community Metrics

Categories

• Automation
• AI

Tags

• n8n
• workflow
• airtable
• google-drive
• ai-agent
• structured-output-parser
• google-gemini-chat-model

Capabilities

• 5 nodes
• 4 views

Information