Automate YouTube Channel Intelligence Collection
detail.loadingPreview
Streamline your YouTube channel analysis with this n8n workflow. Automatically collect key metrics like subscriber counts, recent video views, and channel contact information directly into your Google Sheet.
About This Workflow
Unlock powerful insights into your YouTube performance and competitors with the Youtube Channel Intelligence Collector. This n8n workflow seamlessly integrates with Google Sheets to automate the tedious process of data gathering. When a new channel is added to your spreadsheet, it triggers a cascade of data collection, pulling detailed statistics, snippet information, and even recent video view counts from the YouTube API. Furthermore, it leverages SerpAPI to attempt to retrieve the channel's email address for direct contact. All collected data, including recent views, total subscribers, and email, is then meticulously organized and updated back into your Google Sheet, providing a comprehensive dashboard for informed decision-making.
Key Features
- Automated Data Collection: Triggered by new channel entries in Google Sheets.
- Comprehensive YouTube Metrics: Gathers subscriber counts, video statistics, and more.
- Recent Video Performance: Analyzes views on your latest videos.
- Contact Information Retrieval: Attempts to find channel email addresses via SerpAPI.
- Seamless Google Sheets Integration: Reads from and writes to your specified Google Sheet.
How To Use
- Set up Google Sheets Trigger: Connect your Google account and specify the Google Sheet and sheet name containing your YouTube channel IDs. Configure it to trigger on a new row added.
- Configure YouTube API Requests: Replace
YOUR_KEYplaceholders in theGet info about channelandGet Channel Statsnodes with your actual YouTube Data API key. Ensure your channel IDs are correctly passed. - Utilize SerpAPI for Email: In the
Get Channel Email (SerpAPI)node, replaceYOUR_SERPAPI_KEYwith your SerpAPI key. The workflow dynamically uses theChannel IDfrom the Google Sheet trigger. - Review and Adjust Nodes: Examine the
Prepare views to sumandPrepare Sheet Datanodes to ensure the data points being extracted and mapped are correct for your needs. - Configure Google Sheets Output: In the
Update Channel Insightsnode, confirm the correct Google Sheet and sheet name are selected, and that the column mappings accurately reflect the data you want to update.
Apps Used
Workflow JSON
{
"id": "174609af-9f40-4a02-ac34-58247b55705d",
"name": "Automate YouTube Channel Intelligence Collection",
"nodes": 5,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 174609af-9f40...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.