How to Build an Automated Client Onboarding Workflow with Make.com and AI

Every solopreneur has a version of this story: you land a new client, and then you spend the next 45 minutes copy-pasting their info into a spreadsheet, drafting a welcome email, setting up a Notion page, and firing off three different messages to get things started. It's not the work — it's the admin around the work that eats you alive.

The good news? You can build a system that handles all of it automatically — and it takes less than two hours to set up. In this post, I'll walk you through a real Make.com + AI workflow that triggers the moment a new client fills out your intake form and handles everything from there.

Why Make.com Is the Right Tool for This

If you've heard of Zapier, Make.com (formerly Integromat) is its more powerful sibling. While Zapier is excellent for simple A→B automations, Make.com lets you build branching, multi-step workflows with real logic — which is exactly what client onboarding requires.

The key advantages for solopreneurs:

Free plan includes 1,000 operations/month — plenty for most independent service providers
Visual workflow builder — drag and drop, no code
Native AI integrations — connect directly to OpenAI, Claude, or Perplexity to generate content on the fly
Hundreds of app connectors — Gmail, Notion, Airtable, Stripe, Typeform, Google Sheets, and more

Paired with an AI model for writing personalized content, Make.com becomes a 24/7 onboarding assistant that never forgets a step.

The Workflow We're Building

Here's the full pipeline, end to end:

Trigger: Client submits your intake form (Typeform, Tally, or Google Forms) Step 1: Make.com captures the submission Step 2: AI generates a personalized welcome email Step 3: Gmail sends the welcome email automatically Step 4: A new Notion page is created for the client Step 5: The client's info is logged in your Google Sheet CRM Step 6 (optional): A Slack or email notification fires to alert you

This entire flow runs in under 60 seconds from the moment the form is submitted. No manual work required.

Step-by-Step: Building the Workflow in Make.com

Step 1: Set Up Your Trigger

Log into Make.com and create a new Scenario. Click the large "+" and search for your form tool:

Typeform → choose "Watch Responses"
Tally → choose "New Submission"
Google Forms → use Google Sheets "Watch New Rows" (Tally and Typeform are cleaner)

Connect your account, select the form, and run a test submission so Make.com has sample data to work with. This is important — you'll reference those field values throughout the rest of the build.

Step 2: Add an AI Module to Write the Welcome Email

Click the "+" after your trigger and search for OpenAI or HTTP (if you want to use Claude's API directly).

For OpenAI:

Module: "Create a Completion" or "Create a Message (GPT-4)"
System prompt: Set up your brand voice

Here's the exact prompt template to use for generating the welcome email body:

You are the assistant for [Your Business Name], a [service type] agency.
Write a warm, professional, and concise welcome email to a new client.

Client Name: {{name}}
Service Purchased: {{service}}
Project Start Date: {{start_date}}
Their Main Goal: {{main_goal}}

The email should:
- Be friendly but not overly casual
- Confirm what they've signed up for
- Tell them the next step (a kickoff call or onboarding questionnaire)
- Be no longer than 200 words
- Sign off as [Your Name] from [Your Business]

Do not include a subject line. Only return the email body.

Replace the {{variables}} with Make.com's dynamic field references from your form submission. Make.com will swap in the real data when the scenario runs.

Step 3: Send the Welcome Email via Gmail

Add a Gmail module: "Send an Email"

To: Map to the client's email field from the form
Subject: Welcome to [Your Business], {{first_name}}! Here's What's Next
Body: Map to the AI output from Step 2

That's it. The email goes out automatically, personalized with real information, within seconds of the form submission.

Step 4: Create a Notion Page for the Client

Add a Notion module: "Create a Page"

Select your "Clients" database and map the following fields:

Name: Client's full name
Email: Their email
Service: What they purchased
Status: Set to "Onboarding" by default
Start Date: From the form
Notes: You can optionally run another AI prompt here to generate a brief project brief summary from the form responses

Now every new client automatically gets their own Notion page, pre-populated with everything you need to start the project.

Step 5: Log to Google Sheets

Add a Google Sheets module: "Add a Row"

Map each column to the corresponding form field. At minimum, capture:

Date/Time
Client Name
Email
Service
Status
Deal Value (if you collected this in the form)

This becomes your lightweight CRM. You can sort, filter, and track pipeline health without paying for a full CRM tool.

Step 6: Notify Yourself

Optional but recommended. Add a final Gmail module (or Slack, if you use it) to send yourself a brief alert:

New client onboarded: {{name}} — {{service}} starting {{start_date}}. Notion page created. Welcome email sent. ✅

Now you get a clean notification every time the system runs, without having to touch anything.

Real Results: What This Saves You

Here's what a typical manual onboarding used to take:

| Task | Manual Time | |------|-------------| | Copy form data to spreadsheet | 5 min | | Draft and send welcome email | 15 min | | Create Notion project page | 10 min | | Send internal notification | 3 min | | Total per client | ~33 min |

With this workflow, that drops to zero minutes of manual work per client. If you onboard 5 clients a month, that's nearly 3 hours back — every single month, forever.

Pro Tips to Extend This Workflow

Once the base workflow is running, here are three ways to make it smarter:

Add a conditional branch: If the client selected "Website Design" vs. "Social Media Management," send them a different welcome email and create a different Notion template. Make.com's Router module handles this cleanly.

Trigger a Stripe payment link: If you use Stripe for invoicing, add a module to create a payment link automatically and include it in the welcome email. No more manually creating and sending invoices.

Schedule a follow-up email: Use Make.com's "Sleep" module to delay 48 hours, then send a second email checking in and sharing your onboarding questionnaire — all without lifting a finger.

Common Mistakes to Avoid

Don't skip the test submission. Always run a real test before going live. Make.com's sample data preview doesn't always catch edge cases in AI outputs or field mappings.

Watch your OpenAI token usage. If you're generating long AI outputs and onboarding frequently, costs can creep up. Set a max token limit on your AI module (200–400 tokens is usually enough for a welcome email).

Keep your form fields consistent. If you change a field name in Typeform, your Make.com mappings will break silently. Use stable field IDs when building the workflow.

Your Next Step

The hardest part of this workflow is starting. Set aside 90 minutes this week — the free Make.com plan is more than enough to run this — and build the first three steps: form trigger, AI email, Gmail send. That alone will save you time immediately.

Once you see it running, you'll want to automate everything.

Want more AI workflow templates like this? Download the free AI Morning Brief at aiproductivitydaily.com/free-tools — it's a curated weekly digest of the most useful AI workflows, tools, and prompts for solopreneurs who want to work smarter, not longer.