Transform YouTube videos to LinkedIn posts with Apify, GPT-4.1 Mini & Google Sheets

Transform YouTube videos to LinkedIn posts via Apify, GPT-4.1 Mini, and Google Sheets 

This workflow transforms new YouTube videos from any channel into high-quality, ready-to-publish LinkedIn posts and saves them directly to a Google Sheet, creating a powerful, automated content repurposing engine.

Workflow Preview


Who’s it for This template is perfect for content creators, social media managers, and marketing teams who want to save time and consistently repurpose video content for their professional audience on LinkedIn.

What it does This automation monitors a specific YouTube channel for new video uploads. When a new video is detected, it automatically extracts the full transcript. The transcript is then sent to an advanced AI model (GPT-4o or similar) which acts as a "thought leader" to generate two distinct, insightful LinkedIn posts based on the video's core themes. Finally, these generated posts are neatly organized and saved as new rows in a Google Sheet for easy review and scheduling.

How to set up 1. Set the Trigger: In the "RSS Feed Trigger" node, enter the RSS Feed URL for the YouTube channel you want to monitor. You can find this by searching the channel's page source for its channelid and using the format: https://www.youtube.com/feeds/videos.xml?channelid=YOURIDHERE. 2. Connect Credentials: Add your API credentials for Apify and OpenAI in their respective nodes. 3. Configure Google Sheets: First prepare your spreadsheet by opening Google Sheets and creating a new sheet. In the first row, create the following headers exactly as they appear below: Video Link Theme Hook Body CTA Hashtags Now in the n8n Google Sheets node, authenticate your account. Then select the spreadsheet you just prepared and the specific sheet name from the dropdown lists. 4. Activate: Save the workflow and toggle it to "Active".

How to Find a YouTube Channel ID To monitor a specific channel, you need its unique ID to create the RSS feed URL required in the first step. Here’s how to find it: 1. Navigate to the main page of the YouTube channel you want to follow (e.g., https://www.youtube.com/@CalebWritesCode). 2. Right-click anywhere on the page and select "View Page Source" from the menu. 3. A new browser tab will open with the website's code. Press Ctrl+F (on Windows) or Cmd+F (on Mac) to open the search bar. 4. In the search bar, type <yt:channelId> and press Enter. 5. The search will highlight a line of code containing the ID. Copy the long string of letters and numbers that appears inside the <yt:channelId> tag. 6. Paste this ID into the RSS Feed URL format: https://www.youtube.com/feeds/videos.xml?channelid=YOURIDHERE.