Quick Overview
This workflow runs on a schedule, pulls the next publish-ready video from Airtable, uses OpenAI, Google Gemini, and CloudConvert to generate a transcript, title, description, tags, and hashtags, then uploads to YouTube Shorts, posts an Instagram Reel via Meta Graph API, and queues TikTok publishing via Google Sheets.
How it works
- Runs on a schedule (or manually) and waits a random number of minutes to stagger posting.
- Searches Airtable for content marked Publish = true and Status = “In Publish Queue”, then selects a single record to process.
- Downloads the video, converts it to MP3 with CloudConvert, and transcribes the audio with OpenAI.
- Uses OpenAI and Google Gemini to extract a main keyword, generate a YouTube-optimized title, and create YouTube tags, hashtags, and a full YouTube description, then derives a shorter content-only caption for Instagram/TikTok.
- Uploads the video to tmpfiles.org to generate a direct file URL and updates the Airtable record with the generated metadata and set Status = “Published”.
- Uploads the video to YouTube with the generated title, description, and tags.
- Creates and publishes an Instagram Reel via the Meta (Facebook) Graph API after a short wait to allow media processing.
- Appends the Airtable Record ID to a Google Sheet used to trigger TikTok posting via an external automation.
Setup
- Create an Airtable base/table with the required fields (including File attachment, Publish, Status, and caption/tag fields) and add an Airtable personal access token in n8n.
- Add OpenAI API credentials and ensure the workflow’s prompts/models match the models available in your account.
- Add a CloudConvert OAuth2 connection for video-to-MP3 conversion.
- Add a Meta (Facebook) Graph API credential with permissions for Instagram Reels publishing and set the correct Instagram account node ID.
- Add YouTube OAuth2 credentials and confirm the target channel, category, region, and privacy settings.
- Add Google Sheets OAuth2 credentials and update the spreadsheet/document ID used to pass Record IDs to your TikTok/Zapier process.