Track athlete sessions and weekly performance with OpenAI, Google Sheets, Slack, and email

Description

How It Works
This workflow automates athlete performance monitoring through two parallel pipelines: real-time session analysis triggered by training form submissions, and scheduled weekly performance summaries. Designed for sports coaches, athletic trainers, and performance analysts, it eliminates manual data aggregation and ensures threshold breaches and weekly trends are communicated instantly. A training session form submission stores the record to Google Sheets, fetches historical data, and combines both inputs for a Performance Analysis Agent. OpenAI analyses the combined data, updates the sheet with insights, then checks performance thresholds—triggering Slack alerts or email notifications on breach. In parallel, a weekly schedule fetches all athlete data, groups by athlete, and passes to a Weekly Summary Agent that distributes summaries via both Slack and email.

Setup Steps
Configure Training Session Form fields to match athlete and session data schema.
Connect Google Sheets credentials to Store, Fetch, and Update Record nodes.
Add OpenAI API credentials to Performance Analysis and Weekly Summary Agent nodes.
Configure Slack credentials and set coaching team alert and summary channels.
Add Gmail/SMTP credentials to Send Email Alert and Weekly Summary Email nodes.
Define performance threshold values in the Check Performance Threshold node.
Prerequisites
Google Sheets with service account credentials
Slack workspace with bot token
Gmail or SMTP credentials
Use Cases
Real-time performance threshold alerts for elite athlete training programmes
Customization
Replace OpenAI with Anthropic Claude for analysis and summary agents
Benefits
Automates session analysis and insight storage immediately after each training entry