Schedule & auto-post videos to Instagram, LinkedIn & TikTok with Google Sheets

Automated Social Media Video Posting

👥 Who's it for This workflow is perfect for content creators, social media managers, and businesses who want to schedule and automatically post videos 📹 to multiple platforms (Instagram, LinkedIn, TikTok) without manual effort. Save hours every week! ⏰

🤖 What it does It automatically reads scheduled posts from Google Sheets, checks if it's the right time to post, downloads videos from Google Drive, uploads them to multiple social media platforms simultaneously, updates the posting status, and sends you a Telegram notification with the results. Complete hands-free social media management! 🚀

⚙️ How it works

1. ⏰ Schedule Trigger – Runs twice daily at 9 AM and 9 PM 2. 📊 Google Sheets (Read) – Fetches posts with status "Listo para postear" (Ready to post) 3. ⚙️ Code Node – Converts trigger time to readable Spanish format (e.g., "16 de Octubre a las 9 am") 4. 🔍 If Condition – Checks if current time matches the scheduled post time in the sheet 5. 📝 Format Drive Content – Extracts and organizes post data (Title, Copy, Video URL) 6. 🆔 Social Media Account IDs – Prepares account identifiers (can be customized for specific accounts) 7. 🎬 Upload a video – Posts video simultaneously to Instagram, LinkedIn, and TikTok using UploadPost API 8. 📊 Google Sheets (Update) – Changes post status to "Posteado" (Posted) to avoid duplicates 9. 📱 Telegram Notification – Sends detailed success report with URLs for each platform

📋 Requirements

- Google Sheets with your content calendar - Google Drive to store your videos - UploadPost API account (supports Instagram, LinkedIn, TikTok): - Click aquí 👉 [UploadPost](https://www.upload-post.com) - Telegram Bot for notifications - n8n instance with required node packages

Google Sheets Structure Your spreadsheet should have these columns: - Title – Post title - Copy – Post caption/description - Video Link – Google Drive download URL - Status – Post status ("Listo para postear" or "Posteado") - Fecha.Hora – Scheduled time (format: "16 de Octubre a las 9 am") - rownumber – Auto-generated row identifier