Case studies

Training operations case study

First-aid registration and invoicing automation

A training provider kept its existing Google-based process while Aluui connected routine intake, tracking, communication, and QuickBooks handoffs.

Existing stack retained

Google tools + QuickBooks Online

Client-reported result

5+ routine emails reduced to about 2

Delivery approach

Phased around live operations

The operating problem

Every registration started another chain of admin.

Course registrations arrived through Google Forms, but fulfillment required repeated decisions, copying, messages, and billing work across separate tools. The project focused on those handoffs without forcing a platform migration.

  1. 01

    Review each form submission and determine the correct course path.

  2. 02

    Copy registration details into separate tracking sheets.

  3. 03

    Send routine confirmation and follow-up messages manually.

  4. 04

    Find or create the customer and prepare an invoice in QuickBooks.

  5. 05

    Reconcile registration, invoice, and payment status across tools.

What Aluui implemented

An automation layer around the process already in use

Standardized intake

Google Sites and Forms retained the familiar customer experience while course choices became easier to maintain.

Registration routing

Apps Script normalized each submission and routed records into the required registration and status views.

QuickBooks handoff

The workflow looked up or created a customer, prepared the invoice path, and returned billing status to operations.

Controlled follow-up

Reminder logic was implemented for unpaid invoices, with activation and timing left under client control.

Implemented path

From submission to billing status

  1. Step 1

    Google Form

  2. Step 2

    Apps Script validation

  3. Step 3

    Registration and status sheets

  4. Step 4

    QuickBooks customer and invoice

  5. Step 5

    Status and reminder path

Outcome

The client reported routine registration communication falling from more than five emails to approximately two.

The implemented workflow also reduced repeated copying, returned clearer billing status to the operations view, and created a controlled reminder path for unpaid invoices.

See the control points, not just the outcome.

The interactive prototype shows routine automation, staff approvals, and exception handling with sample data.