{"product_id":"find-youtube-content-gaps-with-apify-n8n-to-sheets","title":"Find YouTube Content Gaps with Apify + n8n to Sheets","description":"\u003ch3\u003eFind YouTube Content Gaps Every Monday—Automatically\u003c\/h3\u003e\n\u003cp\u003eThis weekly n8n workflow uses \u003cstrong\u003eApify\u003c\/strong\u003e to scan YouTube for both your topics and competitor topics, identifies high-performing subjects your channel doesn’t cover, and \u003cstrong\u003eappends the best gaps to Google Sheets\u003c\/strong\u003e—starting every Monday at 7:00.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e A scheduled trigger starts the workflow every Monday at 7:00.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDefines your search strategy:\u003c\/strong\u003e You set \u003cstrong\u003eyourQueries\u003c\/strong\u003e, \u003cstrong\u003erivalQueries\u003c\/strong\u003e, plus filtering thresholds like \u003cstrong\u003emaxItems\u003c\/strong\u003e and \u003cstrong\u003eminViews\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapes YouTube results with Apify:\u003c\/strong\u003e The workflow uses Apify’s \u003cstrong\u003eYouTube Scraper actor\u003c\/strong\u003e to collect video results for both your queries and competitor queries.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompares competitor vs. your coverage:\u003c\/strong\u003e 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.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRanks and exports:\u003c\/strong\u003e It sorts the remaining gaps by view count and appends the top results to your chosen `Google Sheets` tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operators \u0026amp; content teams:\u003c\/strong\u003e Build a weekly queue of YouTube topics competitors are getting views for—without duplicating what you already cover.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers:\u003c\/strong\u003e Validate gap-finding logic using real YouTube data and write results into a reporting sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n power users:\u003c\/strong\u003e Tune sensitivity by adjusting \u003cstrong\u003emaxItems\u003c\/strong\u003e and \u003cstrong\u003eminViews\u003c\/strong\u003e to match your niche.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify:\u003c\/strong\u003e Requires an Apify credential (API token) and the actor \u003cstrong\u003edami_studio~youtube-scraper\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n integrations \/ nodes:\u003c\/strong\u003e \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, \u003cstrong\u003enotion\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, and \u003cstrong\u003egoogle sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOutput:\u003c\/strong\u003e Appends the top ranked YouTube content gaps into a specified Google Sheets spreadsheet and sheet tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup checklist\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAdd your \u003cstrong\u003eApify\u003c\/strong\u003e credential and confirm the actor can run in your Apify account.\u003c\/li\u003e\n  \u003cli\u003eAdd your \u003cstrong\u003eGoogle Sheets OAuth\u003c\/strong\u003e credential and select the target spreadsheet\/tab.\u003c\/li\u003e\n  \u003cli\u003eUpdate \u003cstrong\u003eyourQueries\u003c\/strong\u003e, \u003cstrong\u003erivalQueries\u003c\/strong\u003e, \u003cstrong\u003emaxItems\u003c\/strong\u003e, and \u003cstrong\u003eminViews\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45931046535347,"sku":"N8N-18963","price":11.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/gv2gHlaJcFGWa0lm3M1uv_Q6CSkRhU.png?v=1788254055","url":"https:\/\/buyflowscripts.com\/products\/find-youtube-content-gaps-with-apify-n8n-to-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}