{"product_id":"youtube-comment-triage-in-n8n-apify-google-sheets","title":"YouTube Comment Triage in n8n: Apify + Google Sheets","description":"\u003ch3\u003eAuto-triage YouTube comments from a Google Sheets watchlist—powered by Apify in n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors a Google Sheets list of YouTube video URLs, pulls recent comments via Apify, and writes back only the most valuable signals—high-engagement comments, questions, and fetch failures—while tracking video health and producing a per-run audit log.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eBuilt for comment management and channel health monitoring, it:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003eRuns manually (and can be switched to a schedule) to read a YouTube video watchlist from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSkips videos marked \u003cstrong\u003echronically failing\u003c\/strong\u003e, batches the remaining URLs, and prepares a single list for processing.\u003c\/li\u003e\n  \u003cli\u003eCalls the Apify actor \u003cstrong\u003ecleanfeed\/youtube-comments-downloader\u003c\/strong\u003e to fetch up to \u003cstrong\u003e100 comments per video\u003c\/strong\u003e, returning one item per comment (or a per-fetch failure item).\u003c\/li\u003e\n  \u003cli\u003eFilters results to keep only:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003efetch failures\u003c\/strong\u003e,\u003c\/li\u003e\n      \u003cli\u003ecomments with \u003cstrong\u003e10+ likes\u003c\/strong\u003e, and\u003c\/li\u003e\n      \u003cli\u003equestion-like comments (contains “?” but not “http”).\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eAppends or updates flagged outcomes in Google Sheets using an \u003cstrong\u003eappend-or-update\u003c\/strong\u003e approach keyed by \u003cstrong\u003evideo URL\u003c\/strong\u003e or \u003cstrong\u003ecomment ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSummarizes per-video fetch health and updates the watchlist by marking videos as failing (with a timestamp) or clearing the failing status on success.\u003c\/li\u003e\n  \u003cli\u003eCounts flagged outcomes and health changes across the run, then appends a single row to a \u003cstrong\u003eGoogle Sheets run log\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eRuns \u003cstrong\u003emonthly\u003c\/strong\u003e to escalate videos failing for \u003cstrong\u003e7+ days\u003c\/strong\u003e to \u003cstrong\u003echronically_failing\u003c\/strong\u003e, and clears that status for a one-time retry.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomatically surface the most actionable YouTube comments (questions + highly liked) to your team in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eTrack data pipeline reliability by logging comment fetch failures per video and escalating persistent issues.\u003c\/li\u003e\n  \u003cli\u003eRun scheduled YouTube comment triage for SaaS operators managing multiple channels and video watchlists.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow automation\u003c\/strong\u003e using nodes such as \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, \u003cstrong\u003eaggregate\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eApify integration via the community node \u003cstrong\u003e@apify\/n8n-nodes-apify\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eApify actor: \u003cstrong\u003ecleanfeed\/youtube-comments-downloader\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eGoogle Sheets read\/write for the video watchlist, flagged comments\/failures, and an audit run log.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978889617587,"sku":"N8N-19370","price":45.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ZkYgDJTCsBLPLSr_LSwY0_argMtejH.png?v=1788858347","url":"https:\/\/buyflowscripts.com\/products\/youtube-comment-triage-in-n8n-apify-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}