
Curated by n8n Markets team
Last updated: March 8, 2026
# 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") - `row_number` β Auto-generated row identifier ## π οΈ How to set up 1. Create your Google Sheets calendar: - Set up columns as specified above - Use status "Listo para postear" for scheduled posts - Format dates as "DD de Mes a las HH am/pm" (Spanish format) 2. Upload videos to Google Drive: - Get shareable download links (format: `https://drive.google.com/uc?export=download&id=FILE_ID`) - Ensure videos meet platform requirements (duration, format, size) 3. Configure UploadPost API: - Create account and get API credentials - Connect your Instagram, LinkedIn, and TikTok accounts - Add credentials to the "Upload a video" node 4. Set up Google Sheets credentials: - Connect OAuth2 for both read and update operations - Update `documentId` with your spreadsheet ID - Verify sheet name matches (default: "Video") 5. Configure Telegram notifications: - Create a Telegram bot via @BotFather - Get your chat ID - Add credentials to "Send a text message" node 6. Customize posting times: - Modify Schedule Trigger hours (default: 9 AM and 9 PM) - Times are in Santiago, Chile timezone (America/Santiago) 7. Test the workflow: - Create a test entry with current time - Run manually to verify all connections work - Check Telegram for success notification 8. Activate the workflow β ## π¨ How to customize - Change posting schedule: Modify `triggerAtHour` values in Schedule Trigger (add more times if needed) - Add more platforms: Extend the `platform` array in "Upload a video" node (supports YouTube, Facebook, Twitter) - Customize notification format: Edit the Telegram message template to include/exclude information - Change timezone: Modify the `timeZone` parameter in the Code node (default: "America/Santiago") - Filter by platform: Add a filter node before upload to post only to specific platforms on certain days - Add approval workflow: Insert an approval step before posting using Telegram or Slack - Multiple accounts per platform: Modify "Social Media Account IDs" node to specify different account IDs - Error handling: Add error notification paths to alert you if uploads fail - Batch posting: Remove `returnFirstMatch` option to post multiple videos at once ## π‘ Pro Tips - Time format must match exactly between Schedule Trigger and Google Sheets for the workflow to trigger - Videos should be optimized for each platform before upload (aspect ratio, length, file size) - Test with a private account first before going live - Keep video files under 100MB for best performance across platforms - Use the `row_number` column to track and update specific posts - The workflow runs twice daily, so schedule posts accordingly (9 AM or 9 PM slots) ## β οΈ Important Notes - Posts marked as "Posteado" won't be processed again (prevents duplicates) - Video must be publicly accessible from the Google Drive link - UploadPost
n8n instance (self-hosted or cloud). credentials.
1. Download the workflow JSON 2. Import into your n8n instance 3. Configure credentials for 4. Activate and enjoy automation
Included in Builder Pro β $19/mo, 4,177 premium workflows
Templates are reviewed before they are listed. Test with your own credentials and data before running it in production.
100% Secure Checkout
Refund requests within 7 days of a new subscription
β οΈ 2 services require credentials. Make sure you have accounts set up before importing.
0 reviews
No reviews yet.
Log in to ask a question.
No questions yet. Be the first to ask!