Client Onboarding Automation Recipe for Freelancers & Agencies

Who This Is For

Freelancers, agencies, and solopreneurs who want to eliminate repetitive setup tasks when onboarding new clients. If you're copying and pasting client info into templates or manually updating contracts, this automation replaces that with a single trigger.

What You Get

A fully importable Make.com scenario that:

1. Watches for new client entries in an Airtable base
2. Pulls client and project data
3. Generates customized PDFs: proposal, contract, and project brief
4. Sends them via email or uploads to cloud storage

This workflow is ideal for agencies scaling operations or freelancers who want to appear more professional without spending hours on admin.

Why It Matters

Client onboarding is a high-friction, low-margin task. Automating it means:

• Faster turnaround on client signups
• Fewer errors in custom documents
• More time spent on actual work
• Professional, consistent client experience

This recipe teaches us how much automation increases client conversion and reduces onboarding time — key metrics for any service-based business. It also complements tools like the AI Content Cost Calculator and Automation Workflow Tutorial.

Automation Overview

Trigger: New record added to Airtable (Client Onboarding table)

Steps:

1. Retrieve client and project data from Airtable
2. Format data for use in document templates
3. Generate PDFs using pre-built templates (Google Docs → PDF)
4. Send via email (Gmail or Outlook) or upload to Google Drive

Outcome: A client receives a personalized onboarding package instantly, including:

• Project proposal
• Service agreement
• Kickoff brief

Requirements

• A Make.com account (free tier works)
• An Airtable base with a "Clients" table
• Google Docs templates for proposal, contract, and brief
• Optional: Gmail/Outlook for sending, Google Drive for storage

Step-by-Step Setup

1. Prepare Your Airtable Base

Create a table called Clients with fields like:

• Client Name
• Company
• Project Type
• Scope of Work
• Budget
• Contact Email
• Start Date

2. Create Document Templates

In Google Docs, make templates for:

• Client Proposal
• Service Agreement
• Project Brief

Use placeholders like {{client_name}}, {{project_type}}, etc.

3. Import the Scenario

Below is the full Make.com scenario JSON. Copy and import it into your Make account:

{
  "name": "Client Onboarding Automation",
  "modules": [
    {
      "id": 1,
      "type": "trigger",
      "module": "airtable.watchRecords",
      "parameters": {
        "base": "appXXXXXXXXXXXXXX",
        "table": "Clients"
      }
    },
    {
      "id": 2,
      "type": "action",
      "module": "airtable.getRecord",
      "parameters": {
        "base": "appXXXXXXXXXXXXXX",
        "table": "Clients",
        "recordId": "{{1.id}}"
      }
    },
    {
      "id": 3,
      "type": "action",
      "module": "google_docs.createDocumentFromTemplate",
      "parameters": {
        "templateId": "1DocTemplateIDProposal",
        "title": "Proposal - {{2.data.fields.Client Name}}",
        "replacements": {
          "{{client_name}}": "{{2.data.fields.Client Name}}",
          "{{company}}": "{{2.data.fields.Company}}",
          "{{project_type}}": "{{2.data.fields.Project Type}}",
          "{{scope}}": "{{2.data.fields.Scope of Work}}",
          "{{budget}}": "{{2.data.fields.Budget}}",
          "{{start_date}}": "{{2.data.fields.Start Date}}"
        }
      }
    },
    {
      "id": 4,
      "type": "action",
      "module": "google_docs.exportToPdf",
      "parameters": {
        "documentId": "{{3.id}}"
      }
    },
    {
      "id": 5,
      "type": "action",
      "module": "gmail.sendEmail",
      "parameters": {
        "to": "{{2.data.fields.Contact Email}}",
        "subject": "Your Project Proposal & Agreement",
        "body": "Hi {{2.data.fields.Client Name}},\n\nAttached are your project proposal and service agreement. Let me know if you have any questions!\n\nBest,\n[Your Name]",
        "attachments": [
          "{{4.url}}"
        ]
      }
    }
  ]
}

🧩 Tip: You can duplicate steps 3–5 to generate and send the contract and project brief as well.

4. Customize IDs and Fields

Replace the following placeholders in the JSON:

• appXXXXXXXXXXXXXX → Your Airtable base ID
• 1DocTemplateIDProposal → Your Google Docs template ID (found in the URL)
• Map Airtable fields to match your base

5. Test the Workflow

Add a test record to your Airtable base and confirm that:

• The record is detected
• PDFs are generated
• Emails are sent with attachments

Troubleshooting FAQ

Q: My documents aren’t generating. What’s wrong? A: Check that your Google Docs template IDs are correct and that placeholders match the field names used in the scenario.

Q: The email isn’t sending. A: Confirm Gmail is connected in Make and that the email field in Airtable is valid.

Q: I want to store files instead of emailing. How? A: Replace the Gmail step with a Google Drive upload module and save the PDFs to a folder.

Q: Can I use this with Notion or HubSpot instead of Airtable? A: Yes — swap the trigger and data retrieval steps with the relevant app modules in Make.

Next Step

Want to turn this into a sellable digital asset for other freelancers?

👉 Download the full Make.com scenario and customize it for your niche. Add upsells like editable templates or training videos to increase LTV.

Or, use this workflow as a foundation for a freelancer toolkit bundle — pair it with the AI Prompt Pack for Indie Makers and Automation Workflow Tutorial for a high-value lead magnet or Gumroad product.