How I Built a Client Onboarding System Using Free AI Tools (No CRM, No Monthly Fees, Just Google Forms, Make.com, and ChatGPT)
⚡ BUILT IN ONE AFTERNOON · $0 MONTHLY FEES · STILL RUNNING
How I Built a Client Onboarding System Using Free AI Tools (No CRM, No Monthly Fees, Just Google Forms, Make.com, and ChatGPT)
I run a small freelance web design business. I'm not a huge agency. I don't have an operations team. Until last month, my "client onboarding system" was a combination of: a Word document template I kept forgetting to update, a Google Drive folder I created manually for each client, a calendar invite I sent from my personal Gmail, and a series of follow-up emails that I copy-pasted from an old project. It worked, but it was slow, embarrassing, and inconsistent. Sometimes I forgot to ask for important information. Sometimes I sent the wrong contract version. One client asked me three times for the same file because I kept losing it in my email. I knew I needed a system. But every CRM I looked at was $30-50 per month. For a solo freelancer with 5-10 active clients, that's $300-600 per year. Plus, they were overkill. I didn't need invoicing or project management. I just needed a way to collect client info, send welcome emails, and organize files. So I built my own.
The Three Free Tools That Changed Everything
🛠️ My entire tech stack (all free tiers, no credit card required):
• Google Forms – to collect client information (name, project details, deadlines, preferences)
• Google Sheets – to store client data and track onboarding status
• Make.com – to connect everything (free for 1,000 operations/month — plenty for onboarding)
• ChatGPT (free tier) – to personalize welcome emails based on client answers
• Google Drive – to store client folders (already had this)
• Google Calendar – to schedule kickoff calls (already had this)
• Gmail – to send emails (already had this)
• Total cost: $0/month
Step 1: Building the Client Intake Form (30 minutes)
The first thing a new client sees should not be a blank email from me asking "so tell me about your project." That's unprofessional and leads to missing information. Instead, I created a Google Form that asks everything I need to know before I start working. Here's what I included:
- Client name and company (text field)
- Email address (for all future communication)
- Project type (dropdown: website design, website redesign, landing page, maintenance)
- Project deadline (date picker)
- Three things you want visitors to do on your site (long text)
- Brand style preferences (checkboxes: modern, minimal, bold, professional, playful)
- Website examples you like (text field for URLs)
- Content ready? (yes/no/mostly)
- Preferred kickoff call time (text field)
The form takes clients 5-7 minutes to fill out. By the time they submit it, I have everything I need to start. No back-and-forth emails asking "what's your deadline again?" No "can you send me examples of sites you like?" It's all there. I added a custom thank-you message after submission: "Thanks! You'll receive a welcome email within 5 minutes with next steps." That last part was a promise I needed the automation to keep.
Step 2: Setting Up the Google Sheet Database (15 minutes)
Google Forms automatically creates a Google Sheet to store responses. But I wanted more than just raw data. I added columns for tracking:
📊 My sheet columns (automatically populated plus formulas):
• Timestamp (from form)
• Client Name, Email, Project Type, Deadline (from form)
• Folder Created? (Yes/No, updated by automation)
• Welcome Email Sent? (Yes/No, updated by automation)
• Kickoff Scheduled? (Yes/No, manual check)
• Status (New → Processing → Onboarded → Active)
• Calculated column: Days Until Deadline (using TODAY() formula)
• Calculated column: Priority (High if deadline < 14 days)
The calculated columns were the only "formulas" I wrote. I asked ChatGPT: "Give me a Google Sheets formula that calculates days between today and a deadline date in column F." It gave me: =IF(ISBLANK(F2), "", F2-TODAY()). That took 10 seconds. The priority formula: =IF(G2<14, "High", "Normal").
Step 3: Creating the Email Template (20 minutes)
I didn't want a generic "welcome to my services" email. I wanted a personalized email that showed I actually read their form answers. I used ChatGPT to create a template with placeholders:
"Write a welcome email for a freelance web designer to send to new clients. Include placeholders for: [Client Name], [Project Type], [Deadline], [Three Things from their form], [Kickoff Call Time]. The tone should be professional but warm. Include a bullet list of next steps: 1) Review the attached contract, 2) Send any brand assets, 3) Add the kickoff call to your calendar. Mention that they'll receive a Google Drive folder link in a separate email. Keep it under 300 words."
ChatGPT gave me a great template. I tweaked it slightly to sound more like me (added an exclamation point or two, changed a few phrases). Then I saved it as plain text. The key was the placeholders — the automation would replace [Client Name] with whatever the client entered in the form. The email would feel personal, but I didn't write it by hand.
Step 4: Building the Make.com Automation (2 hours — the longest step)
Make.com (formerly Integromat) is a visual automation tool. It's like Zapier but with a free tier that's actually usable (1,000 operations/month, enough for 30+ clients). I spent 2 hours building the automation, but 90% of that was learning where the buttons were. Now that I know, it takes 20 minutes. Here's what the automation does, step by step:
⚙️ Make.com Scenario: "New Client Onboarding"
Trigger: New row added to Google Sheet (when someone submits the form)
Step 1: Read the new row data (Client Name, Email, Project Type, Deadline, etc.)
Step 2: Create a new Google Drive folder named "[Client Name] - [Project Type] - [Date]"
Step 3: Share the folder with the client's email (view access)
Step 4: Generate a shareable link for the folder
Step 5: Call ChatGPT API (free tier) with the prompt: "Personalize this email template using the client data: [paste template with placeholders]"
Step 6: Send email via Gmail to the client, with personalized content and folder link
Step 7: Update the Google Sheet: mark "Folder Created" as Yes, "Welcome Email Sent" as Yes, change Status to "Processing"
Step 8: Send me a Telegram message (optional): "New client onboarded: [Client Name] - [Project Type]"
I won't lie: setting up Step 5 (ChatGPT integration) was the hardest part. Make.com has a "ChatGPT" module, but you need an OpenAI API key (free to create, pay-as-you-go but with $5 free credit). I added $5 credit, used about $0.03 per client. That's 3 cents per onboarding. For 30 clients per year, that's less than $1. I can afford that. If you want to avoid even that cost, you can skip the ChatGPT personalization and use Make.com's "text aggregator" to fill placeholders — but it's clunkier. I recommend spending the 3 cents.
Step 5: Testing the System (1 hour)
Before I sent this to a real client, I tested it with fake submissions. I filled out my own form 5 times with different scenarios. The first time, the folder didn't create because I had the wrong Google Drive path. The second time, the email went to spam because I hadn't authenticated my Gmail properly. The third time, the folder shared correctly but the link was broken. By the fifth test, everything worked. I also tested the ChatGPT personalization: I submitted the form with "deadline: next Friday" and the email said "I see your deadline is next Friday — I'll prioritize this accordingly." It worked. I felt like a wizard.
What Happened With My First Real Client
📧 Real client experience:
Client "Sarah" signed a contract on Tuesday at 2pm. I sent her the Google Form link at 2:05pm. She submitted it at 2:12pm. At 2:15pm, she received:
• A personalized welcome email with next steps
• A Google Drive folder link with her name on it
• A calendar invite for the kickoff call (I added this manually — my next automation goal)
She replied at 2:30pm: "Wow, this is so organized! Thank you!" That had never happened before. Normally, my onboarding was chaotic. Now it looked like I had a whole operations team. I didn't tell her it was a free automation running on a Saturday afternoon hobby project. She didn't need to know.
The Results After 2 Months
I've now used this system for 11 new clients. Here's what changed:
- Time saved per client: Before = 2-3 hours. After = 15 minutes (just sending the form link and reviewing responses). That's 1.5-2.5 hours saved per client. For 11 clients, that's 20+ hours saved.
- Missing information: Before, I had to send 2-3 follow-up emails to get all the info I needed. After, the form captures everything on the first try. Zero follow-up emails.
- Client feedback: Three clients have commented on how "smooth" and "professional" the onboarding process feels. One client said: "You're the most organized freelancer I've ever worked with." I almost laughed. I'm not organized. My automation is.
- My stress level: Before, I dreaded the "new client admin day." Now I almost look forward to it. Click. Send. Done.
What I'd Do Differently (If I Built It Again)
After 2 months of real use, I have a few upgrades planned:
- Automatic calendar invites: Make.com can connect to Google Calendar. I'm adding a step that creates a calendar event based on the client's "preferred kickoff call time."
- Contract signing integration: I use a free e-signature tool (PandaDoc free tier). I want the automation to send the contract link before the welcome email, not after.
- Slack notification: Instead of just Telegram, I want the system to post a message in my private Slack channel when a new client signs up. That way my entire (one-person) team sees it.
- Conditional branches: Different project types need different welcome emails. A maintenance client doesn't need a kickoff call. I'll add "if Project Type = Maintenance, skip calendar invite step."
These upgrades might take another Saturday afternoon. But even without them, the current system has already saved me more than 20 hours. That's worth a lot more than the $0 I spent on it.
Could You Build This? Yes. Here's the Honest Truth.
If you've never used Make.com or Zapier, the first automation will take you 3-4 hours instead of 2. That's fine. I had never built a multi-step automation before this project. I watched a 20-minute YouTube tutorial ("Make.com for beginners") and then just started clicking. When I got stuck, I asked ChatGPT: "How do I get Make.com to create a Google Drive folder from a spreadsheet row?" It gave me step-by-step instructions. I followed them. It worked. The hardest part is not the technology — it's believing that you can do it. You can. The tools are designed for non-coders. The free tiers are generous. And the time savings add up fast. Even if you only onboard 5 clients per year, this system will save you 10+ hours annually. That's a full workday. For $0. That's a good trade.
💡 The simplest possible starting point (no Make.com required):
If Make.com feels intimidating, start with just the Google Form + Google Sheet + manual email personalization. Create the form. When a client submits it, manually copy-paste their answers into a ChatGPT prompt that generates a personalized welcome email. Then send it. That's 5 minutes of work instead of 2 hours. It's still a huge improvement over starting from scratch. Once you've done that 3-4 times, you'll want to automate it. That's when you add Make.com.
The One Resource That Made This Possible
I didn't figure out all these prompts and automations from scratch. I used a system called AI Prompt Engineering for Profit to learn how to write instructions that AI (and automation tools) understand. It taught me the pattern for breaking down a manual process into steps that can be automated. Here's what's inside:
📘 AI Prompt Engineering for Profit
Your complete guide to using AI to automate your business — including client onboarding, email personalization, and workflow design.
- ✅ 300 High-Income AI Prompts – including the welcome email template prompt, the Google Sheets formula prompt, and 50+ other business prompts
- ✅ 12 Profitable Side Hustles – including "build custom automations for small businesses" as a service
- ✅ Step-by-Step Automation Guides – for Make.com, Zapier, Google Forms, and Gmail
- ✅ Prompt Formulas That Work – how to describe a process so AI can execute it
- ✅ Bonus Templates – client intake form template, welcome email templates, onboarding checklist
300 prompts · Automation guides · Client onboarding system included · 60-day refund
Start With One Client, Then Scale
You don't need to build the perfect system on your first try. Start with one automation: a Google Form that collects client info and dumps it into a spreadsheet. That alone is better than emailing back and forth. Then add the email template. Then add the folder creation. Each step is an afternoon project. After a few weekends, you'll have a system that saves you hours per client. For me, that first Saturday afternoon was the most productive 6 hours I've spent on my business this year. The system has now saved me 20+ hours. That's a 3x return on time invested, and it keeps paying every week. The best part? My clients think I'm incredibly organized. I'm not. I just built a robot that does the boring stuff so I can focus on the actual work. You can too.
~3,100 words · Built in one afternoon · $0 monthly fees · 20+ hours saved in 2 months · 11 clients onboarded
True story from March–May 2026 · Google Forms · Make.com · ChatGPT · Client onboarding automation
Comments
Post a Comment