YouTube Trend Monitoring and Video Data Management Workflow

This n8n workflow automates the process of tracking trending YouTube videos based on keywords, scraping relevant video data via Apify, processing video captions, and storing comprehensive details in Airtable for analysis. It is designed to regularly monitor YouTube trends, gather detailed video information, and generate summarized content for further insights.

The workflow begins with a scheduled trigger, prompting users to set keywords for their niche. It then creates a dataset of YouTube videos filtered by relevance using Apify’s YouTube scraper API. The process waits until the dataset is ready and retrieves the latest video data. For each video, it performs subtitle extraction, cleans the caption text, and uses a language model to generate a concise summary.

Throughout, the workflow uploads video details, including links, titles, channel info, engagement metrics, and the subtitles’ summary into Airtable. Additional sticky notes provide setup instructions and field details, making it easier for users to customize and expand this automation. This workflow is valuable for content creators, digital marketers, or researchers who want automated trend tracking, data collection, and content summarization, streamlining YouTube content analysis.