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 Integrations
- Postgres + Schedule Trigger(39 workflows)
- Execute Workflow Trigger + Postgres(27 workflows)
- Postgres + Slack(17 workflows)
- Postgres + Postgres Tool(16 workflows)
- Postgres + Supabase(16 workflows)
- Execute Workflow Trigger + Postgres Tool(14 workflows)
- Google Sheets + Postgres(14 workflows)
- Postgres + Split Out(12 workflows)
- Postgres + Telegram(12 workflows)
- Gmail + Postgres(11 workflows)
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.
Automate Competitor Tracking with Crunchbase & ClickUp
Streamline competitor analysis by automatically fetching data from Crunchbase and creating review tasks in ClickUp. Stay informed about market changes without manual effort.
Automate Shipment Tracking with Telegram and n8n
Streamline your logistics operations by automating shipment tracking with Telegram and n8n. This workflow allows drivers to easily share updates, and ensures timely notifications to your team.
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.
Automate File & Folder Organization: Move, Copy, and Restructure with Ease
Streamline your file management processes with this n8n workflow. Automate the relocation and restructuring of files and folders, ensuring your data is always organized and accessible.