Extract insights and analyze YouTube comments via AI chat
Workflow Description
An automation template that extracts YouTube comments and analyzes them through an AI agent via chat interface, storing insights in Postgres for continuous monitoring and strategic decision-making.
How it works
- 1.Activate the chat trigger to receive user analysis requests
- 2.Extract comments from the specified YouTube video
- 3.Process comments through an AI agent to identify sentiment and key themes
- 4.Store analysis results and insights in the Postgres database
- 5.Deliver summary and actionable recommendations to the user via chat
Use cases
- Monitor audience sentiment and satisfaction levels across video comments
- Identify recurring themes and trending topics to refine content strategy
- Extract frequently asked questions to address in future video content or documentation
Requirements
- OpenAI API key for AI model inference and analysis
- YouTube video URL or ID to extract and process comments from
- Configured Postgres database for storing analysis results and historical data
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (29)
Sticky Note9
Sticky Note
Sticky Note7
Sticky Note
Sticky Note6
Sticky Note
OpenAI Chat Model
OpenAI
get_channel_details
Tool Workflow
get_video_description
Tool Workflow
get_list_of_videos
Tool Workflow
get_list_of_comments
Tool Workflow
search
Tool Workflow
analyze_thumbnail
Tool Workflow
video_transcription
Tool Workflow
Postgres Chat Memory
Memory Postgres Chat
AI Agent
Agent
When chat message received
Chat Trigger
Sticky Note
Sticky Note
Get Comments
HTTP Request
Execute Workflow Trigger
Execute Workflow Trigger
Get Channel Details
HTTP Request
Get Video Description
HTTP Request
Edit Fields
Set
Run Query
HTTP Request
Get Videos by Channel
HTTP Request
Response
Set
Switch
Switch
Get Video Transcription
HTTP Request
OpenAI
OpenAI
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note