Step-by-Step Implementation Guide

Configure the Manual Trigger

Set up the workflow to start on demand and define the initial list of search queries to run against YouTube.

1. Add Manual Launch Trigger as your starting node to run the workflow on demand.
2. In Assign Search Terms, add an array field named query and set it to {{["AI agents tutorial step by step","AI tools tutorial for beginners","AI agent building tutorial","AI prompt engineering techniques","best AI tools training","prompt engineering best practices"]}}.
3. In Expand Term List, set Field to Split Out to query to iterate each search term.

Connect YouTube

Configure YouTube API calls to find videos and fetch detailed statistics for each result.

1. Open YouTube Search Request and set URL to https://www.googleapis.com/youtube/v3/search.
2. In YouTube Search Request, set query parameters: part id,snippet, q {{ $json.query }}, type video, maxResults 50, order relevance, and videoCategoryId 27.
3. Credential Required: Connect your youTubeOAuth2Api credentials in YouTube Search Request.
4. In Expand Search Results, set Field to Split Out to items.
5. Open Fetch Video Details and set URL to https://www.googleapis.com/youtube/v3/videos with parameters part snippet,statistics and id {{ $json.id.videoId }}.
6. Credential Required: Connect your youTubeOAuth2Api credentials in Fetch Video Details.

Iterate Video Items outputs to both Eliminate Duplicate Clips and Fetch Video Details in parallel, so duplicates are handled while details are fetched.

Set Up Content Filtering and Scoring

Filter video titles for relevance, apply quality thresholds, map fields, remove duplicates, and compute a relevance score for ranking.

1. In Relevance Content Filter, keep the title checks using {{ $json.snippet.title.toLowerCase() }} with the regex and not-regex rules for educational and anti-monetization keywords.
2. In Quality Metrics Filter, verify the conditions: viewCount {{ $json.items[0].statistics.viewCount }} > 10000, likeCount {{ $json.items[0].statistics.likeCount }} > 100, and publishedAt {{ $json.items[0].snippet.publishedAt }} after 2023-12-01T00:00:00.
3. In Map Output Fields, map fields to: Title {{ $json.items[0].snippet.title }}, Channel {{ $json.items[0].snippet.channelTitle }}, Published At {{ $json.items[0].snippet.publishedAt }}, Views {{ $json.items[0].statistics.viewCount }}, Likes {{ $json.items[0].statistics.likeCount }}, Description {{ $json.items[0].snippet.description }}, and URL https://www.youtube.com/watch?v={{ $json.items[0].id }}.
4. In Eliminate Duplicate Clips, set Compare to {{ $json.URL }}.
5. In Compute Relevance Score, set RelevanceScore to the provided multi-line scoring expression that evaluates tutorial keywords, AI terms, and quality indicators.
6. In Rank by Relevance, sort by RelevanceScore in descending order.
7. In Apply Result Limit, set Max Items to 50.

Configure Google Sheets Output

Append the final ranked results to your Google Sheet after a brief delay to avoid rate limits.

1. In Delay Processing, set Amount to 3 to pause before writing results.
2. Open Append to Sheets and set Operation to append.
3. Set the Document to [YOUR_ID] (YouTube AI Resources) and the Sheet to gid=[YOUR_ID] (Sheet1).
4. Map columns in Append to Sheets: URL {{ $json.URL }}, Likes {{ $json.Likes }}, Title {{ $json.Title }}, Views {{ $json.Views }}, Channel {{ $json.Channel }}, Description {{ $json.Descriptoin }}, and Published At {{ $json['Published at'] }}.
5. Credential Required: Connect your googleSheetsOAuth2Api credentials in Append to Sheets.

Test and Activate Your Workflow

Run a manual test to verify YouTube results are filtered, scored, and appended to your sheet.

1. Click Execute Workflow starting from Manual Launch Trigger to run a test.
2. Confirm that Relevance Content Filter and Quality Metrics Filter only pass valid educational videos.
3. Verify that Append to Sheets adds rows with URLs, title, channel, stats, and published date.
4. Once validated, toggle the workflow to Active for production use.