YouTube Channel Video Data Collector
detail.loadingPreview
This n8n workflow automates the systematic collection of YouTube video statistics, fetching new videos from specified channels and storing their detailed metrics into a PostgreSQL database. It intelligently filters out YouTube Shorts and enriches data, laying a solid foundation for comprehensive channel performance analysis.
About This Workflow
This powerful n8n workflow provides an automated solution for continuously tracking YouTube channel performance. By intelligently querying the YouTube Data API, it identifies and retrieves new video uploads from a list of predefined channels. It diligently collects crucial metrics like view counts, likes, comments, and publish times, enriching this data for comprehensive analysis. To ensure data relevance, the workflow automatically filters out YouTube Shorts (videos shorter than 60 seconds). All collected and cleaned video data is then systematically stored in a PostgreSQL database, ready for custom reporting, trend analysis, and deeper insights into content performance and audience engagement over time.
Key Features
- Automated YouTube Data Collection: Automatically fetch new video uploads and their detailed statistics from multiple specified YouTube channels.
- PostgreSQL Data Persistence: Store all collected video performance metrics (views, likes, comments, publish time) in a structured PostgreSQL database for historical tracking and analysis.
- Smart Incremental Updates: Only retrieve videos published since the last recorded update for each channel, ensuring efficient API usage and continuous data freshness.
- YouTube Shorts Filtering: Automatically exclude short-form content (videos under 60 seconds) to focus on traditional long-form video performance.
- Comprehensive Video Metrics: Collect essential data including content details, view count, like count, and comment count for each video via the YouTube Data API.
How To Use
- Configure PostgreSQL Credentials: Ensure you have a PostgreSQL database set up and configure the 'Postgres account' credentials within n8n, ensuring access for table creation and data insertion.
- Set Up YouTube API Credentials: Obtain a YouTube Data API v3 key from the Google Cloud Console and add it as an environment variable named
GOOGLE_API_KEYin n8n. Also, configure 'YouTube account' OAuth2 credentials for API access. - Initialize Database Table: Run the
create_tablenode (or the entire workflow once) to create thevideo_statisticstable in your PostgreSQL database, if it doesn't already exist. - Provide Channel IDs: Input a list of YouTube channel IDs to the
Loop Over Itemsnode. This can come from a preceding node (e.g., a spreadsheet, database query, or another workflow trigger). - Activate and Monitor: Activate the workflow. It will periodically fetch new videos for your specified channels, process their data, filter shorts, and efficiently store the statistics in your PostgreSQL database.
Apps Used
Workflow JSON
{
"id": "85a545ba-966f-4259-b91d-6e0d7295566d",
"name": "YouTube Channel Video Data Collector",
"nodes": 6,
"category": "Operations",
"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: 85a545ba-966f...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
Automate Getty Images Editorial Search & CMS Integration
This n8n workflow automates searching for editorial images on Getty Images, extracts key details and embed codes, and prepares them for seamless integration into your Content Management System (CMS), streamlining your content creation process.
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.