Track fitness class attendance and retention with Google Sheets, gpt-5.6-terra, Gmail, and Discord
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 32 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Sheets, OpenAI Chat Model, Gmail and Discord.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Normalize Check-in (Edit Fields (Set)): sets 7 fields: checkin_id, member_id, class_name…
- Read Attendance for Report (Google Sheets): uses Google Sheets
- Validate Check-in Input (If): checks a condition and branches into true / false
- Read Roster for Report (Google Sheets): uses Google Sheets
- Read Member Roster (Google Sheets): uses Google Sheets
- Build Invalid Entry Alert (Edit Fields (Set)): sets 3 fields: member_id, class_name, received_at
- Compute Weekly Stats (Code): runs custom JavaScript code
- Match Member by ID (Code): runs custom JavaScript code
- Alert Invalid on Discord (Discord): work with message
- AI Write Weekly Insight (AI Agent): runs an AI agent, with model: Insight Model
…plus 18 more steps. See the full node list below.
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 (10)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Gmail
n8n-nodes-base.gmail - Discord
n8n-nodes-base.discord - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Know exactly who showed up, who is drifting away, and what to do about it. This workflow captures fitness class check-ins via webhook, matches members in Google Sheets, has AI label engagement and draft a personal message, logs everything, emails members, and…