Back to workflows
  • Web Scraping
  • Data Processing & Analysis
  • Videos

YouTube Content Strategy Analysis and Optimization Tool

Analyzes YouTube channels and videos to extract successful title patterns, thumbnail strategies and audience insights. Automatically generates optimized video ideas based on competitor research and comment analysis.

  • 564 Number of downloads
  • 13 min Estimated setup time
  • 48 Number of nodes
Trigger

Submit Channels

The workflow starts when the Niche Outliers form is submitted with the following channel URLs:

  • Channel 1
  • Channel 2
  • Channel 3
Actions
  • Scrape each channel for high-performing videos and collect basic metrics.
  • Detect persuasive power-words in video titles using AI.
  • Evaluate thumbnail visuals to understand click-driving elements.
  • Save titles, metrics, power-words and thumbnail notes to Google Sheets logs.
  • Aggregate insights, analyse audience comments and create three new title & thumbnail ideas.
Result
Input Output
Clear insights and fresh video ideas ready in your spreadsheet.

Integrations

Everything you need to get started

API Key
OpenAI AI

Multiple nodes call OpenAI to extract power-words from titles, analyse thumbnails, summarise comments and generate fresh video ideas.

OAuth2
Google Sheets Spreadsheets

Stores every analysis result — outliers, weekly and daily stats, comment insights and ideation output — into several tabs, and reads high-performing rows.

API Key
Apify Web Scraping

HTTP Request nodes hit Apify actors to scrape YouTube channel and video data, which feeds the downstream AI analysis.

Setup

Setup instructions

Get your workflow up and running in minutes with these simple steps.

1

Prerequisites

You'll need an Eliassdevland n8n hosting plan, an OpenAI account, a Google account with Sheets access, and an Apify account.

2

Add your OpenAI credentials

In n8n go to Credentials → OpenAI API → New. Paste your OpenAI secret key and save. All OpenAI and LangChain-OpenAI nodes will automatically use this credential once selected from the Credentials dropdown.

3

Connect Google Sheets

Create a new Google Sheets (OAuth2) credential (Credentials → New → Google Sheets). Authorise with the Google account that owns or can edit the target spreadsheet. Then open every Google Sheets node and choose this credential in the Credentials field.

4

Insert your Apify API token

Open each HTTP Request node that calls api.apify.com. In the Headers section, replace the existing "Authorization: Bearer …" value with "Bearer YOUR_APIFY_TOKEN" and save the node.

5

Point the workflow to your own spreadsheet

Copy the Google Sheet template or use an existing sheet. In every Google Sheets node, replace the Spreadsheet and Sheet values with the ID and tab names of your document. Keep the column headers identical or adjust the mapping accordingly.

6

Adjust scheduling times

Open the two Schedule Trigger nodes (one weekly, one daily) and change the day, hour or frequency to match when you want YouTube data collected.

7

Preset your niche and competitor channels

Update the Set nodes titled "Niche" and "Broad Niche" with the keyword you want to track, and edit the placeholders in the Form Trigger so your team can enter up to three competitor channel URLs.

8

Tweak AI model settings

Inside any LangChain or OpenAI node you can change the model name, max-token limit or system prompt to suit your tone or budget.

9

Activate the workflow

Click Save, then switch the workflow from Draft to Active. It will now run whenever someone submits the web form, every Sunday at 5 AM, and every day at 8 AM according to the three built-in triggers.

Keep exploring

More workflows like this

Discover complementary automations to supercharge your productivity.

546

AI Product Photo to Video Generator

Converts product photos into professional marketing videos using AI analysis and video generation. Users upload a photo and receive a ready-to-share clip.

  • Videos
  • Content Creation
  • Data Processing & Analysis
Use workflow
410

AI Generated Faceless YouTube Shorts Creator

Creates viral short-form videos by generating script ideas, researching content and automatically producing faceless videos with AI voiceovers and visuals.

  • Content Creation
  • Videos
  • Messaging
Use workflow

n8n workflow library

Frequently asked

How do I import a workflow from this library?

Import the JSON into n8n: open Workflows → Import, paste the JSON or upload the file, then review the credentials and activate.

Are all workflows free to use?

Yes, the templates are free to use and adapt unless otherwise noted.

What if I need help setting up a workflow?

Check the setup instructions on each workflow page, or reach out to us on WhatsApp — share your workflow ID and any logs so we can help faster.

How can I submit my own workflow?

Export it from n8n as JSON and send it over. Include the steps and the credentials used so we can document it properly.

Do I need technical skills to use these workflows?

Basic familiarity helps, but most templates come with instructions and can be adapted visually.

Can I modify downloaded workflows?

Absolutely — every workflow can be customized to fit your needs. We're happy to help with any adjustments.

Still have questions?

We can help you get this workflow running.

Need a hand with setup, or want this automation tailored to your business? Reach out and we'll take it from here.