Multi-Platform Video Publishing with AI Content Generation and Airtable Tracking - n8n Workflow

• Content Creators and Marketing Teams needing to scale video distribution efficiently.


• Users looking for advanced n8n templates integrating AI content generation and CRM/tracking tools.


• Agencies that manage social media content for multiple clients.


• Anyone seeking to automate their social media posting pipeline using a low-code n8n workflow.

Managing video content across multiple social media platforms (Instagram, TikTok, YouTube) is time-consuming. This comprehensive n8n workflow solves this by fully automating the entire publishing pipeline—from file detection to tracking status. When a new video is uploaded to a designated Google Drive folder, the n8n trigger starts the process. The workflow leverages advanced AI capabilities via the OpenAI n8n node to transcribe the audio and generate highly engaging, platform-specific descriptions and titles. Finally, using a third-party posting service (upload-post.com) and meticulous tracking via Airtable, this n8n template ensures content is consistently published while maintaining a detailed record of success statuses and URLs for every post.

The entire process is initiated by the Google Drive Trigger n8n trigger when a new video file appears in the designated watched folder.

1. Video Retrieval and AI Analysis: The n8n workflow downloads the video, saves it temporarily, and immediately routes the file to the OpenAI n8n node. This node first extracts and transcribes the audio content of the video.


2. Content Generation: A subsequent OpenAI n8n node uses this transcription, along with a custom prompt, to generate an optimized description and title suitable for social media platforms (such as those used by influencersde examples provided in the configuration).


3. Initialization and Tracking: Essential variables (Airtable IDs) are set. An initial record is created in Airtable using the Airtable n8n node to start tracking the post. The AI-generated description and video metadata are immediately updated in this record.


4. Parallel Uploads: The video file is then read into separate binary data streams, allowing for simultaneous uploads. Three separate HTTP Request nodes use the upload-post.com API to upload the video content to TikTok, Instagram, and YouTube, respectively, using the AI-generated title.


5. Final Status Update: Each successful upload branch processes the response (including the final published URL and success status) and utilizes an Airtable n8n node to update the corresponding fields (TikTok Status, Instagram Status, YouTube Status) in the original Airtable record, completing the n8n workflow execution.


6. Error Notification (Optional): If a failure occurs, the n8n workflow sends an alert via Telegram (if configured).

To use this powerful n8n template, follow these setup steps:

1. Import the n8n workflow: Copy the provided JSON data and paste it into your n8n instance using the 'New' > 'Import from JSON' function.


2. Set Credentials: You will need credentials for:

1. Configure Variables: Update the Set Variables n8n node with your specific Airtable Application ID (airtableappid), Table ID (airtabletableid), and your upload-post service user ID (uploadpostuser).


2. Configure Google Drive Trigger: Select the specific folder in your Google Drive account that the n8n trigger should watch for new video uploads.


3. Airtable Base Setup: Ensure your Airtable base contains the necessary fields for tracking: Video Name, Google Drive Link, File ID, Instagram Status, TikTok Status, YouTube Status, Upload Date, and Description.

Google Drive Trigger: This acts as the starting n8n trigger, polling a specified Google Drive folder for newly created video files. It is the essential kickoff point for the automated n8n workflow.
OpenAI (Get Audio from Video): An specialized n8n node responsible for processing the video file binary data and using OpenAI's API to transcribe the spoken content, providing raw text for description generation.
OpenAI (Generate Description for Videos): This n8n node uses the transcribed audio and a sophisticated prompt (configured for gpt-4o) to craft SEO-friendly and engaging social media titles/descriptions. It ensures the content is optimized before publishing.
Airtable (Create & Update Records): Multiple Airtable n8n nodes are used throughout the flow. Initially, they create a record, and later they update fields like Description, Upload Date, and crucially, the platform-specific success statuses and resulting URLs (e.g., TikTok Status, Instagram URL). This provides robust tracking for the entire n8n workflow.

• HTTP Request (Upload Video nodes): These core nodes handle the actual publishing. They are configured for 'multipart-form-data' POST requests to the upload-post.com API, passing the video binary data, the AI-generated title, and specifying the target platform (Instagram, TikTok, or YouTube). The success or failure of these nodes determines the final Airtable status update.