Reflet Ops — SimplyBook, Sheets & AppSheet

Booking visibility, session reporting, and student progress tracking

Problem

Reflet needed an easy way to view bookings from SimplyBook, report sessions, and track student data over time — management asked me to tie booking, student, and teacher data together so staff could actually use it day to day.

Solution

A SimplyBook → Google Sheets → AppSheet pipeline, connected with Google Apps Script. GAS pulls booking, student, and teacher data from the SimplyBook API, cleans it, assigns custom IDs, and pushes it into Sheets where AppSheet and Google Data Studio can consume it.

Build story

Wrote GAS to pull from the SimplyBook API, clean records, add custom IDs, and sync into Google Sheets.
Built AppSheet apps so staff could view bookings and report sessions in one place.
Used AppSheet to track student data across sessions as management requested.
Connected Sheets to Google Data Studio for monthly progress reports.
Added scheduleWeeklyBookings — AppSheet triggers automated booking sync with toast feedback to staff.

SimplyBook → Sheets pipeline

AppSheet triggers scheduleWeeklyBookings in Google Apps Script, which syncs client and teacher data from Sheets, calls SimplyBook via JSON-RPC, and writes bookings back. Cleaned records with custom IDs feed AppSheet for daily ops and Data Studio for monthly reports.

Loading diagram…

Where it is now

Pipeline in production at Reflet — staff use AppSheet daily and Data Studio for monthly reports. Booking UX eventually needed more than Sheets could offer → led to Project 2.