Skip to main content

Generate YouTube video ideas from comments with GPT-4o-mini and Google Sheets

Workflow preview

Workflow preview
100%
Generate YouTube video ideas from comments with GPT-4o-mini and Google Sheets preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

Analyse YouTube Comments via AI Agent and Create Video Topics Description...

Best for

  • Market Research automation workflows
  • AI Summarization automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.scheduletrigger, n8n-nodes-base.youtube, n8n-nodes-base.code, n8n-nodes-base.httprequest, n8n-nodes-base.googlesheets, @n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmchatopenai, @n8n/n8n-nodes-langchain.outputparserstructured

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Websensepro.

Original n8n.io source

1.1 Workflow description

Title
Generate YouTube video ideas from comments with GPT-4o-mini and Google Sheets
Workflow name
Generate YouTube video ideas from comments with GPT-4o-mini and Google Sheets

#Analyse YouTube Comments via AI Agent and Create Video Topics

Description

Identifying what your audience wants can be a manual and time-consuming process. This workflow automates your content research by analyzing comments from your latest YouTube videos using an AI Agent. Every week, it fetches feedback, stores it in Google Sheets for backup, and uses OpenAI to suggest the TOP 5 SEO-optimized video topics based on real viewer requests.

The final content strategy is delivered directly to your Gmail inbox, allowing you to focus on creating rather than researching.

What it Does

  • Weekly Trigger: The workflow starts automatically every Friday (customizable) via the Schedule Trigger.
  • Fetches Video Data: It pulls the latest 5 videos from your specified YouTube playlist.
  • Retrieves Comments: Uses the YouTube API (HTTP Request) to fetch up to 100 comment threads per video.
  • Data Archiving: All retrieved comments are saved into a Google Sheet, ensuring you have a permanent backup of audience feedback.
  • AI Analysis: A JavaScript node formats the comments and passes them to an AI Agent. Powered by OpenAI (GPT-4o-mini), the agent identifies recurring themes and requests.
  • Structured Output: The Output Parser ensures the AI provides exactly 5 video titles in a clean, professional format.
  • Email Delivery: The Gmail node sends a summary of the suggested content plan directly to your inbox.

Use Cases

  • YouTube Creators: Automatically find out what tutorials or "How-to" videos your audience is asking for.
  • Social Media Managers: Generate weekly reports on audience sentiment and demand for clients.
  • Educational Channels: Identify specific pain points or questions students are mentioning in the comments.

Customization

  • YouTube Node: Replace the Playlist ID with the ID of the playlist you want to monitor.
  • Google Sheets: Select your own Spreadsheet and Sheet Name in the Append row in sheet node.
  • AI Agent Prompt: You can modify the prompt to change the tone of the titles (e.g., "Make them clickbaity" or "Make them educational").
  • Gmail Node: Update the "To" email address to your own email.

Requirements

  • An n8n instance (Cloud or Self-hosted).
  • Google Cloud Credentials (With YouTube Data API v3, Google Sheets API, and Gmail API enabled).
  • OpenAI API Key (For the AI Agent analysis).

How to Set Up

  1. Connect Credentials: Link your YouTube, Google Sheets, Gmail, and OpenAI accounts to their respective nodes.
  2. Configure Playlist: In the "Get many playlist items" node, enter your YouTube Playlist ID.
  3. Select Sheet: In the "Append row in sheet" node, pick your target Google Sheet.
  4. Update Gmail: In the "Send a message" node, set your recipient email address.
  5. Activate: Save the workflow and toggle it to Active.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Schedule Trigger

Type / Role
n8n-nodes-base.scheduleTrigger - scheduleTrigger
Config choices
Version 1.2

Block 2 - Get many playlist items

Type / Role
n8n-nodes-base.youTube - youTube
Config choices
Version 1

Block 3 - video-ids

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 4 - HTTP Request

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 5 - Code in JavaScript

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 6 - Append row in sheet

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 7 - Code in JavaScript1

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 8 - AI Agent

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 3

Block 9 - OpenAI Chat Model

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenAi - lmChatOpenAi
Config choices
Version 1.3

Block 10 - Structured Output Parser

Type / Role
@n8n/n8n-nodes-langchain.outputParserStructured - outputParserStructured
Config choices
Version 1.3

Block 11 - Send a message

Type / Role
n8n-nodes-base.gmail - gmail
Config choices
Version 2.1

Block 12 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 13 - Sticky Note1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 14 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 15 - Sticky Note3

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

3. Summary Table

Workflow Generate YouTube video ideas from comments with GPT-4o-mini and Google Sheets
Complexity advanced
Nodes 15
Categories Market Research, AI Summarization
Author Websensepro
Published 19 Dec 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/11950/11950.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Generate YouTube video ideas from comments with GPT-4o-mini and Google Sheets do?

Analyse YouTube Comments via AI Agent and Create Video Topics Description...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Market Research, AI Summarization use case.