YouTube Video Data Ingestion and Analysis

This workflow is for anyone who needs to track YouTube video performance, like content creators, marketing teams, or data analysts. It helps you find good performing videos on YouTube. This workflow gets YouTube channel video data. It stores the data in a database. Then, it finds the best performing videos from the last two weeks for each channel. Videos must be long enough and have double the average views. Set up a Postgres database and add your Google API key and YouTube OAuth2 API credentials to n8n. You need a Google API key and a YouTube OAuth2 API account with access to YouTube Data API v3. You can change the number of videos to get, the time frame for analysis, and the criteria for "best performing" videos (e.g., view count multiplier, minimum duration). You can also adjust the database schema or the SQL queries to fit specific data needs. Key Technologies: YouTube Data API v3,PostgreSQL,n8n Code Nodes Automation Value: Automatically collects YouTube video data. Identifies high-performing videos based on custom rules. Saves time by automating data gathering and analysis. Helps content creators find content that performs well. Keeps a record of video performance in a database. Reduces manual effort for data entry and analysis. Best Practices: Use descriptive names for nodes to improve readability. Add comments to complex code nodes. Handle errors explicitly for API calls and database operations.