YouTube Trend Detector — Automating Viral Content Research
One of the first automations I've built for a content creator client was a YouTube trend detector — a system that automatically monitors competitor and niche channels, identifies outlier performing videos, and delivers a structured report of content ideas directly to their Google Drive. The client has been using it consistently ever since, and it became the foundation for a broader automation stack we built on top of it.
The problem it solves
Finding viral content ideas manually is tedious. You open YouTube, browse a bunch of channels, try to spot which videos are performing unusually well, take notes, and repeat. It's the kind of task that takes an hour, needs to happen regularly, and produces inconsistent results depending on how much attention you pay that day.
The automation replaces all of that entirely.
How the system works
The system runs on two separate workflows in n8n:
Workflow 1 — Data collection & database update
This workflow runs on a schedule and does the following:
- Pulls a list of monitored YouTube channels from an Airtable database
- Uses the YouTube API to fetch the latest videos from each channel
- Filters out Shorts — only long form videos are tracked (later down the line we've built this exact system with some tweaks for Shorts as well)
- For each video, pulls detailed stats including view count, likes, duration, comments
- Checks if the video already exists in the Airtable database — if yes, it updates the metrics, if no, it adds it as a new record
The result is a living, continuously updated database of videos across every channel the client cares about. Because view counts are updated on every run, videos that get rediscovered and go viral later are caught too — not just new uploads.
Workflow 2 — Trend detection & report generation
This workflow also runs on a schedule — in this case daily — and does the following:
- Pulls all videos from the Airtable database
- Calculates the average view count per channel
- Identifies outlier videos — ones performing significantly above the channel average
- Compiles the outliers into a structured report
- Creates a new Google Doc with the report and adds the link back into Airtable for easy reference
The client receives a clean, organized Google Doc every day with the top performing videos across their niche, ready to use as content inspiration.
Why the multiple matters
The outlier detection is based on a simple but powerful concept — the multiple. Instead of just looking at raw view counts, you compare each video's views against the average view count for that channel. A video with 500,000 views on a channel that averages 50,000 views per video is a 10x outlier. That's far more signal than a video with 500,000 views on a channel that regularly hits a million.
This approach works because it normalizes for channel size. You can track a mix of small and large channels and the outlier detection stays meaningful across all of them.
What the client gets
A daily Google Doc report delivered automatically, containing the highest performing videos across their monitored channels — sorted by multiple, with title, channel, view count, and a direct link to the video. No manual research, no missed trends, no inconsistency.
The client has been using this system consistently since we built it, and it's become a core part of how they generate content ideas. It also became the starting point for a broader automation stack we've since built for them — but that's a story for another time.
Want something like this?
If you're a content creator or work with one, this kind of system is relatively straightforward to build and delivers consistent value from day one. Feel free to reach out if you want to discuss building one for your use case.