Rahul Joshi This workflow corresponds to n8n.io template #8167 — we link there as the canonical source.
This workflow follows the Agent → Emailsend recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"id": "12b5b00a-6001-45bf-859e-5c2b257dcab0",
"name": "Sending report via email",
"type": "n8n-nodes-base.emailSend",
"position": [
2112,
128
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "968f662d-cee2-471a-bdac-82b61d2f4a78",
"name": "Creating Email",
"type": "n8n-nodes-base.code",
"position": [
1824,
128
],
"parameters": {},
"typeVersion": 2
},
{
"id": "c7059c42-2d43-4557-80ca-acaf8c53fd28",
"name": "Creating Analysis",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1376,
128
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "4d02cf88-8091-46a9-9de4-d08990f0fcef",
"name": "Formatting Data",
"type": "n8n-nodes-base.code",
"position": [
1152,
128
],
"parameters": {},
"typeVersion": 2
},
{
"id": "9ba90e49-e76b-4a5c-8b33-2fabe4a3e554",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
2016,
368
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "60b2a151-9d69-4a16-b31c-e85a6df529da",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1776,
-304
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "772c89ac-7ca4-4fe2-8ab2-16648d974816",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1328,
480
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "23565517-1526-4c9c-8a88-00183d0b7616",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1392,
-304
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f26bd60a-cc9b-4297-9636-d56ebb1ed3c2",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1072,
-176
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3e8c9dc0-9740-408b-9313-45d251a9cd9b",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
848,
336
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "35b1c8c3-d5e2-4915-8d7b-4837d80db850",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
624,
-336
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "39281538-83a8-4686-bee1-380ace24dba0",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
384,
336
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7c69eb73-fb88-412c-baa8-8ec143fd36e9",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
-288
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "dff02713-98de-40c4-bf82-8e6c3e5293c5",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1535cbe4-0963-43ab-a5c4-28103ce562f3",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
448,
128
],
"parameters": {},
"typeVersion": 3
},
{
"id": "fb553ab6-9166-4d87-95a8-98d9faf6560a",
"name": "Comments segergation",
"type": "n8n-nodes-base.code",
"position": [
944,
128
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a89c606e-c276-4787-877a-f5a51bfa7697",
"name": "Azure OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
1376,
320
],
"parameters": {},
"typeVersion": 1
},
{
"id": "31ef09fc-9291-4eac-a01f-94566b30a606",
"name": "Content extraction",
"type": "n8n-nodes-base.httpRequest",
"position": [
704,
128
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "bab393a2-1232-4c0e-9f15-3074b3ab9d19",
"name": "Get row(s) in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
224,
128
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "14a1b5d5-146f-4b5e-9d2b-e01ee486de04",
"name": "When clicking \u2018Execute workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
128
],
"parameters": {},
"typeVersion": 1
}
],
"connections": {
"Creating Email": {
"main": [
[
{
"node": "Sending report via email",
"type": "main",
"index": 0
}
]
]
},
"Formatting Data": {
"main": [
[
{
"node": "Creating Analysis",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Content extraction",
"type": "main",
"index": 0
}
]
]
},
"Creating Analysis": {
"main": [
[
{
"node": "Creating Email",
"type": "main",
"index": 0
}
]
]
},
"Content extraction": {
"main": [
[
{
"node": "Comments segergation",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Comments segergation": {
"main": [
[
{
"node": "Formatting Data",
"type": "main",
"index": 0
}
]
]
},
"Azure OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Creating Analysis",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Sending report via email": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Automate YouTube channel analysis by fetching channel data, generating a key metrics table and actionable insights using Azure OpenAI (GPT-4o-mini), and delivering the results via email. Integrates YouTube Data API (RapidAPI), Google Sheets, and Gmail/SMTP for seamless…
Source: https://n8n.io/workflows/8167/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
K&S-Media Downloadliste SQL. Uses httpRequest, agent, googleSheets, lmChatOpenAi. Event-driven trigger; 97 nodes.
This workflow is designed for marketers, content creators, agencies, and solo founders who want to publish long‑form posts with visuals on autopilot using n8n and AI agents.
This is a Telegram AI-to-Human Handover System that seamlessly transitions customer support conversations between an AI agent and human operators: AI-First Response: When users message the Telegram bo
Description:
Automate dress image handling end-to-end: search files, download them, upload to Cloudinary, invoke Azure OpenAI (GPT-4o), parse structured output, and append rows to a sheet. Gain a repeatable, low-t