Automates detection of outlier videos on competitor YouTube channels that outperform averages, using YouTube API and PostgreSQL for efficient trending content discovery.
This n8n workflow identifies trending videos in your niche by analyzing competitor channels for outliers—videos with significantly higher views than the channel's historical average. It fetches video data via the YouTube API, stores statistics in a PostgreSQL database to track only new content, filters out short videos, and applies configurable thresholds (e.g., 2x average views in the last two weeks) to highlight top performers with engagement metrics.
Key benefits include time-saving automati
Platform
n8n
Category
Travel & Hospitality
Price
$22.99
Creator
Fred Garcia
YouTube
Outlier Detection
Competitor Analysis
Trending Content
Social Media
Marketing Automation
PostgreSQL
YouTube API
Content Research
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.