Analyze daily metrics with multi-agent GPT-4o, Google Sheets, Slack and Gmail

Description

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 specialised sub-agents under a central Planning Agent. Each agent handles a distinct function: metrics computation, trend analysis, alert detection, and report generation. The Planning Agent coordinates task delegation via chat memory, ensuring contextual continuity across agent calls. Raw metrics are read from Google Sheets, processed through a Calculator and Trend Analysis Code Tool, and anomalies trigger Slack alerts in real time. A Structured Output Parser formats the consolidated findings, which are appended back to Google Sheets and simultaneously dispatched via Gmail and Slack. This end-to-end pipeline replaces fragmented manual workflows, delivering consistent, timely insights with full audit trails.

Setup Steps
Connect a Schedule Trigger node for daily execution frequency.
Add OpenAI credentials to the Planning Agent Model and all sub-agent models.
Configure Google Sheets node with OAuth2;
Set up Slack credentials; assign correct channel in Slack Alert Tool and Post Summary nodes.
Add Gmail credentials to the Gmail Report Tool node; set recipient address.

Prerequisites
Google Sheets OAuth2 credentials
Slack Bot Token with post permissions
Gmail OAuth2 credentials
Use Cases
Daily sales or operational KPI monitoring for business teams
Customization
Swap OpenAI models per agent for cost/performance tuning
Benefits
Eliminates manual daily reporting effort
Real-time alerts reduce response time to anomalies