work / automation / automated employee onboarding

New hire added once. Everything else sets itself up.

Every new hire meant a manual checklist across Slack, Google Workspace and email. I built an automation that does the whole setup from one HR record, and chases missing details on its own.

role
Solo developer
client
US multi-entity services group
status
Live in production

Languages

JavaScript (Apps Script)

Tools & platforms

Google Apps ScriptGoogle Workspace AdminSlack APIHRIS API

AI & LLM

to build it
ClaudeChatGPTPerplexity

Skills

API integrationWorkflow automationEscalation logicScheduled jobs
50+

hires provisioned automatically

1

manual step left: add the hire

3

systems kept in sync

01// how I approached it

The thinking behind it

  1. 01 · What I noticed

    Setup steps weren't hard. They were forgotten, because they lived in a checklist nobody owned.

  2. 02 · What I decided

    Make the HR record the single source of truth and let everything else follow it, with reminders when details are missing.

  3. 03 · What I delivered

    Onboarding that runs itself: 50+ hires provisioned automatically.

02// old vs new

Old system vs new system

Old systempeople as the glue
  1. HR emails IT
  2. IT creates accounts
  3. Someone adds Slack channels
  4. Someone adds Google groups
  5. Check what was missed
New systemthe system does the work
  1. HR adds the hire
  2. Profile checked automatically
  3. Slack, groups and alias set up
  4. Monthly sync keeps it right
03// how it works

Watch it run

Click through the four steps. In step 3, click any box to see what it does.

synthetic data · no client screens
Reconstruction with synthetic data · no client screens
04// the hard part

Automation that chases people, politely.

Half the setup depends on details people forget to enter. Instead of failing silently, the automation warns the person, then escalates to a manager if nothing changes, so every profile ends up complete without anyone keeping a list.

05// key decisions

Why it's built this way

decision 1

The HR record is the single source of truth

Every other system is updated from it, never edited by hand.

Trade-off: HR data has to be right, so the warnings matter.
decision 2

Warn, then escalate

Missing details trigger a reminder first and a manager escalation later.

Trade-off: a little more logic than a simple "fail".
decision 3

A monthly maintenance run

Catches anything that changed outside the automation.

Trade-off: one more scheduled job to monitor.