Automation library · Data collection

Track fitness class attendance and retention

Started by another system calling it, and works across Discord, Gmail and Google Sheets. It hands the judgement calls to OpenAI. 32 steps, 3 branches: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

Download free
32 stepsLarge: read it before trusting it with anything live
3Branches: places the flow splits
0Loops or waits
3Services it connects to

The flow

Starts it 2Model 4Logic 14Service 12

The steps in the order they run, from what starts it.

  1. 1When Check-in LoggedWebhookStarts it
  2. 2Engagement ModelLm Chat Open AiModel
  3. 3Weekly Insights TriggerSchedule triggerStarts it
  4. 4Insight ModelLm Chat Open AiModel
  5. 5Normalize Check-inSetLogic
  6. 6AI Judge Engagement and Write MessageAgentModel
  7. 7Read Attendance for ReportGoogle SheetsService
  8. 8AI Write Weekly InsightAgentModel
  9. 9Validate Check-in InputIfLogic
  10. 10Parse Agent OutputCodeLogic
  11. 11Read Roster for ReportGoogle SheetsService
  12. 12Parse Weekly InsightCodeLogic
  13. 13Read Member RosterGoogle SheetsService
  14. 14Build Invalid Entry AlertSetLogic
  15. 15Build Check-in Log RowSetLogic
  16. 16Compute Weekly StatsCodeLogic
  17. 17Build Report EmailSetLogic
  18. 18Match Member by IDCodeLogic
  19. 19Alert Invalid on DiscordDiscordService
  20. 20Append Check-in to LogGoogle SheetsService
  21. 21Email Weekly ReportGmailService
  22. 22Member Found in RosterIfLogic
  23. 23Email Invalid NoticeGmailService
  24. 24Build Member MessageSetLogic
  25. 25Post Weekly Report on DiscordDiscordService
  26. 26Build Agent InputSetLogic
  27. 27Build Unknown Member AlertSetLogic
  28. 28Email Member MessageGmailService
  29. 29Alert Unknown on DiscordDiscordService
  30. 30If Needs AttentionIfLogic
  31. 31Email Unknown NoticeGmailService
  32. 32Alert Manager on DiscordDiscordService

How it's built

Starts on
Another system calling it
Steps
32, with 3 branches
Size
Large: read it before trusting it with anything live
Connects to
Discord, Gmail, Google Sheets
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own Discord, Gmail and Google Sheets accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on another system calling it.

Does it use AI?

Yes. It calls OpenAI. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 32 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 32 steps before you point it at anything that matters.