YouTube Video Statistics to PostgreSQL
detail.loadingPreview
Fetches YouTube video statistics and stores aggregated data in PostgreSQL.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow retrieves video statistics from YouTube channels, processes them to exclude very short or very long videos (shorts and potentially long-form content depending on criteria), and then calculates average view counts for each channel. The processed video data and channel averages are then stored in a PostgreSQL database.
Key Features
- Fetches YouTube video data by channel ID.
- Filters out YouTube Shorts based on video duration.
- Calculates average view counts per channel, excluding top/bottom ranked videos.
- Stores processed video statistics and channel averages in PostgreSQL.
How To Use
- Set up Credentials: Configure your PostgreSQL and YouTube OAuth2 API credentials in n8n.
- Configure Nodes: Ensure the
channelIdin theLoop Over Itemsnode and thepublishedAfterfilter in theget_videosnode are correctly set. - Database Schema: Make sure the
video_statisticstable exists in your PostgreSQL database or use thecreate_tablenode to create it. - Run Workflow: Execute the workflow to fetch, process, and store data.
Apps Used
Workflow JSON
{
"id": "9313b1d6-ffdc-47db-9557-e95a4d164017",
"name": "YouTube Video Statistics to PostgreSQL",
"nodes": 0,
"category": "Postgres",
"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: 9313b1d6-ffdc...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Postgres Schema Explorer (Unverified)
Explore and retrieve your PostgreSQL database schema to aid in generating natural language queries.
Community Sheets RAG (Unverified)
Generates SQL schema and insert statements from Google Sheets data, suitable for community contributions.
Automated Multi-Platform Influencer Discovery & Qualification
This powerful n8n workflow automates the entire process of discovering, scoring, and qualifying ideal influencers across Instagram, TikTok, and YouTube for your marketing campaigns. Streamline your talent acquisition by leveraging custom criteria and a sophisticated scoring algorithm.
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Telegram Profanity & Toxicity Filter
This n8n workflow automatically monitors incoming Telegram messages for profanity and toxic language. It leverages Google's Perspective API to analyze message content, and if a message is deemed inappropriate, the workflow sends an automated warning response back to the sender.
Robust Concurrency Control for n8n Workflows with Redis
Prevent simultaneous execution of critical n8n workflows or tasks using a centralized, Redis-backed locking mechanism. This reusable utility workflow ensures data integrity and resource management by allowing other workflows to acquire, check, and release locks.