Back to Work
automation production

Field-Rep Onboarding

Onboarding for 125+ field reps across three countries was slow. The delay lived in the sync between systems.

Onboarding time
~60% reduction
Field reps covered
125+
Systems reconciled
4, by hand → 1 automation

Tech Stack

Google Apps ScriptGoogle Admin SDKGoogle SheetsEmail Automation

The Problem

A retail field program ran 125+ reps across the US, Canada, and Mexico. Getting a new rep productive was slow, and the slowness had no obvious owner: accounts late, group access missing, the roster wrong in one place but right in another.

The natural response was to optimize the steps: better checklists, faster ticket turnaround.

The Diagnosis

The bottleneck was the sync between systems.

The roster lived in four systems that never agreed: the master store list, the field app’s user list, the time-off tracker, and the country-specific Google Groups. Every onboarding had to reconcile all four by hand, and every mismatch sent someone hunting. The delay lived between the systems.

The Build

One automation that owns the rep lifecycle end to end: onboarding, leave of absence, return, offboarding:

  • Provisions Google Workspace accounts through the Admin SDK, with 2FA enforcement gates
  • Reconciles the roster across all four systems so they cannot drift apart
  • Manages 200+ distribution lists through a three-layer state model (source of truth, staging, then the Admin API write) with per-group confirmation gates and a full audit log
  • Designed to show its work: raw data in, visible logic out, so a non-technical reviewer can audit any change

The Outcome

Onboarding time dropped about 60%. The gain came from the four systems no longer needing to be reconciled by hand.

Trace the delay to the sync. Then fix the sync.

Want to talk about this work, a role, or a build for your team?

Let's Talk