YouTube Channel Stats & Contact Collector with Sheets & SerpAPI

This advanced n8n workflow is a comprehensive tool for YouTube channel research, transforming raw data into actionable insights. It starts with a Google Sheets trigger that detects new channels, then uses the YouTube Data API to retrieve key statistics like subscriber count, total views, and channel overview. Next, it analyzes the 5 latest videos by aggregating view counts and engagement metrics to provide a performance snapshot.

In the contact discovery stage, it leverages SerpAPI to search for public email addresses and outreach opportunities, enhancing lead generation. All data is automatically logged back to Google Sheets, creating a live dashboard for historical tracking and real-time monitoring.

Key benefits include full automation for continuous intelligence gathering, smart analysis for content effectiveness insights, and direct lead extraction. Ideal use cases: marketing teams tracking competitors, agencies building outreach lists, content creators benchmarking performance, and enterprises scaling social media research without manual effort.