Analyze YouTube channels & send performance reports with GPT-4o-mini and Gmail
Ready for 3.0What this workflow does
This AI workflow has 10 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Azure OpenAI Chat Model and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Content extraction (HTTP Request): calls an HTTP API
- Comments segergation (Code): runs custom JavaScript code
- Formatting Data (Code): runs custom JavaScript code
- Creating Analysis (AI Agent): runs an AI agent, with model: Azure OpenAI Chat Model
- Creating Email (Code): runs custom JavaScript code
- Sending report via email (Send Email): sends an email over SMTP
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Send Email
n8n-nodes-base.emailSend - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
Analyze YouTube Channels & Email Actionable Insights with GPT-4o-mini, RapidAPI, and Gmail Description Automate YouTube channel analysis by fetching channel data, generating a key metrics table and actionable insights using Azure OpenAI (GPT-4o-mini), and…