AI-Powered Social Media Content Generator from Video Transcripts - n8n Workflow

Markdown-formatted list:

Content Creators & YouTubers: Who need to repurpose long-form video content quickly across multiple social platforms.
Marketing Agencies: Seeking a highly efficient and scalable solution for content production for clients.
Automation Specialists: Looking for advanced n8n templates integrating structured AI output and database management.
Teams using Airtable: Who manage their content calendar and source materials (like transcripts) within a relational database.

This advanced n8n workflow solves the massive time sink associated with content repurposing. By leveraging the power of an AI Agent backed by Google Gemini, this solution takes a single video transcript and, based on a comprehensive set of instructions, generates platform-optimized content for YouTube, Twitter (including threads), LinkedIn, Instagram (Reel and Post captions), Facebook, and TikTok—all structured in precise JSON format.

The entire process is orchestrated by n8n, beginning with an n8n trigger from Airtable and concluding with the persistent storage of both the generated text and organized files in Google Drive and Airtable. This robust n8n template ensures consistency, saves countless hours, and dramatically accelerates the publishing schedule for high-volume content operations. Every n8n node is configured for maximum efficiency and reliability.

This n8n workflow is initiated externally, maximizing flexibility and integration with existing tools:

1. Airtable Webhook Trigger: The process starts when the 🎯 Webhook Trigger n8n node receives a signal (like a status change) from an Airtable automation, supplying the unique RecordId for the transcript to be processed.


2. Fetch Transcript Data: The 1. Get Record Data Airtable n8n node uses the provided RecordId to retrieve the full dataset, including the raw video transcript and the desired content name.


3. Project Folder Setup: The 2. Create Project Folder Google Drive n8n node creates a dedicated, color-coded folder using the content's name for organized asset storage.


4. Folder Linkage: The 5. Link Folder to Record Airtable n8n node updates the original Airtable record with the ID of the new Google Drive folder, ensuring easy cross-reference.


5. AI Generation: The core of this n8n workflow, the 🤖 AI Content Generator n8n node (using Google Gemini 2.5 Flash), takes the raw transcript and uses a highly detailed instruction set to produce a structured JSON output containing 12 pieces of platform-specific content.


6. Save Raw Transcript: The 6. Save Transcript File Google Drive n8n node saves the original transcript as a text file inside the newly created project folder.


7. Save AI Output: Finally, the 4. Save Social Media Content Airtable n8n node updates the original Airtable record with all 12 generated text assets, including joining the Twitter thread array into a readable, newline-separated format. This completes the automatic processing of this n8n workflow.

To utilize this powerful n8n template, follow these steps:

1. Import: Copy the provided JSON data and paste it into your n8n instance using the 'Import Workflow' function.


2. Airtable Credentials: Set up credentials for the Airtable n8n node. This requires a Personal Access Token with read/write access to the specific Base and Table where your video transcripts are stored.


3. Google Drive Credentials: Configure OAuth2 credentials for the Google Drive n8n node, ensuring n8n has permission to create folders and files in the designated parent folder.


4. Gemini/Google AI Credentials: The AI Agent relies on a Google Gemini API key. Ensure the necessary connection is established for the ⚡ Gemini Flash Model and 🧠 Gemini Pro Model n8n nodes.


5. Configure Trigger: Activate the 🎯 Webhook Trigger n8n node. Copy its unique URL and configure an automation inside your Airtable base to send a POST request to this URL whenever a transcript record is ready for processing. The payload must include the RecordId.


6. Activate: Set the n8n workflow to 'Active' to start listening for the Airtable n8n trigger.

This n8n workflow utilizes several specialized n8n nodes:

🎯 Webhook Trigger (n8n trigger): The starting point for the automation. It listens for an external signal from Airtable and passes the essential RecordId to the flow.
1. Get Record Data (Airtable n8n node): Retrieves the full record details, specifically extracting the transcript content needed for the AI generation step.
2. Create Project Folder (Google Drive n8n node): Manages file organization by creating a dedicated folder named after the content title, crucial for asset management.
🤖 AI Content Generator (AI Agent n8n node): This core n8n node uses a detailed, multi-platform prompt instruction set to generate 12 distinct content pieces. It processes the raw transcript and enforces structured JSON output.
⚡ Gemini Flash Model (Language Model n8n node): The language model backbone for the AI Agent, providing fast and high-quality generation of the structured content.
📋 JSON Output Parser (Output Parser n8n node): Essential for ensuring the AI's response adheres strictly to the required JSON schema, guaranteeing data integrity before saving back to Airtable.

• 4. Save Social Media Content (Airtable n8n node): The final action, updating the original record with all the AI-generated titles, captions, and threads derived from the structured output of the previous n8n node.