Generate Strategic YouTube Content Ideas Using AI - n8n Workflow

• Content creators and YouTube strategists looking to automate market research.


• Users who need advanced data processing and aggregation before feeding information into large language models.


• Businesses seeking actionable insights from audience feedback using an n8n workflow.


• Anyone looking for robust n8n templates integrating multiple AI services.

Developing a consistent content strategy requires deep understanding of what your audience currently engages with and what gaps exist in existing video topics. This advanced n8n workflow solves this problem by connecting multiple data sources and processing them through a powerful AI model. The automation is initiated by a Google Sheets n8n trigger when a new video link is added. It leverages Dumpling AI via an HTTP Request n8n node to pull the full video transcript and associated viewer comments. This raw data, alongside the video’s original search topic, is fed into GPT-4o. The AI acts as a content strategist, synthesizing the transcript (what was said), the search topic (what people look for), and the comments (what people react to/ask for) to produce highly targeted, structured video concepts. This powerful n8n template ensures that your next content piece is driven by real audience demand.

The entire process is controlled by this multi-step n8n workflow:

1. Trigger & Loop: The workflow starts with a Google Sheets n8n trigger, initiating every time a new row (containing a video link) is added to the specified input sheet. The subsequent Split In Batches n8n node ensures each video is processed individually.


2. Data Retrieval: The process pauses briefly using a Wait n8n node to respect API limits. Then, two HTTP Request n8n node calls connect to the Dumpling AI API: one to retrieve the full video transcript and another to fetch all associated YouTube comments.


3. Data Structuring: The comments, which arrive as an array of objects, are cleaned using a Code n8n node to extract only the comment text. An Aggregate n8n node then merges all these individual comment texts into one large string field, ready for the LLM.


4. AI Generation: The core of this n8n workflow is the OpenAI n8n node utilizing GPT-4o. It receives the merged comments, the full transcript, and the target search topic. A detailed system prompt instructs GPT-4o to analyze these inputs and generate 3 to 5 structured content ideas, outputting the result strictly as valid JSON.


5. Output & Storage: A Split Out n8n node separates the array of generated content ideas, creating a separate item for each proposed video topic. Finally, a Google Sheets n8n node appends these structured results (Title, Rationale, Engagement Potential) to a designated 'YouTube Content Idea' sheet.


6. Notification: A Gmail n8n node sends a notification email to the user, confirming that the content strategy analysis is complete and the results are available in the Google Sheet.

To deploy this n8n workflow template, follow these steps:

1. Import: Copy the provided JSON and import it into your n8n instance.


2. Google Sheets Setup: You will need two Google Sheet credentials. One set for the Google Sheets Trigger n8n node (configured for 'row added' on your input sheet containing video links and search topics), and a second set for the final Google Sheets n8n node (configured to append data to your output sheet).


3. Dumpling AI: Configure the two HTTP Request n8n node steps (Get Transcript and Get Comments). You must set up a 'Generic Credential Type' using 'HTTP Header Auth' to securely store your Dumpling AI API key.


4. OpenAI Credentials: Set up your API key in the OpenAI n8n node. Ensure you select the GPT-4o model as configured in the workflow parameters for optimal strategic analysis.


5. Gmail: Configure the Gmail n8n node with your required recipient and sender credentials. Update the email subject and body as desired.


6. Activate: Once all credentials and spreadsheet links are verified, set the n8n workflow to 'Active'. The n8n trigger will now monitor your input sheet for new data.

• Google Sheets Trigger (Trigger on New YouTube Video Row): This is the initiating n8n trigger. It listens for newly added rows in a specified Google Sheet, providing the workflow with the YouTube link and associated metadata.


• Split In Batches (Loop Over Videos): Essential for processing lists of videos sequentially, ensuring the Dumpling AI requests are handled one video at a time within the n8n workflow.


• Wait (Wait Between Requests): A flow control n8n node used to introduce a brief pause (rate limiting) between cycles to prevent API throttling.


• HTTP Request (Get Transcript/Get Comments from Dumpling AI): These n8n node steps connect to the external Dumpling AI API using the video URL extracted by the Google Sheets n8n trigger. They retrieve the video transcript and viewer comments.


• Code (Extract Comment Content): A custom scripting n8n node used for data transformation, iterating through the comments array to standardize the data by isolating the raw comment text.


• Aggregate (Merge Comments into Single Field): This n8n node takes all the extracted comment items and aggregates them into a single comprehensive text field (comment) required for the single LLM prompt.


• OpenAI (Generate Video Ideas with GPT-4o): The AI processing n8n node. It uses GPT-4o, providing it with detailed context (transcript, comments, search intent) to generate structured content ideas, leveraging its JSON output capability.


• Split Out (Split Content Ideas): Used to unpack the array of JSON results generated by GPT-4o, converting the list of content ideas into separate items for easy insertion into the Google Sheet n8n node.


• Google Sheets (Save Video Ideas to Google Sheets): The final action n8n node, appending the structured results (title, rationale, engagement) to a designated output spreadsheet.