Project 01
Shipped
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.
Screenshots
SimplyBook → Sheets pipeline
AppSheet triggers scheduleWeeklyBookings in Google Apps Script, which reads client/teacher data from Google Sheets, calls SimplyBook.me via JSON-RPC, and writes bookings back atomically. Cleaned data with custom IDs feeds AppSheet for daily ops and Google Data Studio for monthly progress reports.
User Interface (AppSheet)
- AppSheet UI (mobile/web)
- Automation bot / action button
Execution core (Google Apps Script)
scheduleWeeklyBookings- In-memory lookup maps (teacher & client email)
- Idempotent filter (hashed existing set)
- 14-day date processing loop
- Data validator (case-insensitive / partial blanks)
- UI notification aggregator (
ss.toast)
Data store (Google Sheets)
- Client records
- Booking records
- Teacher directory
- API reference list
External provider (SimplyBook.me)
- JSON-RPC 2.0 endpoint
getTokenmethodbookmethod
Auth handshake → remote booking payload → atomic batch write to bookings sheet → success/error toasts in AppSheet.
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.