Automate YouTube Content Strategy with AI, Apify & Google Sheets

📌 Overview

This advanced multi-phase n8n workflow automates the complete research, analysis, and ideation pipeline for a YouTube strategist. It scrapes competitor channels, analyzes top-performing titles and thumbnails, identifies niche trends, gathers audience sentiment from comments, and produces data-driven content ideas—automatically writing them into a structured Google Sheets dashboard.

This system is ideal for:

YouTube creators Agencies Content strategists Automation engineers Anyone who wants to generate YouTube content ideas backed by real data

---

🧠 High‑Level Architecture

The workflow is split into 5 phases, each building on the previous:

Phase 1 — Niche Outliers (Input: User Form)