Find YouTube Content Gaps with Apify + n8n to Sheets

Find YouTube Content Gaps Every Monday—Automatically

This weekly n8n workflow uses Apify to scan YouTube for both your topics and competitor topics, identifies high-performing subjects your channel doesn’t cover, and appends the best gaps to Google Sheets—starting every Monday at 7:00.

What this workflow does

• Runs on a schedule: A scheduled trigger starts the workflow every Monday at 7:00.
• Defines your search strategy: You set yourQueries, rivalQueries, plus filtering thresholds like maxItems and minViews.
• Scrapes YouTube results with Apify: The workflow uses Apify’s YouTube Scraper actor to collect video results for both your queries and competitor queries.
• Compares competitor vs. your coverage: It reduces video titles to meaningful keywords, filters out low-view videos, and keeps only competitor subjects that don’t closely match your existing coverage.
• Ranks and exports: It sorts the remaining gaps by view count and appends the top results to your chosen `Google Sheets` tab.

Use cases

• SaaS operators & content teams: Build a weekly queue of YouTube topics competitors are getting views for—without duplicating what you already cover.
• Automation engineers: Validate gap-finding logic using real YouTube data and write results into a reporting sheet.
• n8n power users: Tune sensitivity by adjusting maxItems and minViews to match your niche.

Technical details

• Apify: Requires an Apify credential (API token) and the actor dami_studio~youtube-scraper.
• n8n integrations / nodes: set, code, slack, notion, sticky note, and google sheets.
• Output: Appends the top ranked YouTube content gaps into a specified Google Sheets spreadsheet and sheet tab.

Setup checklist

• Add your Apify credential and confirm the actor can run in your Apify account.
• Add your Google Sheets OAuth credential and select the target spreadsheet/tab.
• Update yourQueries, rivalQueries, maxItems, and minViews.