Analyze daily metrics with multi-agent GPT-4o, Google Sheets, Slack and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 20 nodes and runs on a schedule (every day at 09:00). Along the way it connects OpenAI Chat Model, Google Sheets, Slack and Gmail.
How it runs
Trigger: On a schedule (every day at 09:00).
- Planning Agent (AI Agent): runs an AI agent, with model: Planning Agent Model; 4 tools (Alerts Agent Tool, Metrics Agent Tool, Insights Agent Tool, Reporting Agent Tool); output parser: Structured Output Parser
- Format Final Output (Edit Fields (Set)): sets 6 fields: timestamp, metricsAnalysis, insights…
- Store Analysis Results (Google Sheets): append
- Post Summary to Slack (Slack): uses Slack
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 (13)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - AI Agent Tool
@n8n/n8n-nodes-langchain.agentTool - Calculator
@n8n/n8n-nodes-langchain.toolCalculator - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Code Tool
@n8n/n8n-nodes-langchain.toolCode - Slack Tool
n8n-nodes-base.slackTool - Gmail Tool
n8n-nodes-base.gmailTool - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack
From the author
How It Works This workflow automates daily business metrics collection, analysis, and reporting using a multi-agent AI architecture in n8n. Designed for operations teams, analysts, and business managers, it eliminates manual data review by orchestrating four…