# I Built an AI YouTube Dashboard in MINUTES!

Source: https://www.youtube.com/watch?v=YNDDX1XYwK0
Recap page: https://rapidrecap.app/video/YNDDX1XYwK0
Generated: 2025-11-11T19:08:12.156+00:00

---
## Quick Overview

The creator successfully built an overpowered YouTube Intelligence Dashboard in minutes by orchestrating a workflow using Zapier, Apify (for scraping YouTube data), AI by Zapier (for sentiment analysis and keyword extraction), and PostgreSQL (for database storage), resulting in a fully automated system that pulls data, analyzes it, and visualizes insights like performance metrics and comment sentiment.

**Key Points:**
- The creator built a fully automated YouTube Intelligence Dashboard using Zapier, Apify, AI by Zapier, and PostgreSQL.
- The Zapier workflow is triggered by a webhook, scrapes YouTube data using the Apify 'YouTube Scraper' actor, and then scrapes comments using the 'YouTube Comments Scraper' actor.
- AI by Zapier analyzes the scraped video data (for the dashboard) and comments (for sentiment/keywords), with specific steps for duration conversion and JSON formatting.
- The analyzed data is stored in a custom PostgreSQL database named 'youtube_dashboard' with a 'video_insights' table structure defined via SQL.
- The final dashboard visualizes key metrics like total views (e.g., 323 views across 2 synced videos), AI SEO Score (e.g., 7.0), and watch time (e.g., 12m 05s average time per video).
- The system is capable of analyzing comments for sentiment (positive/neutral/negative) and extracting keywords, as demonstrated by the sentiment map showing 100% positive comments for a specific video.
- The creator also demonstrated using the Apify 'YouTube Suggester' actor to generate relevant content ideas based on search queries like 'WordPress hosting'.

![Screenshot at 00:04: The creator begins detailing the goal: coding an overpowered YouTube dashboard using Apify for scraping and Zapier for orchestration.](https://ss.rapidrecap.app/screens/YNDDX1XYwK0/00-00-04.png)

**Context:** The video serves as a tutorial demonstrating how to leverage various AI and automation tools—specifically Zapier, Apify for web scraping, AI by Zapier for data processing, and PostgreSQL for data persistence—to create a powerful, custom analytics dashboard for YouTube content. The creator walks through setting up a multi-step Zap workflow that ingests video metadata and comment sentiment analysis to provide real-time insights for content creators and marketers.

## Detailed Analysis

The tutorial focuses on building an end-to-end automated system to analyze YouTube performance and content using a combination of third-party tools orchestrated by Zapier. The process begins in Zapier by setting up a Webhook trigger (Catch Hook) to receive data, followed by an Apify 'Run Actor' step to scrape video data using the 'YouTube Scraper' actor. A delay step is intentionally added to wait for the scraper to finish. The workflow then fetches dataset items from Apify, loops through the results (3 videos in this case), and passes each video's data to AI by Zapier for detailed analysis, including extracting video analysis, summaries, common keywords, content themes, and audience targeting information. This structured data is then inserted into a custom PostgreSQL database ('youtube_dashboard') using the 'New Row' action, which required defining the table schema via SQL beforehand, including indexes for efficient querying. Finally, the data is displayed in a custom 'Overpowered YouTube Intelligence Dashboard' interface, showing metrics like Total Views (e.g., 676 across 4 synced videos) and Watch Time (e.g., 45m 15s average). The creator also demonstrated using the YouTube Comments Scraper and AI by Zapier to analyze comment sentiment, which was then displayed in a sentiment map on the dashboard, proving the entire pipeline's success.

### Workflow Construction (Zapier)

- Webhook by Zapier (Catch Hook) -> Apify (Run Actor: YouTube Scraper) -> Delay by Zapier -> Apify (Fetch Dataset Items) -> Looping by Zapier (Create Loop From Line Items) -> AI by Zapier (Analyze and Return Data) -> PostgreSQL (New Row)

### Data Scraping & Analysis (Apify/AI)

- Apify scrapes video metadata (3 videos) and comments; AI by Zapier analyzes sentiment, keywords, and content themes, handling data format conversions (like duration from HH:MM:SS to seconds).

### Database Setup (PostgreSQL)

- A custom 'youtube_dashboard' project was created in Supabase, featuring a 'video_insights' table defined by a complex SQL CREATE TABLE statement with appropriate indexes (e.g., on video_id, channel_name, ai_keywords).

### Dashboard Visualization (Next.js/Supabase)

- The final dashboard displays aggregated metrics (Total Views: 676, AI SEO Score: 7.5) and a 'Video Intelligence Grid' showing AI-derived insights, keywords, and sentiment maps based on the data stored in PostgreSQL.

### Additional Tool Demonstration (Apify Suggester)

- The creator showcased using the Apify 'YouTube Suggester' actor to find relevant search query ideas (like 'WordPress hosting') for future content planning.

![Screenshot at 00:04: The creator begins detailing the goal: coding an overpowered YouTube dashboard using Apify for scraping and Zapier for orchestration.](https://ss.rapidrecap.app/screens/YNDDX1XYwK0/00-00-04.png)
![Screenshot at 00:17: The creator identifies the three core tools needed for the automation: ChatGPT, Zapier, and Apify.](https://ss.rapidrecap.app/screens/YNDDX1XYwK0/00-00-17.png)
![Screenshot at 00:35: The initial Zapier workflow structure generated by Copilot shows basic Trigger and Action blocks.](https://ss.rapidrecap.app/screens/YNDDX1XYwK0/00-00-35.png)
![Screenshot at 01:12: Configuration window for the Apify step, showing the selection of the 'ScrapeLatest3YouTubeVideos' action using the 'YouTube Scraper' actor.](https://ss.rapidrecap.app/screens/YNDDX1XYwK0/00-01-12.png)
![Screenshot at 01:42: Testing the webhook trigger by sending a sample payload containing the YouTube channel URL directly to the generated webhook URL.](https://ss.rapidrecap.app/screens/YNDDX1XYwK0/00-01-42.png)
![Screenshot at 02:36: The workflow is updated to include an 'AI by Zapier' step for analyzing video content and extracting keywords, following the initial scraping and looping steps.](https://ss.rapidrecap.app/screens/YNDDX1XYwK0/00-02-36.png)
![Screenshot at 03:55: Connecting the PostgreSQL service in Zapier, requiring host, port, database, schema, username, and password details.](https://ss.rapidrecap.app/screens/YNDDX1XYwK0/00-03-55.png)
![Screenshot at 04:21: ChatGPT generating the complex SQL schema definition for the 'video\_insights' table, including data types and indexes.](https://ss.rapidrecap.app/screens/YNDDX1XYwK0/00-04-21.png)
![Screenshot at 06:36: The final, fully functional 'Overpowered YouTube Intelligence Dashboard' displaying aggregated metrics from the synced data.](https://ss.rapidrecap.app/screens/YNDDX1XYwK0/00-06-36.png)