Skip to main content
Maleek Odesanya

Business Process Automation / AI Workflows

Autonomous Client Onboarding System

An n8n automation that sets up a new client's folders, records and welcome email the moment a contract is signed. It then uses AI to check their intake form and only unlocks kickoff-call booking when the answers are complete.

01 · Overview

System Overview

I built a two-part automated system (two n8n pipelines) for agency and consulting onboarding. Pipeline 1 handles setup as soon as a client signs a contract. Pipeline 2 reviews the client's strategy questionnaire with AI and decides whether they're ready for a kickoff call.

Tools Used

  • n8n
  • OpenAI (GPT-4o)
  • Airtable
  • Google Drive
  • Gmail
  • Slack
  • Softr
  • Tally
  • Webhooks
  • Calendly

02 · Problem

Why the manual process broke down

Onboarding a new client at a high-ticket B2B agency is slow and messy.

  • Manual setup is repetitive: creating Google Drive folders, setting permissions, adding database records, and copy-pasting welcome emails.
  • Kickoff calls happen too early. The team joins a call and finds the client never gave Meta Business Manager access, never shared their Google Ads ID, or never defined their target audience.
  • Client information ends up scattered across emails, forms and shared drives.

03 · Solution

How the system works

Pipeline 1

Contract Signed -> Instant Setup

  1. 1A webhook (New Contract) receives the contract data from Tally.
  2. 2A JavaScript code node (Format Data) cleans and validates the client name, email, service package and monthly fee.
  3. 3Google Drive creates a "[Client Name] — Launch Vault" folder with 01_Brand_Assets, 02_Ad_Accounts and 03_Strategy subfolders, and gives the client editor access.
  4. 4Airtable gets a new client record (status: Awaiting Assets, progress: 0%) linked to the Drive folder and the client's Softr portal.
  5. 5Slack notifies the team in #client-onboarding, and Gmail sends the client an HTML welcome email.
Pipeline 2

Intake Form -> AI Review -> Smart Routing

  1. 1The client submits their strategy brief on Tally. A webhook sends it to an Airtable lookup (Find Client) that matches it to the right record.
  2. 2An OpenAI GPT-4o node (AI Audit) checks whether the ICP (Ideal Customer Profile) is clear, pricing is explained, and real ad account IDs (Meta Business Manager ID, Google Ads CID) are included. It returns a readiness score (0–100), blocker flags and an executive summary.
  3. 3A code node (Parse Result) converts the AI reply into structured JSON, handles code fences, and falls back to safe defaults on errors.
  4. 4An If node routes the result into one of two paths:

Conditional routing branches

Readyis_valid: true, score >= 75

Airtable moves to "Ready for Kickoff" (75%), Slack gets a success message, and the client receives a pre-filled booking link.

Needs Workis_valid: false, score < 75

Airtable moves to "Needs Revision" (50%) and Slack alerts the team with the exact missing items. No booking link is sent until they're resolved.

04 · Workflow Architecture

Workflow Images

Click any workflow image to inspect individual nodes, branches, and connections at full size.

n8n Canvas — Top: Pipeline 1 (New Contract -> Format Data -> Drive -> Airtable -> Slack/Gmail). Bottom: Pipeline 2 (Intake Form -> Find Client -> AI Audit -> Parse Result -> If node -> Ready & Needs Work branches).

05 · Connected Interfaces & Outputs

Other Project Images

Supporting database records, team notifications, and client-facing outputs connected to the workflow.

Airtable Client Operations Engine — central tracking base updated automatically across provisioning, AI audit, revision, and kickoff stages.
Slack #client-onboarding Notifications — Real-time team alerts for new contract execution (Nordic Brew Co.), automated Drive vault creation, and verified kickoff readiness with executive strategy synthesis.
Automated Client Welcome Email — Delivered via Gmail immediately upon contract signing with branded workspace provisioning details, client launchpad access, and Google Drive vault links.

06 · Video Walkthrough

End-to-End Walkthrough

Autonomous Client Onboarding System — Full Walkthrough

End-to-end walkthrough of Pipeline 1 contract provisioning, AI strategy audit, and conditional Slack/email routing.

Watch on YouTube

07 · Outcome

What the system delivers

  • Folder creation, database records and welcome messages happen automatically, with no manual setup.
  • Kickoff booking is only offered after the AI review passes, so calls aren't scheduled before ad account access and audience details are in place.
  • Incomplete submissions are flagged to the team in Slack with specifics, instead of being discovered on the call.
  • Fallback handling and two separate routing paths keep bad or incomplete AI output from breaking the workflow.

Build Something Similar

Want this level of automation in your workflow?

Book a free 30-minute discovery call and we'll map out what can be automated in your stack.

Back to projects