N8N Competitor Tracker: Monitor YouTube Channels to Google Sheets

Stay ahead of your competition by tracking their channel metrics daily. This workflow automatically monitors competitor channels and logs data to Google Sheets for analysis.

What This Workflow Does

• Daily Schedule: Runs every day at 8 AM
• Channel Stats: Fetches subscriber counts, view counts, video counts
• Recent Videos: Tracks their latest uploads and performance
• Google Sheets: Logs everything for trend analysis

Why Track Competitors?

• Identify Trends: See what content performs well in your niche
• Benchmark Performance: Compare your growth to others
• Content Ideas: Spot gaps in their coverage you can fill
• Strategy Insights: Learn from their posting schedules

Prerequisites

• N8N instance
• YouTube Data API key
• Google Sheets connected
• List of competitor channel IDs

Step-by-Step Setup

Step 1: Set Up Daily Schedule

• Add "Schedule Trigger" node
• Set to daily, 8:00 AM
• Choose your timezone

Step 2: Fetch Channel Stats

• Add "YouTube" node
• Resource: Channel
• Operation: Get
• Channel IDs: Comma-separated list
• Parts: statistics, snippet

Step 3: Get Recent Videos

• Add another "YouTube" node
• Resource: Video
• Operation: Get All
• Channel ID: {{ $json.id }}
• Limit: 5 most recent
• Order by: date

Step 4: Save to Google Sheets

• Add "Google Sheets" node
• Operation: Append
• Document: Your tracking spreadsheet
• Sheet: "Competitor Tracking"
• Columns:

- Date

- Channel Name

- Subscribers

- Total Views

- Video Count

- Latest Video Title

- Latest Video Views

Spreadsheet Template

Create a sheet with these columns:

| Date | Channel | Subscribers | Views | Videos | Latest Title | Latest Views |

|------|---------|-------------|-------|--------|--------------|-------------|

| 2026-03-11 | Competitor A | 500K | 50M | 200 | How to... | 25K |

Analysis Tips

• Growth Charts: Create line graphs for subscriber growth
• Upload Frequency: Track how often they post
• Top Videos: Identify their best-performing content
• Seasonal Patterns: Look for timing trends

Download the Workflow

Get this workflow from our N8N Workflows page.