Collect YouTube channel stats & contact info with Google Sheets and SerpAPI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (5)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
What it does
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 🔹 Stage 2: Video Performance Analysis - Recent Video Retrieval: Fetches 5 latest uploads - View Count Aggregation: - Calculates total recent views - Provides engagement snapshot - Performance Insights: Measures content effectiveness 🔹 Stage 3: Contact Discovery - SerpAPI Integration: Attempts email extraction - Public Contact Information: - Retrieves available email addresses - Supports outreach and networking 🔹 Stage 4: Data Compilation - Intelligent Data Formatting - Google Sheets Update - Live Intelligence Dashboard Potential Use Cases - Marketing Teams: Influencer research - Sales Professionals: Lead qualification - Content Strategists: Competitive analysis - Recruitment Specialists: Talent scouting - Business Development: Partnership identification Setup Requirements 1. YouTube Data API - Google Cloud API credentials - Configured API access 2. SerpAPI Account - API key for email extraction - Web scraping permissions 3. Google Sheets - Connected Google account - Prepared tracking spreadsheet - Appropriate sharing settings 4. n8n Installation - Cloud or self-hosted instance - Workflow configuration - API credential management Future Enhancement Suggestions - 🤖 AI-powered channel scoring - 📊 Advanced trend analysis - 🔔 Automated alert system - 🌐 Multi-platform channel tracking - 🧠 Machine learning insights generation Technical Considerations - Implement robust error handling - Use exponential backoff for API calls - Maintain flexible data extraction strategies - Ensure compliance with platform terms of service Ethical Guidelines - Respect content creator privacy - Use data for legitimate research - Maintain transparent data collection practices - Provide opt-out mechanisms Connect With Me Ready to unlock YouTube channel insights? 📧 Email: [email protected] 🎥 YouTube: @YaronBeen 💼 LinkedIn: Yaron Been Transform your channel research with intelligent, automated workflows!