Hyrum Hurst This workflow corresponds to n8n.io template #12857 — we link there as the canonical source.
This workflow follows the Agent → Gmail 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 →
{
"id": "kCspNXfimNr6NzaZ",
"name": "Automated Consulting KPI Reporting with AI Insights and Threshold Alerts",
"tags": [],
"nodes": [
{
"id": "a278412b-15a6-4682-9406-3e7edac18deb",
"name": "Daily KPI Report Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
320,
288
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "fb46685c-d5d9-4cef-a2b4-848e258df807",
"name": "Workflow Configuration",
"type": "n8n-nodes-base.set",
"position": [
544,
288
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "25175165-9700-4099-bb40-2ce9b791d0f2",
"name": "Fetch Client Dashboard 1 KPIs",
"type": "n8n-nodes-base.httpRequest",
"position": [
784,
192
],
"parameters": {},
"typeVersion": 4.3
},
{
"id": "1e6781fa-99d8-4a90-8774-c300de51c64b",
"name": "Fetch Client Dashboard 2 KPIs",
"type": "n8n-nodes-base.httpRequest",
"position": [
816,
400
],
"parameters": {},
"typeVersion": 4.3
},
{
"id": "314f8de5-8ab1-48f5-a703-c4c0328e6abe",
"name": "Structure KPI Data",
"type": "n8n-nodes-base.set",
"position": [
992,
288
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "6e2833e5-1a77-47a4-9629-f3a8a580be90",
"name": "Log KPIs to Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1216,
288
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "45c2d4d9-8ac6-4db9-8c66-cc49fa08f127",
"name": "Generate KPI Summary and Insights",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1440,
288
],
"parameters": {},
"typeVersion": 3
},
{
"id": "2f82d728-5384-4561-8f75-0dafb6869153",
"name": "OpenAI GPT-4o-mini",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1512,
512
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "f9b70c3b-e3e7-4c3c-b5fa-bac24099642e",
"name": "Check Critical KPI Thresholds",
"type": "n8n-nodes-base.switch",
"position": [
1792,
288
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "70cc1443-d4c1-418e-a3f4-6bfcc9c02127",
"name": "Post Summary to Slack",
"type": "n8n-nodes-base.slack",
"position": [
2016,
0
],
"parameters": {},
"typeVersion": 2.4
},
{
"id": "1b8f72cd-0f14-4341-bbe4-1b207df5839e",
"name": "Send Critical Alert to Slack",
"type": "n8n-nodes-base.slack",
"position": [
2016,
384
],
"parameters": {},
"typeVersion": 2.4
},
{
"id": "d01ee5ac-efd4-4cd9-b3a9-67096820681a",
"name": "Email Full Report",
"type": "n8n-nodes-base.gmail",
"position": [
2016,
192
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "f10488e7-79ed-4611-aa1e-4cb937486cb4",
"name": "Email Critical Alert",
"type": "n8n-nodes-base.gmail",
"position": [
2016,
576
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "60c0fdd5-c09e-4ef0-b2f4-7f42539c83fe",
"name": "Consolidate All Branches",
"type": "n8n-nodes-base.merge",
"position": [
2240,
96
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "e676aef8-b238-41dd-a28d-979106f12604",
"name": "Schedule Follow-up Meeting",
"type": "n8n-nodes-base.googleCalendar",
"position": [
2464,
96
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "1595b0ac-331f-47ac-b31a-dee65d81ee52",
"name": "Final Logging and Formatting",
"type": "n8n-nodes-base.set",
"position": [
2688,
96
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "805a921f-b198-4f8e-a9de-5da33c8318b6",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
272,
48
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c6af6197-1463-4e0c-ab7a-b100178940d7",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
768,
48
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2ba62c31-50f6-4802-b79e-2f2643300e6e",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1424,
48
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "995453d5-2180-4031-ad77-053edf23d2dd",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1968,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d636a991-6460-4709-8133-66014c587f1f",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2400,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9067383b-2cbe-48c6-92fa-af90aabbb9bc",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
48
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "bee9dc25-3da8-4f13-baf0-eb823ba20faa",
"connections": {
"Email Full Report": {
"main": [
[
{
"node": "Consolidate All Branches",
"type": "main",
"index": 1
}
]
]
},
"OpenAI GPT-4o-mini": {
"ai_languageModel": [
[
{
"node": "Generate KPI Summary and Insights",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structure KPI Data": {
"main": [
[
{
"node": "Log KPIs to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Post Summary to Slack": {
"main": [
[
{
"node": "Consolidate All Branches",
"type": "main",
"index": 0
}
]
]
},
"Workflow Configuration": {
"main": [
[
{
"node": "Fetch Client Dashboard 1 KPIs",
"type": "main",
"index": 0
},
{
"node": "Fetch Client Dashboard 2 KPIs",
"type": "main",
"index": 0
}
]
]
},
"Consolidate All Branches": {
"main": [
[
{
"node": "Schedule Follow-up Meeting",
"type": "main",
"index": 0
}
]
]
},
"Daily KPI Report Trigger": {
"main": [
[
{
"node": "Workflow Configuration",
"type": "main",
"index": 0
}
]
]
},
"Log KPIs to Google Sheets": {
"main": [
[
{
"node": "Generate KPI Summary and Insights",
"type": "main",
"index": 0
}
]
]
},
"Schedule Follow-up Meeting": {
"main": [
[
{
"node": "Final Logging and Formatting",
"type": "main",
"index": 0
}
]
]
},
"Check Critical KPI Thresholds": {
"main": [
[
{
"node": "Send Critical Alert to Slack",
"type": "main",
"index": 0
},
{
"node": "Email Critical Alert",
"type": "main",
"index": 0
}
],
[
{
"node": "Post Summary to Slack",
"type": "main",
"index": 0
},
{
"node": "Email Full Report",
"type": "main",
"index": 0
}
]
]
},
"Fetch Client Dashboard 1 KPIs": {
"main": [
[
{
"node": "Structure KPI Data",
"type": "main",
"index": 0
}
]
]
},
"Fetch Client Dashboard 2 KPIs": {
"main": [
[
{
"node": "Structure KPI Data",
"type": "main",
"index": 0
}
]
]
},
"Generate KPI Summary and Insights": {
"main": [
[
{
"node": "Check Critical KPI Thresholds",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Author: Hyrum Hurst, AI Automation Engineer at QuarterSmart Contact: hyrum@quartersmart.com
Source: https://n8n.io/workflows/12857/ — 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.
Created by: Peyton Leveillee Last updated: October 2025
OpenAI Chat, Google Sheets, HTTP Request +5
This workflow automates end-to-end ESG (Environmental, Social, and Governance) sustainability reporting for enterprise sustainability teams, compliance officers, and green governance leads. It solves
Agent, OpenAI Chat, Output Parser Structured +12
Automates sales data analysis and strategic insight generation for sales managers and strategists needing actionable intelligence. Fetches multi-source data from sales, marketing, and financial system
HTTP Request, Agent, OpenAI Chat +6
Automatically discover, analyze, and report the most viral TikTok and Instagram videos in your niche every day. This workflow leverages AI and Apify to help you stay ahead of social media trends. Scra
HTTP Request, OpenAI Chat, Agent +3
This workflow automatically monitors competitor product prices on a scheduled basis, detects meaningful price changes, and delivers actionable alerts enriched with AI-powered competitive analysis.
HTTP Request, Google Sheets, Agent +3