Kurt Bijl
Workflows by Kurt Bijl
Multi-platform social media publisher with Airtable, Google Drive, and Postiz
## 📝 POSTIZ MEDIA UPLOAD WORKFLOW ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎯 PURPOSE: Automated media upload pipeline that downloads videos and images from Google Drive and uploads them to Postiz storage for social media posting. 🔄 WORKFLOW PROCESS: 1. Webhook triggers the workflow 2. Fetch media metadata from Airtable 3. Download video + image from Google Drive 4. Upload both files to Postiz storage 5. Save Postiz file paths back to Airtable 🔧 TECHNICAL DETAILS: • API: Postiz /upload endpoint (multipart-form-data) • Storage: Converts Google Drive files → Postiz URLs • Integration: Updates Airtable with Postiz paths • Required: All media must be uploaded before posting ## 📱 SOCIAL MEDIA POSTING WORKFLOW ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎯 PURPOSE: Automated multi-platform social media posting using Postiz API. Distributes content across Instagram, Twitter/X (2 accounts), LinkedIn, and Facebook with platform-specific content cleaning and formatting. 🔄 COMPLETE WORKFLOW PROCESS: 1. 📊 Fetch social media content from Airtable database 2. 🔗 Get integration IDs for all connected social platforms 3. 🔀 Route each platform to appropriate content processor 4. 🧹 Clean content to prevent JSON formatting errors 5. 📱 Post to respective social media platforms simultaneously 📋 PLATFORM COVERAGE: • 📸 Instagram (Visual content + captions) • 🐦 Twitter/X Main Account (Text + images) • 🐦 Twitter/X Alt Account (Duplicate posting) • 💼 LinkedIn (Professional content) • 📘 Facebook (Meta ecosystem posting) ⚠️ CRITICAL CONTENT CLEANING: • Removes line breaks (\n), carriage returns (\r), tabs (\t) • Replaces multiple spaces with single spaces • Prevents 'JSON parameter needs to be valid JSON' errors • ESSENTIAL: Without cleaning, all API calls fail! 🔧 TECHNICAL SPECIFICATIONS: • API: Postiz /posts endpoint (POST) • Authentication: HTTP Header Auth • Content-Type: application/json • Posting Type: Immediate ('now') + 1 minute delay • Media: References pre-uploaded Postiz image paths • Rate Limit: 30 requests/hour (API beta limitation) 🔗 DATA SOURCES: • Content: Airtable • Media: Pre-uploaded via separate media upload workflow • Fields: instagram_caption, linkedin_post, twitter single, faceboook • Images: References 'postiz image' field paths ⚡ EXECUTION FLOW: Airtable → Integrations → Platform Router → Content Cleaners → Social Publishers 🚨 TROUBLESHOOTING: • JSON Errors: Check content cleaning nodes • 500 Errors: Verify integration IDs and account connections • Missing Media: Ensure media upload workflow ran first • Rate Limits: Space out executions (30/hour limit) 🔄 DEPENDENCIES: • Requires: Media upload workflow (for image/video paths) • Connects to: Analytics and monitoring workflows • Updates: Airtable with posting status and URLs ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ⚠️ CRITICAL NOTES: • Cannot use external URLs in Postiz posts • Files must be uploaded to google drive first - id referenced in airtable • Enables reference tracking for all platforms 📊 DATA FLOW: Google Drive → Download → Postiz Upload → Airtable Update 🔗 CONNECTS TO: Main social media posting workflows that reference these uploaded file paths for Instagram, Twitter, LinkedIn, Facebook, and YouTube posting. ## 🎬 VIDEO POSTING WORKFLOW ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎯 PURPOSE: Automated video content distribution across Instagram, Facebook, and YouTube using Postiz API. Specialized workflow for video content with platform-specific processing and cleaning. 🔄 WORKFLOW EXECUTION: 1. 📊 Fetch video content from Airtable database (recuoYjg4icStHsMK) 2. 🔗 Get integration IDs for video-enabled platforms 3. 🔀 Route platforms to appropriate video processors 4. 🧹 Clean content for Instagram & Facebook (YouTube bypassed) 5. 📹 Publish to video platforms simultaneously 📹 PLATFORM COVERAGE: • 📱 Instagram: Video posts & Reels (✅ Working) • 📘 Facebook: Video content (⚠️ Test mode) • 🎬 YouTube: Long-form videos (🚨 Broken) ⚡ EXECUTION FLOW: Airtable → Integrations → Video Router → [3 Parallel Paths] ├── Instagram: Cleaner → Publisher ├── Facebook: Cleaner → Publisher └── YouTube: [Direct] → Publisher 🗄️ DATA SOURCE: • Base: Netkreatives.com • Table: Youtube tool • Video Field: 'postiz video' • Content Fields: instagram_caption, faceboook 🔧 TECHNICAL SPECS: • Method: POST • Auth: HTTP Header (Postiz credentials) • Timing: Immediate posting (+1 minute delay) • Media: Pre-uploaded video paths • Content-Type: application/json
Generate social media content from video transcripts with Gemini AI & Airtable
# 🎬 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.