Find YouTube content gaps with Apify, Google Sheets, Notion, and Slack

Quick overview

This weekly workflow uses Apify to run two YouTube searches (your topics and competitor topics), compares the resulting video titles to find high-performing subjects competitors cover that you don’t, and appends the best gaps to Google Sheets.

How it works

1. Runs every Monday at 7:00 via a scheduled trigger.
2. Defines your search queries, competitor search queries, and filtering thresholds (maximum items and minimum view count).
3. Uses Apify’s YouTube Scraper actor to collect video results for your queries and for competitor queries.
4. Compares both result sets by reducing titles to meaningful keywords, filters out low-view videos, and keeps only competitor subjects that don’t closely match your existing coverage.
5. Sorts the remaining gaps by view count and appends the top results to a Google Sheets spreadsheet.

Setup

1. Add an Apify credential (API token) and ensure you can run the dami_studio~youtube-scraper actor in your Apify account.
2. Add a Google Sheets OAuth credential and select the target spreadsheet and sheet tab in the append step.
3. Update yourQueries, rivalQueries, maxItems, and minViews to match your niche and desired sensitivity.