← All use cases · Gyms & studios
Ask your gym software's AI assistant for the report you used to build in Excel with VLOOKUPs
Daniel Egloff of Queen City CrossFit, who has a finance background, in a PushPress blog post about its own AI Assistant
He asks the AI Assistant built into PushPress Core, the gym's software, for the report in plain language instead. The post calls him a top 1% user and puts his use at the "insights" level: churn, attendance and revenue patterns that used to take spreadsheet work. The post doesn't say exactly which report it is.
PushPress AI Assistant: no price in our data. Our DIY build with an exported report: ChatGPT Free $0; Go $8/mo; Plus $20/mo; Pro $100/mo · Claude $17/mo billed annually ($20 monthly)
Easy · or we set it up for $197
PushPress AI Assistant
The problem
He used to build a regular report by exporting data and running it through Excel with a VLOOKUP function.
What happened
Vendor-reported, with his quote: "I used to run that all through an Excel with a VLOOKUP function. Now it's saving me 20 minutes that I used to spend getting that report." No other figures are given. This is PushPress's own blog post about its own product.
Quoted in the source: Daniel Egloff, Queen City CrossFit. Source: PushPress blog: The 4 Ways Gym Owners Use the AI Assistant (Liz Childers) (2026-05-19) · Added 2026-10-21.
How to set it up yourself
- What Queen City CrossFit does: a report the owner used to assemble with VLOOKUPs in Excel now comes from one question to the AI Assistant in PushPress Core. The steps below are our DIY build for gyms without a built-in assistant.
- Export the two files your spreadsheet joined (for example the member list with plan and start date, and check-ins or payments) from your gym software. Delete emails, phone numbers and card details first, keeping a member ID to match on.
- Upload both files to ChatGPT or Claude with the prompt below, and ask for the same table you used to build by hand.
- Check three or four members against your gym software the first time; once the numbers match, save the prompt and run it the same way each week or month.
Copy-paste prompt
Two files from {GYM NAME}: members (ID, plan, start date, status) and check-ins (ID, date). Match them on member ID and build this report for {MONTH}: active members by plan, new members, cancellations, monthly churn rate, and average check-ins per member by plan. Show the table, then list any member IDs that don't match between the files. Use only the data in the files and don't guess missing values.We set up one AI automation in your tools, live within 48 hours of getting access, for $197. No call needed. Founding price for our first 10 customers (regular $297).
One short email a day: 3 new AI use cases from real small businesses, each with its source and setup steps, plus a Tool of the Day. Free, no spam, unsubscribe anytime.
Rather not do it yourself?
The $197 Quick-Win: we set up one AI automation that saves you hours each week, in accounts you own, live within 48 hours of getting access. No call needed. Refund if it isn't live in 48 hours or isn't doing its job in the first 14 days. Founding price for our first 10 customers (regular $297). Terms.
See the $197 Quick-WinNeed more than one automation or ongoing care? Bigger setups: $149/mo with setup included (6-month minimum), or $497 pay-once. Satisfaction guarantee: we'll fix it until it works. Pay-once setups: or we refund your setup fee. $149/mo plan: cancel in the first 30 days and we refund your first month. We reply within 1 business day.
Related for Gyms & studios
Predict which gym members are about to cancel and give each a re-engagement plan
A machine-learning model the gym built with AI learns from members who cancelled in the past and how their behavior changed before they l…
Run a Pilates studio front desk with a booking chatbot plus a small remote team
A TrueLark chatbot on the website answers basic questions, books and cancels classes and funnels new leads; QR codes in each studio point…
Convert more gym membership inquiries with instant AI replies
An AI agent answers inquiries instantly and books visits.
Running something like this in your business? Submit your use case and we'll credit you with a link.
Get 3 new AI use cases every morning
One email every morning: 3 new AI use cases from real small businesses, each linked to its source, plus a Tool of the Day. Free. No spam, unsubscribe anytime. Privacy
Rather have one set up for you? The $197 Quick-Win.