Coaching App

Blueprint overview

Structural layout for building your own coaching spreadsheet — content is coach-defined.

Available

Blueprint: CoachGrid Workbook Blueprint
Version: v1
Format: .xlsx / Google Sheet compatible
Required sheets: 9
Optional sheets: 3

Advanced technical details

Internal template key: coachgrid_workbook_template_v1
Blueprint type: Structural blueprint

Sheet aliases

5 split - Lets get shredded and big → 5 split - Lets get shredded and
Mad plan → TD Nutrition
madplan → TD Nutrition

Enabled spreadsheet modules

Daily trackerTimelineTrainingNutritionFood DBFood swapsExercisesAveragesStep loadPrivate health

This blueprint defines sheet structure, ownership, and writeback columns. Build your own training split, meals, and program inside it. Google Sheets import is optional — connect from Sync Center when you want spreadsheet sync.

Custom fields stay read-only until mapped (read_only_until_mapped). Writeback areas: daily_tracker_client_columns, workout_log_reps_load_per_set.

Sheet structure

What this template expects — ownership and writeback per tab

Sheet	Purpose	Status	Ownership	Writeback	Notes
Daglig Tracker	Daily check-ins — weight, steps, sleep, hunger, performance, client metrics	Required	Client-owned	Daily tracker	Client-owned columns; writeback whitelisted only
Tidsplan	Plan timeline — weeks, phases, training/rest calendar	Required	Coach-owned	None	—
5 split - Lets get shredded and Alias: 5 split - Lets get shredded and big	5-day training split — exercises, sets, reps, load targets	Required	Coach-owned	Workout log	Logged reps/load per set are client-owned writeback cells
TD Nutrition	Training day nutrition — meals, macros, portions	Required	Coach-owned	None	—
NTD Nutrition	Rest day nutrition plan	Required	Coach-owned	None	—
Food Database	Food macro database — coach-maintained reference	Required	Coach-owned	None	—
Exercise Log	Exercise library — cues, setup, muscle groups	Required	Coach-owned	None	—
Mad udbytning	Mad udbytning — approved food swap library	Required	Coach-owned	None	—
Averages	Weekly averages and progress analytics	Required	Client-owned	None	Derived from client tracker data
PED plan	Private health / protocol log	optional	Client-owned	None	Sensitive — hidden from AI and client app by default
Step Load Model	Step load progression model	optional	Coach-owned	Future	Blank template rows may import as empty
Dropdown helper	Spreadsheet dropdown helper (legacy formulas)	ignored	Ignored	None	Broken formulas safely ignored; replaced by app dropdown logic

Generated client app

What clients see in the mobile-first client app from this template

Client app is app-first and mobile-first. Coach OS is desktop-first. Same CoachGrid branding — different layout surface. Open client app preview

Enabled modules

TodayEnabled
Daily overview and actions
/today
TrainingEnabled
Workout program and logging
/training
NutritionEnabled
Meal plans and macros
/nutrition
Daily TrackerEnabled
Check-ins, weight, and habits
/tracker
AI CoachEnabled
In-app coaching assistant
/ai-coach
Google Sheet syncEnabled
Spreadsheet import and sync
Daily tracker writebackEnabled
Client metrics written to sheet
Workout log writebackEnabled
Logged sets written to sheet
Food swapsEnabled
Swap library for meals
/food-swaps
Private health logEnabled
PED/protocol timeline visibility
/private-health-log
Coach notesEnabled
Coach instructions visible to client

Placeholders

Progress photos/videosPlaceholder
Visual progress uploads
Loom reviewsPlaceholder
Coach video feedback links
WhatsApp contactPlaceholder
Direct coach messaging CTA
Check-in remindersPlaceholder
Push/email reminders

Disabled

Client notesDisabled
Client-authored notes
MeasurementsDisabled
Body measurements module

Workflow guides

Step-by-step paths for Google Sheets import and sync

Import spreadsheet workflow

Connect a workbook, detect template, validate tabs, link to client, import into CoachGrid.

1
Upload or select spreadsheet
Local .xlsx or Google Sheet via /sync
2
Detect template
Match required tabs and documented aliases
3
Validate tabs & columns
Required sheets, unknown tabs flagged read-only
4
Review aliases & custom fields
Map or ignore unmapped columns
5
Link to client
Associate sheet with client profile
6
Import into CoachGrid
Parser imports coach + client owned data

Open Google sync →

Compare connected sheet

Diff live client sheet against template — missing tabs, unknown columns, mapping suggestions.

1
Load connected sheet tabs
From client Google connection
2
Match required & optional sheets
Exact name or alias only
3
Flag unknown columns
Read-only until coach-approved mapping
4
Show writeback eligibility
Whitelist daily tracker + workout log only
5
Suggest alias fixes
Rename tab or add documented alias

Open sheets →

Client app access

Workspace → template → client overrides

12 enabled for Sample clientServer route guards active

Workspace defaults

Today
Training
Nutrition
Daily Tracker
AI Coach
Google Sheet sync
Daily tracker writeback
Workout log writeback
Food swaps
Loom reviews

Template defaults

Training
Nutrition
Daily Tracker
AI Coach
Google Sheet sync
Daily tracker writeback
Workout log writeback
Food swaps
Private health log

Client override

Per-client overrides not configured yet. Configure access editor coming later.

Enabled for Sample client

Today(workspace)
Training(template)
Nutrition(template)
Daily Tracker(template)
AI Coach(template)
Google Sheet sync(template)
Daily tracker writeback(template)
Workout log writeback(template)
Food swaps(template)
Loom reviews(workspace)
Private health log(template)
Coach notes(workspace)

Disabled modules

Progress photos/videos
WhatsApp contact
Client notes
Measurements
Check-in reminders

Configure accessPreview client app

Disabled modules must be enforced server-side — not only hidden in UI.

Google sync policy

Allowed client-owned fields only

Alloweddaily tracker client columns
Allowedworkout log reps load per set

Coach-owned ranges are never written by the client app. Queue-based sync handles Google sync — not enabled from this workspace yet.

Custom field policy

read only until mapped

Unknown spreadsheet columns are never auto-written. Coach must approve mapping before any Google sync.

Sensitive areas

Hidden by default

Private health / PED log
Unmapped custom spreadsheet columns

Private health log excluded from AI coaching. Client app module off unless coach explicitly enables.

Ownership summary

Coach-owned plans and libraries; client-owned daily tracker metrics and logged workout cells.

Coach: 9 areasClient: 2 areas

Template actions

Safe workflows — destructive spreadsheet writes stay disabled

Import spreadsheet

Preview

Upload or connect a Google Sheet and detect this template

Import spreadsheet

Export template metadata

Available

Download safe JSON metadata — no secrets, no OAuth data

Download JSON

Create Google Sheet from template

Available

Clients create their own Google Sheet copy from this template (Drive files.copy of the master, live in Sync Center). Coach-managed provisioning for a specific client is next.

Download JSON

Compare connected sheet

Setup required

Diff client sheet tabs and columns against this template

Open Plan Diff →

Configure client app access

Setup required

Set workspace, template, and per-client module whitelist

Open Access tab →