Business workflow automation using Make.com — from booking form to CRM record, client folder, and scheduled Google Meet call.
Overview
Designed and built an end-to-end client booking automation using Make.com that streamlines the client onboarding process. When a client submits a booking request, the workflow automatically creates a CRM record in Notion, generates a dedicated Google Drive folder, schedules a Google Calendar meeting with a Google Meet link, and invites the client to the meeting.
Process
One booking form submission triggers every downstream step automatically.
Google Forms
Client submits a booking request with service details and notes.
Google Sheets
Submission lands as a new row that Make.com watches for.
Make.com
The scenario triggers, maps fields, and runs every downstream step.
Notion CRM
A new client record is created with mapped properties and relations.
Google Drive
A dedicated client folder is generated for project files.
Google Calendar + Meet
A discovery call is scheduled and a Meet link is attached.
Confirmation Email
The client receives a confirmation with call details and next steps.
Highlights
A single Make.com scenario carries a booking form all the way to a scheduled, confirmed meeting with zero manual steps.
Form data is mapped directly into a Notion CRM record, keeping client information structured and searchable.
Google Calendar events are created automatically with a Google Meet link and the client invited as an attendee.
Capability
The concrete technical skills applied while planning, building, and shipping this project.
Workflow Automation
Make.com Scenario Design
Data Mapping
Notion Database Design
Google Workspace Automation
CRM Integration
Error Handling
Process Documentation
Stack
Problem
Managing client bookings manually requires copying information between multiple applications, increasing the risk of errors, duplicate work, and missed appointments.
Approach
Stores the submission in Google Sheets
Creates a client record in Notion
Creates a dedicated client folder in Google Drive
Schedules a Google Calendar discovery call
Generates a Google Meet link
Invites the client to the meeting
Populates the event description with business info, requested service, and project notes
Engineering
Real problems hit during the build — and how each one was diagnosed and resolved.
Problem
Scenario modules threw intermittent errors during testing.
How I solved it
Debugged each module in isolation using Make.com's execution history, identified the failing mapping, and added error handlers to catch and retry failed runs.
Problem
Form fields didn't line up cleanly with Notion properties and relations.
How I solved it
Rebuilt the Notion database schema and re-mapped each form field to the correct property type, including relation fields linking clients to bookings.
Problem
Risk of creating duplicate client records on repeat submissions.
How I solved it
Added a search-and-filter step before record creation to check for existing clients by email, preventing duplicates in the CRM.
Problem
Client folders and calendar events needed to be generated reliably every time.
How I solved it
Sequenced the scenario so Drive folder and Calendar creation only fire after a successful CRM record, with fallback logging for failed steps.
Problem
Timezones and date formatting were inconsistent between Sheets and Calendar.
How I solved it
Standardized date/time parsing in Make.com's formatting functions so every event lands on the correct date and timezone.
Problem
The automation needed to hold up under real client traffic, not just test data.
How I solved it
Added retry logic on flaky HTTP-based modules and ran repeated end-to-end tests with varied inputs to confirm reliability.
Impact
6
Apps Connected
10+
Workflow Modules
Hours
Manual Work Saved Weekly
0
Duplicate Records
Minutes
Booking-to-CRM Time
Outcome
Automated the complete client booking workflow
Eliminated repetitive manual data entry
Centralized client information across multiple platforms
Reduced onboarding time through automation
Improved organization with auto-generated records, folders, and schedules
Growth
Building this automation strengthened my skills in:
Gallery
Click any screenshot to view it in full size.
From booking forms to CRM records, folders, and scheduled calls — I can design a Make.com automation that removes the manual busywork from your client onboarding.