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)