Fetch & combine historical data
When a training session form is submitted, the workflow stores the new record in Google Sheets, then fetches all prior historical records for that athlete. Current and historical data are combined into one dataset.
Back to Portfolio
Case study · AI performance automation
AI Athlete Performance Tracking & Weekly Reporting Automation
A full n8n AI automation system for sports coaching — logs training sessions to Google Sheets, uses OpenAI to analyse performance against historical data, checks performance thresholds, sends real-time Slack and email alerts, and delivers weekly per-athlete summaries automatically.
AIPerformance Analysis
AutoWeekly Reports
Real-TimeSlack + Email Alerts
ZeroManual Reporting
The project
Performance data turned into useful coaching context.
Coaching teams managing multiple athletes face a constant challenge — tracking individual performance over time, spotting when an athlete needs attention, and generating consistent weekly reports without spending hours on manual data work.
This n8n automation handles the entire pipeline — from logging a training session to delivering a full weekly performance summary to the coaching team via Slack and email. OpenAI GPT acts as the analysis engine, interpreting performance data against historical records and generating actionable insights automatically.
Workflow evidence · data ingestion, AI analysis, threshold checking, and weekly reporting
The 4 automation phases
From session entry to weekly visibility.
The original project is structured around four connected phases that give coaches current context, immediate alerts, and consistent reporting.
Performance Analysis Agent
An OpenAI-powered Performance Analysis Agent processes the combined data — identifying trends, comparing session metrics, and generating written insights. Results are written back to Google Sheets automatically.
Check performance threshold
A threshold check evaluates whether the athlete's metrics breach predefined limits. Breaches send an immediate Slack alert; otherwise, a standard email alert is sent.
Weekly summary & distribution
A scheduled trigger fetches weekly training data, groups records by athlete, and passes each group to a Weekly Summary Agent. Summaries are sent to Slack and email automatically.
Tools & integrations
Connected to the tools the coaching team already uses.
n8nOpenAI GPTGoogle SheetsSlackEmailTraining Session FormAI Analysis AgentWeekly Summary AgentSchedule TriggerThreshold LogicGroup by AthleteOutput Parser
“This system completely changed how we track athlete performance. Our coaches used to spend hours every week compiling reports manually. Now everything is automated — the AI catches performance issues before we even notice them.”Client — AI Athlete Performance Automation · n8n + OpenAI + Google Sheets + Slack
Build your next system
Need an AI automation like this?
I build end-to-end n8n automations that eliminate manual reporting and analysis — powered by OpenAI, connected to your existing tools, and running automatically in the background.