Analytics & Google Sheets

The idea: each trainee has a private Google Sheet that their data syncs into, shared by link with the coach/admin and the trainee, so everyone can see the numbers in a familiar spreadsheet.

What syncs

How it works

• The platform database is the source of truth; sync runs from the platform to the sheet (one-way by default) to avoid conflicting data.
• Sync uses the Google Sheets API (a service account), automatically after each change or on a schedule (hourly/daily).
• A “Sync now” button and an “Open sheet” link live in the trainee record.
• Sharing permissions: the trainee is a Viewer, the coach an Editor; sharing can be revoked automatically when the subscription ends.
• Coach edits in the sheet can be imported in phase 2, with conflict-resolution rules.
• A sync log records success, failure and row counts.
• A combined export produces an admin sheet for all trainees.

  The core analytics inside the platform (live charts) remain the primary interface; the sheet adds transparency and sharing. Health data is shared only through links restricted to specific accounts, never public links.

  Sharing the nutrition plan through Google Sheets#

  In addition to tracking sheets, the platform can generate a meal plan sheet for each trainee:

  Sheet	Content
  Meal plan	Days of the week, meals, foods, quantities, calories and macros
  Substitutes	For each meal, the alternative and its macro equivalent
  Shopping list	Grouped by supermarket section for easier shopping

• A “Export plan to Google Sheet” action on the plan screen or in the trainee record.
• The sheet updates automatically after each approved edit, with the last-sync timestamp visible.
• Sharing: trainee Viewer, coach Editor; no public link is ever created.
• A Google-free alternative: export a branded PDF or a compact image and send it through WhatsApp or chat.
• When the subscription ends, sharing is revoked automatically (configurable).