How I automated my freelance client onboarding

Winning a new client should feel like a good day. At Northwind it used to be followed by a fiddly half-hour of setup — create the folder structure in Drive, copy the contract template and fill in the details, create a Calendar invite for kickoff, and send a welcome email.

It was the same four steps every time, around 20 minutes per client, and half of that was spent thinking “did I do that already”. That uncertainty was the worst part. The steps were trivial, but with no checklist I’d lose my place — I sometimes created the folders twice, or skipped the contract entirely, and a new client’s first impression of Northwind was a slightly shaky one. The 20 minutes always landed mid-task, breaking whatever I was doing.

It is exactly the kind of work a script should be doing. Here is how I turned a sale into a 30-second setup.

How it works

These days I type a name and a couple of details into a row, and Northwind is fully set up for that client before I’ve switched tabs. The wiring is small: an onEdit trigger watches the status column of a Clients sheet, and a single kickoff(clientName) function does the rest:

1. I add a new client as a row in the Clients sheet.
2. When I set the status column, the onEdit trigger fires.
3. The trigger calls kickoff(clientName) with the row’s details.
4. The function creates the standard Drive folder structure for that client.
5. It copies the contract template and fills in the client’s details.
6. It creates the kickoff Calendar invite and sends the welcome email.

Because one function does all four steps, they either all happen or none do — no more half-finished onboarding. The folder-spinning piece is close to Spin up a client folder structure on intake if you want that part on its own.

What I learned

The hardest decision was not code at all — it was what to put in the folder structure. I’d never had a single folder layout, so every old client looked different. Settling on one standard was a business decision, not a coding one. Once the layout was fixed, the rest of the script was an afternoon’s work; the script essentially wrote itself.

Was it worth it

Yes, clearly:

• 20 uncertain minutes became 5 reliable seconds per client.
• Every client now gets the identical, complete setup — no skipped steps.
• New clients see a polished, consistent start instead of my admin scramble.

When a task is the same every time, the hard part isn’t the code — it’s committing to a standard. Decide once what “done properly” looks like, and the automation almost writes itself.