YouTube comment scraper & analyzer with GPT-4o + email summary report
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs on Google Sheets events. Along the way it connects OpenAI Chat Model, YouTube, Gmail and Google Sheets. It also calls googleapis.com over HTTP.
How it runs
Trigger: On Google Sheets events.
- If: checks a condition and branches into true / false
- Limit: keeps the first few items
- Set Video Details (Edit Fields (Set)): sets 2 fields: videoId, maxComments
- Get Youtube Video Details (YouTube): get (video)
- Get Youtube Video Comments (HTTP Request): calls googleapis.com
- Prepare Comments Data (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: OpenAI Chat Model
- Prepare HTML for Email (Code): runs custom JavaScript code
- Gmail: uses Gmail
- Update Status on Google Sheet (Google Sheets): update
Services it uses
HTTP calls to: googleapis.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (11)
- Limit
n8n-nodes-base.limit - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - YouTube
n8n-nodes-base.youTube - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger
From the author
How it Works This workflow automates the collection and analysis of YouTube comments from a video and sends a summary report via email, using Google Sheets, the YouTube API, OpenAI (GPT-4o), and Gmail. Whether you're a content creator, brand manager, or…