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.

Workflow fit

This approach may fit when...

  • Registrations move between forms, sheets, email, and QuickBooks.

  • Routine messages or invoice preparation wait for someone to complete manual work.

  • You want to improve those handoffs without replacing the tools your staff already knows.

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.

Choose the next step for your workflow.

Start with a bounded map when the process is unclear, or discuss implementation when the workflow and desired outcome are already understood.

See the workflow demo as supporting proof