Personal Trainer Programming Tool Google Sheets | Turn Client Workout Videos Into Programs | 150 AI Analyses | Coach Kit

Turn any workout video into a client-ready 7-day program in about the time it
takes to read this listing. A hundred and fifty programs included — that's a
quarter of your programming year, at less than the price of one session.

Your analyses follow your order, not a file, so copy the sheet once per client
and they all draw from the same pool.

WHAT YOU GET

• A Google Sheets template that reads workout videos and outputs a complete program.
• Two AI calls per video, both covered by a single analysis: one to identify every exercise, set, rep, hold time, muscle group, difficulty, and form note — the second to construct a personalized weekly plan around them.
• The AI works out what kind of workout it is first — one session, a multi-day program, or a repeating circuit — and builds the plan to match. A single 20-minute session comes back as that session, scheduled through your week. Not as a fabricated gym split you never did.
• A full program written out the way a coach writes one: every exercise with sets, reps, hold seconds, target load, rest interval and a form cue — up to ten per session, not three.
• A workout log and a progress board. Record your sets, and your estimated 1RM, personal records, and next targets calculate themselves.
• A 1RM calculator with the standard 95%–60% loading chart.
• Bodyweight-aware. Train without weights and the tracker progresses on reps and hold time instead of load, because "add 2.5 kg" is not advice a mat workout can take.
• A dashboard with weekly volume by muscle group, training intensity, rest-day distribution, and a movement library that grows as you analyze.
• No subscription. No renewal. No API keys.
• Hosted backend — the AI runs on our servers, not yours. You never touch Gemini or any API console.
• Eight working tabs: START HERE, DASHBOARD, AI VIDEO LAB, MASTER PLAN, WORKOUT LOG, PROGRESS, BODY METRICS, and HISTORY.
• Every program you generate is saved to HISTORY automatically. Reload any of the last 25 back into your plan whenever you want — it costs no credit, so you never pay twice for a program you already have.

HOW IT WORKS

1. Open the link in your download and click Make a copy. That's the install — the tool is already inside the sheet. Grant it permission once when Google asks, and you're done in about three minutes.
2. Activate once from the 🏋️ AI Fitness menu using your Etsy order number. That unlocks the analyses your tier includes.
3. Drop a public YouTube workout link — a full video or a Short — into the AI VIDEO LAB tab, then run AI Fitness → Analyze Video.
4. The exercises populate, your MASTER PLAN fills in with a program shaped to what the video actually was, and your DASHBOARD updates. Generating the program is free — it doesn't cost an analysis, and you can rebuild it as many times as you like from the 🔁 Generate Program menu item.
5. Log your sets on the WORKOUT LOG tab as you train. PROGRESS keeps your records and tells you what to aim for next session.

ONE THING TO KNOW BEFORE YOU BUY — THE PERMISSION STEP

When you make your copy, the tool inside the sheet becomes yours: your copy, in your Google account. The first time you use it, Google asks you to approve it — and because the copy belongs to you rather than being an app installed from the Google Workspace Marketplace, Google shows a screen that lists your own email address as the developer and notes that the script hasn't been through its review programme for Marketplace add-ons. That's the normal path for a copied Sheets template, it's two clicks, and the Setup Guide walks you through it screen by screen.

Nothing is being set up on your side. There's no Google Cloud project to create, nothing to configure, no API keys to paste, and no access for me to anything of yours.

The approval covers three narrow permissions, which Google lists on the screen:

• work inside this one spreadsheet — the copy you just made, not your other files
• connect to our analysis server
• show the menu and dialogs inside the sheet

Gmail, Drive, Calendar and your other spreadsheets aren't on that list and the sheet can't reach them. Every line of the script is readable from your own copy if you'd like to look.

WHY THIS IS DIFFERENT

Most fitness templates are static. You type your workouts in by hand, the math is fragile, and the "smart" features are conditional formatting in a trench coat. This one watches the video for you. Google Gemini reads the footage, names the movements, counts the sets and reps, separates timed holds from repetitions, and notes the equipment in shot. A second AI call turns that into a week that respects recovery — training days spaced, rest placed where volume spikes, and loads prescribed against your own one-rep max. Then you train it and log it, and the sheet keeps your records. The spreadsheet itself is laid out like a magazine spread: no gridlines, a navy-and-dusty-rose palette, and a dashboard that wouldn't look out of place in a fitness studio. You bring the video. It brings the plan.

WHO IT'S FOR

• Personal trainers who want to convert client video references into programmed weeks fast.
• Gym enthusiasts who follow YouTube creators and want their routines structured properly.
• Home-workout people who collect bookmarked videos but never turn them into a schedule.
• Fitness creators prototyping plans for clients or content.
• Anyone tired of building a program from scratch every Sunday night.

WHAT'S INSIDE THE DOWNLOAD

• START_HERE.txt — your spreadsheet link. Open it, click "Make a copy", and the tool is installed. Nothing to paste, nothing to configure.
• Setup_Guide.pdf — illustrated walkthrough of the copy, permission and activation steps.

FAQ

Do I need a paid Gemini or Google AI account?
No. The AI runs on our hosted backend. You don't sign up for anything, you don't buy credits, you don't touch an API console. The sheet you copy already knows how to reach our server.

Why does Google show a warning when I authorize the template?
Because the copy is yours. Google shows that screen for any Sheets template whose tool is copied into your own account instead of installed from the Workspace Marketplace, and it names you as the developer for exactly that reason — you own the copy, and it runs in your account. Click Advanced, then the Go to AI Fitness Video Analyzer link at the bottom — Google tags that link "(unsafe)" on every unreviewed script, including your own — then tick the permission boxes and click Continue. The three permissions are the ones listed above: this spreadsheet only, connect to our analysis server, and show the menu and dialogs. There's no Google Cloud project to create or configure, and nothing you're granting me. Step 3 of the Setup Guide walks through it screen by screen.

Does this work in Microsoft Excel?
The AI features require Google Sheets, because Apps Script is what connects the spreadsheet to the AI backend — and the sheet you copy is a Google Sheet. Downloading it as .xlsx keeps the layout, dashboard, and planning tabs, but video analysis and program generation need Sheets.

What kinds of videos work?
Public YouTube links, including Shorts. Best results come from full-body or routine-style videos under 30 minutes with clear framing. Highly stylized or heavily cut "highlight" edits sometimes miss reps — the AI will flag low confidence when that happens. Videos longer than 30 minutes are analyzed up to that point, and the sheet tells you when it happened rather than pretending it saw the rest.

One thing to know: a small number of YouTube videos are withheld from outside apps by the channel or by YouTube itself. When that happens the sheet says so, no analysis is used, and another video will work — it is not something either of us can unlock.

How many analyses do I get?
Whatever your tier includes — 10 on Starter, 40 on Pro, 150 on Coach — counted on our server. They follow your order rather than a particular file, so rebuilding or re-copying your sheet never loses the analyses you have left, and never grants extra. The spreadsheet itself never expires: dashboards, the MASTER PLAN tab, and everything you've already analyzed keep working forever.

What happens when I run out?
The AI engine locks. The rest of the spreadsheet — every dashboard, every saved plan, every metric — continues to work normally. You can move up a tier whenever you want more. There is no subscription and nothing expires.

Is my data private?
Video URLs are sent to our backend for processing and are not kept — our logs record only a short video identifier for troubleshooting, never the full link. The AI's output lives only in your spreadsheet, on your Google Drive. We don't see your plans, your dashboard, or your usage beyond the analyze-count for limit enforcement. Full privacy note included in the setup guide.

Will the AI know obscure exercises?
Google Gemini is trained on a huge range of movements — barbell, dumbbell, kettlebell, calisthenics, mobility, machine work, Olympic lifts, and most CrossFit movements. If it sees something it can't name with confidence, it labels it descriptively (e.g., "single-arm cable rotation") rather than guessing wrong.

Refunds?
Because this is a digital download with a usage-based AI component, all sales are final once the file is downloaded. If something doesn't work on your setup, message me — I respond within 24 hours and will get you running or refund you. That's the deal.

SAFETY INFORMATION

• Not medical or professional advice. Exercise carries a risk of injury. The exercises, sets, loads, rep counts and progressions the AI produces are automated suggestions drawn from a video — not an assessment of your body, your health, your injury history or your ability.
• Check with a qualified physician or trainer before starting any program, and especially before prescribing one to somebody else. If you have an injury, a medical condition, or you're returning from either, get cleared first.
• Review every program before you train it. AI analysis is probabilistic: it can miss a movement, misname one, miscount reps, or misjudge form. Warm up, start conservatively, and stop if something hurts.
• Loads are estimates. The 1RM figures and target loads come from formulas applied to numbers you enter. They are a starting point for your own judgement, not a prescription.
• Not intended for children, and not a substitute for supervised coaching or physiotherapy.

SPECS / REQUIREMENTS

• Google account (free).
• Google Sheets — open in a desktop browser to make your copy and grant permission the first time. Daily use works on mobile.
• About three minutes for the one-time setup. There is nothing to paste and nothing to configure.
• Internet connection during analysis (the AI lives in the cloud).
• Tiny download: one text file with your spreadsheet link, plus the illustrated Setup Guide PDF. Under half a megabyte in total.