Triage YouTube comments and track video health with Apify and Google Sheets
UnknownWhat this workflow does
This workflow has 22 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets and Apify (community).
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Read videos to monitor (Google Sheets): uses Google Sheets
- Read entire watchlist (Google Sheets): uses Google Sheets
- Skip chronically-failing videos (Filter): keeps only the items that match a condition
- Find failing 7+ days (Filter): keeps only the items that match a condition
- Find chronically_failing to retry (Filter): keeps only the items that match a condition
- Collect videos into one list (Aggregate): combines items into one
- Escalate to chronically_failing (Google Sheets): update
- Give fresh retry (Google Sheets): update
- Fetch comments (Apify): run actor and get dataset
- Triage comments (Switch): routes items into 3 branches
…plus 10 more steps. See the full node list below.
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 Fetch comments).
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Apify
@apify/n8n-nodes-apify.apify - Switch
n8n-nodes-base.switch - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - Merge
n8n-nodes-base.merge - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This workflow monitors a Google Sheets watchlist of YouTube video URLs, uses Apify’s YouTube Comments Downloader actor to fetch recent comments, and writes only high-engagement comments, question comments, and fetch failures back to Google…