Collect YouTube channel stats & contact info with Google Sheets and SerpAPI

Workflow Overview This advanced n8n automation is a powerful channel research and intelligence gathering tool designed to transform raw YouTube channel data into actionable insights. By intelligently connecting multiple APIs and data sources, this workflow:

1. Discovers Channel Metrics: - Automatically retrieves channel statistics - Captures detailed performance indicators - Provides comprehensive channel intelligence

2. Performs Deep Analysis: - Extracts recent video performance data - Calculates engagement metrics - Aggregates view count insights

3. Uncovers Contact Information: - Attempts to retrieve public email addresses - Provides direct outreach opportunities - Enhances lead generation capabilities

4. Seamless Data Logging: - Automatically updates Google Sheets - Maintains a live intelligence dashboard - Preserves historical channel data

Key Benefits - 🤖 Full Automation: Continuous channel intelligence gathering - 💡 Smart Analysis: Comprehensive performance insights - 📊 Real-Time Tracking: Always-updated channel metrics - 🔍 Lead Generation: Direct contact information extraction

Workflow Architecture

🔹 Stage 1: Channel Identification - Google Sheets Trigger: Detects new channel additions - YouTube Data API: Fetches channel statistics - Comprehensive Metric Collection: - Subscriber count - Total view metrics - Channel overview