# YouTube channel monitor with Video Stats: n8n workflow template

> Started by a clock, and works across Google Sheets. It hands the judgement calls to Gemini.

Source: https://millionrounds.com/workflow/youtube-channel-monitor-with-video-stats (Millionrounds; every figure on the page links to its filing or article)

[Automation library](https://millionrounds.com/workflows) · [Alerts and monitoring](https://millionrounds.com/workflows?category=Alerts+and+monitoring#library)

# YouTube channel monitor with Video Stats

Started by a clock, and works across Google Sheets. It hands the judgement calls to Gemini. 32 steps, 5 branches, 6 loops or waits: large, and worth reading before you trust it with anything live.

Large Calls a model: Gemini

[Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fyoutube-channel-monitor-with-video-stats)

**32 steps** Large: read it before trusting it with anything live

**5** Branches: places the flow splits

**6** Loops or waits

**1** Service it connects to

## The flow

Starts it 1 Model 3 Logic 19 Service 9

The steps in the order they run, from what starts it.

- 1 **Structured Output Parser1** Output Parser Structured *Model*
- 2 **Google Gemini Chat Model13** Lm Chat Google Gemini *Model*
- 3 **Schedule Trigger** Schedule trigger *Starts it*
- 4 **youtube video summariser** Chain Llm *Model*
- 5 **Get row(s) in sheet** Google Sheets *Service*
- 6 **Append or update row in sheet** Google Sheets *Service*
- 7 **Split into individual links** Code *Logic*
- 8 **Wait 70 sec for next video** Wait *Logic*
- 9 **check if youtube link** If *Logic*
- 10 **Loop Over Videos** Split In Batches *Logic*
- 11 **Loop Over channels** Split In Batches *Logic*
- 12 **End** Set *Logic*
- 13 **Video Data and criteria** Set *Logic*
- 14 **If4** If *Logic*
- 15 **Set channel and API** Set *Logic*
- 16 **Get row(s) in sheet1** Google Sheets *Service*
- 17 **Append or update row in sheet1** Google Sheets *Service*
- 18 **Get Channel ID1** Http Request *Service*
- 19 **if not exist in sheet?** If *Logic*
- 20 **Get channel stats** Http Request *Service*
- 21 **Youtube Transcriber Gemini** Http Request *Service*
- 22 **Wait** Wait *Logic*
- 23 **Get candidate videos** Http Request *Service*
- 24 **If transcript exists** If *Logic*
- 25 **Split Out** Split Out *Logic*
- 26 **Edit Fields1** Set *Logic*
- 27 **Wait 85 sec on fail** Wait *Logic*
- 28 **Last 30 days** Filter *Logic*
- 29 **Get baseline video stats** Http Request *Service*
- 30 **video details** Set *Logic*
- 31 **If title?** If *Logic*
- 32 **Wait 2 sec** Wait *Logic*

## How it's built

- **Starts on:** A clock
- **Steps:** 32, with 5 branches, 6 loops or waits
- **Size:** Large: read it before trusting it with anything live
- **Connects to:** Google Sheets
- **Model:** Gemini

## Questions

What does it need to run?

An n8n account, plus your own Google Sheets account, and a key for Gemini. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

Yes. It calls Gemini. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 32 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

**Before you run it**

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 32 steps before you point it at anything that matters.

## Run it in n8n

- **Create your n8n account** Free to start. n8n is where the workflow runs. [Create an n8n account ↗](https://millionrounds.com/n8n)
- **Download the workflow** Free with a Millionrounds account. [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fyoutube-channel-monitor-with-video-stats)
- **Paste it into n8n** Open a new workflow in n8n and paste. Then connect your own accounts.

Stored with the author's traces removed: canvas notes, instance identifiers, saved credential names and any live document they had left behind.

## Connects to

Each opens the other workflows that use it.

[Google Sheets](https://millionrounds.com/workflows?service=Google+Sheets#library)

## Workflows like it

Also alerts and monitoring, with the same services where possible, closest in size first.

- [**Automate ESG carbon monitoring and strategy execution** 32 steps · calls a model · Email, Google Sheets](https://millionrounds.com/workflow/automate-esg-carbon-monitoring-and-strategy-execution)
- [**Monitor and optimize carbon emissions for ESG with OpenAI** 32 steps · calls a model · Email, Google Sheets](https://millionrounds.com/workflow/monitor-and-optimize-carbon-emissions-for-esg-with-openai)
- [**Automate delivery confirmation with Telegram Bot** 32 steps · Gmail, Google Drive](https://millionrounds.com/workflow/automate-delivery-confirmation-with-telegram-bot)
- [**Receive Meta Ads ad account webhooks, log** 32 steps · Google Sheets, Slack](https://millionrounds.com/workflow/receive-meta-ads-ad-account-webhooks-log)
- [**Reply to Instagram comments with Groq and Telegram** 32 steps · Google Sheets, Telegram](https://millionrounds.com/workflow/reply-to-instagram-comments-with-groq-and-telegram)
- [**Score property deals, alert investors, and log CRM KPIs** 31 steps · Email, Google Sheets](https://millionrounds.com/workflow/score-property-deals-alert-investors-and-log-crm-kpis)