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

• Content marketers needing a constant stream of platform-tailored content.


• Automation engineers looking for advanced AI-driven n8n templates.


• Social media managers who publish derived content from long-form videos (like YouTube).


• Users requiring a robust, scheduled n8n workflow for content repurposing.

In today’s fast-paced digital environment, repurposing long-form content for social media is crucial but time-consuming. This comprehensive n8n workflow solves this by fully automating the process of transforming a simple search topic into three platform-specific, ready-to-publish posts, complete with custom AI-generated images.

The automation begins by monitoring a Google Sheet for new topics. It uses Dumpling AI to efficiently search YouTube, and then leverages the high-level reasoning of the GPT-4o n8n node to select the single best, most recent video. After obtaining the transcript, GPT-4o then acts as an expert content creator, generating highly specific text for Instagram, Facebook, and LinkedIn. Finally, the n8n workflow uses Dumpling AI again to generate unique visual assets for each post, delivering a complete, ready-to-use content package directly to your spreadsheet. This n8n workflow dramatically increases content output efficiency.

The entire process is initiated by the Schedule Trigger n8n node, making this a hands-off, recurring automation.

1. Trigger and Input: The Schedule Trigger starts the n8n workflow, which then uses the Google Sheets n8n node to pull the first unprocessed topic from the 'YouTube Topics' sheet.


2. Video Search: The topic is sent to Dumpling AI via an HTTP Request n8n node to search for relevant YouTube videos.


3. Filtering & Selection: A Code n8n node filters and sorts the search results to find the three most recent videos. The OpenAI n8n node (GPT-4o) then intelligently reviews these results against the original topic to select the single most relevant video.


4. Transcription & Generation: The selected video's URL is passed back to Dumpling AI to fetch the full transcript. This transcript is then fed into a powerful OpenAI n8n node, which generates three unique posts (Instagram, Facebook, LinkedIn) and accompanying image prompts in a structured JSON format.


5. Parallel Image Creation: The n8n workflow branches into three parallel paths. Each path uses Dumpling AI to generate a specific image based on the GPT-4o-generated prompt for its respective platform.


6. Formatting and Saving: Set n8n nodes consolidate the generated text and image URL. Three separate Google Sheets n8n nodes then append the finished content package to the 'Social media post' sheet.


7. Final Cleanup: After a Merge n8n node ensures all output operations are complete, a final Google Sheets n8n node updates the original input sheet, marking the topic as 'Searched? = Yes'. This completes the automated n8n workflow cycle.

To deploy this powerful n8n template, follow these steps:

1. Import: Copy the provided JSON into your n8n instance using the 'New' button and selecting 'Import from JSON'.


2. Credentials Setup: You will need two main credentials:

1. Google Sheet Configuration: Verify the Document ID and Sheet Names within the Google Sheets n8n nodes match your actual setup. Ensure your sheets have the required columns: Youtube Topics and Searched? in the input sheet, and platform, Content, and Image in the output sheet.


2. Activation: Once credentials are set and the sheet names are updated, activate the n8n workflow to run according to the schedule defined by the n8n trigger node.

• Trigger Search Schedule (Schedule Trigger n8n trigger): The starting point for this n8n workflow, set to run periodically to check for new topics.


• Get Unsearched Topic from Google Sheet (Google Sheets n8n node): Reads data from the 'YouTube Topics' sheet, specifically filtering for rows where the 'Searched?' column is empty or not marked 'Yes'.


• Search YouTube via Dumpling AI (HTTP Request n8n node): Sends the topic query to the Dumpling AI API to retrieve a list of related YouTube videos.


• Filter + Sort YouTube Videos (Code n8n node): Executes custom JavaScript to parse the JSON response, filter out non-video items, sort the remaining videos by publishedTime, and retain only the top 3 most recent results for optimized processing.


• Select Best Video with GPT-4o (OpenAI n8n node): Uses GPT-4o with highly specific system instructions to evaluate the top 3 videos and select the single best match, ensuring content relevance and timeliness.


• Get Transcript (Dumpling AI) (HTTP Request n8n node): Retrieves the full text transcript of the video selected by the previous n8n node using the Dumpling AI endpoint.


• Generate Posts with GPT-4o (OpenAI n8n node): The core content engine. Uses GPT-4o to transform the long transcript into three tailored social media posts, each adhering to platform-specific length, tone, and hashtag rules, and providing necessary image prompts.


• Generate Image Nodes (HTTP Request n8n node): Three separate nodes dedicated to calling the Dumpling AI image generation endpoint (generate-ai-image), utilizing the prompts created by GPT-4o to ensure visual consistency across platforms.


• Format Post Nodes (Set n8n node): Used to structure the final data package by combining the platform name, the generated text, and the Dumpling AI image URL, preparing the data for the final storage step.


• Save Post to Sheet Nodes (Google Sheets n8n node): Three separate operations to append the finalized Instagram, Facebook, and LinkedIn posts to the 'Social media post' spreadsheet.


• Update Topic Status in Sheet (Google Sheets n8n node): Marks the initial input topic as processed, preventing the n8n workflow from repeating the search.