Discover YouTube channels from keywords and save leads to Google Sheets
UnknownWhat this workflow does
This workflow has 12 nodes and runs on a schedule (cron * * * * *). Along the way it connects Google Sheets and Apify (community). It also calls googleapis.com over HTTP.
How it runs
Trigger: On a schedule (cron * * * * *).
- List of Target Keywords (Google Sheets): uses Google Sheets
- Get the first keyword (Code): runs custom JavaScript code
- Update Keyword Status -> Processing (Google Sheets): append or update
- Search Videos based on Keywords (HTTP Request): calls googleapis.com
- Extract Channel Ids from the Video Results (Code): runs custom JavaScript code
- Get Channel Stats (HTTP Request): calls googleapis.com
- Filter based on Criteria (Code): runs custom JavaScript code
- Append or update row in sheet (Google Sheets): append or update
- Run an Actor and get dataset (Apify): run actor and get dataset
- Code: runs custom JavaScript code
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: googleapis.com
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 Run an Actor and get dataset).
Nodes used (5)
- Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Apify
@apify/n8n-nodes-apify.apify - HTTP Request
n8n-nodes-base.httpRequest
From the author
This workflow automatically searches YouTube Data API for videos related to specific keywords, extracts channel data, filters channels based on performance metrics, and saves the results into Google Sheets. Instead of manually searching YouTube and copying…