Extract and analyze YouTube comments using an AI agent
Workflow Description
Automation that retrieves YouTube comments and analyzes them using an AI-powered agent with OpenAI, storing results in PostgreSQL for ongoing review and monitoring of audience insights.
How it works
- 1.Trigger the workflow via chat interface to begin comment processing
- 2.Fetch YouTube comments and send them to an intelligent agent
- 3.Analyze comments with OpenAI to identify key themes and sentiment
- 4.Store analyzed data and insights in PostgreSQL database
- 5.Share summaries and findings via Twitter/X or other platforms
Use cases
- Monitor viewer sentiment and trends across your YouTube video catalog
- Analyze customer feedback on marketing content and promotional videos
- Collect and organize user feedback from comments for product development teams
Requirements
- OpenAI API key for access to GPT language models
- YouTube credentials or API access to retrieve video comments
- PostgreSQL database configured to store analysis results
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