Post TikTok, YouTube Shorts and Instagram Reels with Airtable, OpenAI and Google

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.