YouTube Video Transcript Repurposing to LinkedIn Posts - n8n Workflow

Content marketers needing to maximize video ROI.
Thought leaders who produce regular video content and need rapid distribution.
Agencies managing social media for video creators.
Users looking for advanced n8n templates integrating scraping and AI.

This powerful n8n workflow solves the tedious problem of manually repurposing long-form video content into digestible social media posts. By leveraging an RSS n8n trigger for immediate detection of new uploads, the system ensures rapid content turnaround. It uses specialized tools (Apify) to extract the full transcript and then feeds this data into a highly structured GPT-4.1 Mini prompt. The prompt directs the AI to act as an expert and generate two distinct, high-value LinkedIn posts (complete with hooks, bodies, CTAs, and relevant hashtags). The final step saves these ready-to-publish assets to a Google Sheet, creating a clean editorial calendar. This is a crucial n8n workflow for maximizing content velocity and demonstrating the power of n8n templates for complex automation.

The process begins with the RSS Feed n8n trigger, which monitors a specific YouTube channel ID's feed for new video links, typically polling on a set schedule. Once a new video is detected, this initial n8n node passes the video URL to the Apify n8n node. The Apify node runs a specialized Actor designed to scrape the full transcript text from the provided YouTube link. This raw transcript is then passed to the OpenAI n8n node, configured to use the GPT-4.1 Mini model. The prompt is meticulously engineered to enforce a specific persona (thought leader) and output format (strict JSON array containing exactly two distinct posts). Following the AI generation, the Code n8n node parses the resulting JSON text string into structured data objects. The subsequent Split Out n8n node takes the array of two posts and processes them as separate items. Finally, the Google Sheets n8n node appends the detailed metadata (Theme, Hook, Body, CTA, Hashtags, and original Video Link retrieved by the initial n8n trigger) for each generated post into a designated sheet, completing this robust content generation n8n workflow.

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


2. Credentials Setup:

1. Activate: Set the n8n workflow to 'Active' to begin monitoring the YouTube channel automatically.

RSS Feed Trigger (n8n trigger): The starting point of the n8n workflow. It monitors a YouTube channel's RSS feed URL and fires when a new video link is detected.
Run an Actor and get dataset (Apify n8n node): Executes the scrapingxpert/youtube-video-to-transcript Actor, using the new video link from the n8n trigger to reliably scrape and return the full video transcript text.
Message a model (OpenAI n8n node): The core intelligence of this n8n workflow. It uses the GPT-4.1 Mini model with a specific system prompt to generate exactly two distinct LinkedIn posts in a mandatory JSON format, ensuring high-quality, professional output.
Code in JavaScript (n8n node): Function: Converts the text string JSON output from the AI into a structured JavaScript object array, which is necessary for downstream flow control within n8n.
Split Out (n8n node): Function: Splits the array containing the two generated posts (field posts) so that each post is processed individually, ensuring two separate rows are created.
Append row in sheet (Google Sheets n8n node): Function: Saves the finalized LinkedIn content (Hook, Body, CTA, Hashtags, Theme, and the original Video Link retrieved by the initial n8n trigger) into the configured Google Sheet for editorial oversight, concluding this powerful n8n workflow.