Case Study 05 — HOS Operations & Systems Build | Virtually By Mo
Case Study  05
05
GoHighLevel  ·  Jotform  ·  Zapier  ·  Google Sheets  ·  Google Apps Script

Operations & Systems Build
for a Business Facilitator

Business Coach & Facilitator

Industry
Business Facilitation & Strategic Planning
Type
CRM Setup, Systems Integration & Automation
Status
Live
The Problem

A growing practice with no backend to support it

My client is a business coach and facilitator running quarterly and annual planning sessions for leadership teams across multiple organisations. Before each session, every team member completes a pre-work form covering accomplishments, rocks, issues, and priorities. The responses were coming in through different channels with no central place to collect, store, or review them.

On top of that, there was no CRM to manage client relationships, no connection between his website and his business tools, and no consistent process for anything from onboarding to session prep. Everything relied on memory and manual effort.

Every session I'm manually pulling together responses from multiple people, trying to group themes and turn it into something I can actually use in the room. There's no system, no structure, just me piecing it together each time.

No CRM in place to manage leads, clients, or deal stages

WordPress website not connected to any business tool or follow-up system

Pre-work submissions coming in through different channels with no structure

No central place to store or review responses across multiple organisations

Session prep being rebuilt manually every time, taking hours before the work even started

No way to separate and review submissions per organisation at a glance

What I Built

A complete operations build covering the full client cycle

The solution was built across five interconnected layers, CRM foundation, website integration, call documentation, pre-work collection, and automated session prep, creating a single connected system that eliminated the manual effort at every stage.

Live CRM, Website Integration & Pre-Work Collection
  • Set up GoHighLevel as the central CRM for managing leads, clients, and deal stages. Configured pipelines, contact records, booking calendars, and automated confirmation emails so every client relationship has a clear home and nothing gets lost

    GoHighLevel

  • Connected Fathom to GoHighLevel via Zapier so that AI-generated call summaries land automatically in the relevant contact's notes after every session, building a running record of every client conversation without any manual effort

    Fathom + Zapier + GoHighLevel

  • Connected the WordPress website to GoHighLevel so that enquiries and contact form submissions feed directly into the CRM. No manual copy-paste, no missed leads

    WordPress + GoHighLevel

  • Built two versions of the pre-work intake form in Jotform, one for an existing long-standing client and one for all new client groups, with consistent question language aligned to the facilitation methodology and a unique session code field so every submission is automatically tied to the right organisation

    Jotform

  • Built Zapier automations connecting both Jotform forms to separate master Google Sheets. Every new submission is written automatically into the correct tabs across 8 structured sections, with each row stamped with the session code, respondent name, role, and date

    Zapier + Google Sheets

  • Built a Google Apps Script embedded directly into the master sheet. When my client types a single trigger word in the READY TO PREP column, the script reads the session code, scans all tabs of the master sheet, and automatically creates a clean copy of the template sheet in Google Drive containing only that organisation's submissions, correctly placed across every tab

    Google Apps Script + Google Drive

  • Created a full SOP library covering every part of the system, GoHighLevel basics, Fathom, JotForm editing, the full quarterly planning workflow, and a complete Zapier setup guide, so the client and their VA can manage and maintain the system going forward

    Documentation

GoHighLevel WordPress Jotform Zapier Google Sheets Google Drive Google Apps Script Fathom
The Full Flow

How the system works end to end

Enquiry comes in via website

Contact form on WordPress feeds directly into GoHighLevel. Lead is created automatically, no manual entry needed.

WordPress + GoHighLevel
Client managed in CRM

Deal stages, contact records, booking calendars, and automated confirmation emails all managed inside GoHighLevel from first enquiry through to active client.

GoHighLevel
Call summaries captured automatically

After every Zoom call, Fathom records, transcribes, and summarises the session. The summary is sent automatically to the relevant contact's notes in GoHighLevel via Zapier.

Fathom + Zapier + GoHighLevel
Pre-work form shared with team

My client shares the Jotform link with the organisation along with a unique session code. Each team member completes their own submission using that code so every response is tied to the right group.

Jotform
Submissions written to master sheet

Zapier fires on every submission and routes the data into the correct tab in the master Google Sheet. Each response is tagged with session code, name, role, and date across all 8 sections.

Zapier + Google Sheets
Organisation sheet generated in seconds

When all submissions are in, my client types a single trigger word in the master sheet. The Apps Script instantly creates a clean session sheet in Google Drive with only that organisation's data, correctly split across all tabs and ready to use.

Google Apps Script + Google Drive
Session delivered

My client walks into the session with a clean, structured sheet covering every team member's responses, organised, grouped, and ready to facilitate from.

Google Drive
System Map

The full system at a glance

A visual map of how every tool and step connects, from the first enquiry through to the session sheet being created in Google Drive.

Enquiry via website Contact form submitted on WordPress Auto-captured Contact created in GoHighLevel Lead tracked — pipeline, deal stage, booking Call booked and recorded via Fathom AI summary sent to GHL contact notes Session code assigned Unique code given to each client group Pre-work form shared with team Each member submits with their session code Per submission Zapier routes data to master sheet 8 tabs populated — name, role, session code, date All submissions in? Check master sheet per session code No Wait Yes Type "ready" in master sheet READY TO PREP column — any row for that org Script triggers Google Apps Script runs Scans all tabs, copies template, fills with org data Session sheet ready in Google Drive Clean, structured, ready to facilitate from WordPress GoHighLevel Fathom + Zapier Jotform Zapier Apps Script Google Drive
Outcomes

What this system delivers

1 word
Typed in a cell. That is all it takes to generate a clean organisation sheet from the master data.
8 tabs
Automatically populated per organisation, with each respondent's data correctly placed and ready to review.
0 manual
Sorting, copying, or formatting once the system is triggered. It all happens in the background.

The system scales across all client organisations without any additional setup. One master sheet handles every company. My client went from spending hours manually piecing together responses before every session to having a clean, structured sheet ready at the press of a trigger word.

Client Feedback

In their own words

"With Mo, we built a system using Jotform, Zapier and Google Sheets that streamlines my client interaction process for strategic planning. She helped me think through the work-flows and then built a flowchart describing the entire process. From there, she built the system. She was on time and guided me through a fairly complex process. I made it more complex because I want a custom process for each of my clients. Beyond that, she connected our CRM, website, and call recording tools into one system, and built an automation that generates a complete planning sheet for each client group automatically. If you have the opportunity to work with Mo, you will be pleased with the results."

G
Greg S.
Certified Business Coach
Walkthrough

See the build

A full video walkthrough of the system from form submission through to the organisation sheet being created in Google Drive.