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 - Ca
At a glance
Collect YouTube channel stats & contact info with Google Sheets and SerpAPI is a ready-made n8n workflow you import as a workflow JSON file β no build required. It connects Google Sheets, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets, LinkedIn
- Modules
- 9
- Price
- Free
- Version
- v1.0

About this workflow
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: Yaron@nofluff.online π₯ YouTube: @YaronBeen πΌ LinkedIn: Yaron Been Transform your channel research with intelligent, automated workflows!
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n β click the menu β Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Update Google Sheets rows based on ChatGPT Assistant responses
WooCommerce AI post-sales chatbot with GPT-4o, RAG, Google Drive and Telegram
Add new Google Sheets rows for every LinkedIn lead gen form response
Scan your books with Android barcodes and save them in a Google Sheet spreadsheet
Automated HR screening with VAPI AI calls, Gemini analysis & Google Sheets
Track marketing channel performance with HighLevel, Google Sheets, and Slack
Build a PDF-based RAG system with OpenAI, Pinecone and Cohere reranking
Create and publish AI avatar short videos with Gemini, HeyGen and Google Sheets
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint β instant download
- Setup guide PDF included
- 5 downloads Β· valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you