Find YouTube content gaps with Apify, Google Sheets, Notion, and Slack
UnknownWhat this workflow does
This workflow has 8 nodes and runs on a schedule (cron 0 7 * * 1). Along the way it connects Google Sheets, Notion, Slack and Apify (community).
How it runs
Trigger: On a schedule (cron 0 7 * * 1).
- Your topic and theirs (Edit Fields (Set)): sets 4 fields: yourQueries, rivalQueries, maxItems…
- What you already cover (Apify): run actor and get dataset (actors)
- What they cover (Apify): run actor and get dataset (actors)
- Find what is missing (Code): runs custom JavaScript code
- Log the gaps (Google Sheets): append
- Optional: keep them as Notion ideas (Notion): create (database page)
- Optional: post the gap list to Slack (Slack): uses Slack
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in What you already cover, What they cover).
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Apify
@apify/n8n-nodes-apify.apify - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Notion
n8n-nodes-base.notion - Slack
n8n-nodes-base.slack
From the author
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.…