Calendar event
The automated booking system creates an event at the requested date and time, generates a Google Meet link, and adds the prospect as a guest.
← Back to case studies
Expanded case study · Operational Automation
Automated Booking System for Discovery Calls
A single form submission becomes a fully briefed call in under a minute, with no manual steps in between.
Key Takeaways
- ✓This automated booking system handles calendar events, prep documents, confirmation emails, and tracker logging from one form submission
- ✓Built entirely on Google Workspace with no external tools or paid integrations
- ✓Every prospect gets the same professional confirmation experience regardless of volume
- ✓The system runs on a five-minute trigger and processes new bookings without manual intervention
- ✓A working version of this automated booking system is live on this site right now
01 / The Problem
Manual call prep costs 10 to 15 minutes per booking and produces inconsistent results.
Running discovery calls meant repeating the same admin work before every single one. A prospect fills out a booking form. Someone reads it, creates a calendar event, generates a Google Meet link, writes a prep doc with the prospect's details, sends a confirmation email, and logs everything to a tracker.
Each call took 10 to 15 minutes of setup before the conversation started. At low volume that is manageable. At five or more calls a week, it becomes a second job.
Miss one step and the operator walks into a call unprepared. Miss the confirmation email and the prospect assumes the booking did not go through.
The real cost is inconsistency. Some calls get full prep. Others get a quick glance at the form submission. The experience a prospect receives depends entirely on how busy the operator was that morning.
How much time does manual call prep actually waste?
At 10 to 15 minutes per call and five calls a week, an operator spends over an hour on admin that produces no revenue. Marianne Gatlabayan built this automated booking system after tracking the time cost across dozens of calls and finding that the setup took longer than most of the calls themselves.
02 / The Approach
One form submission triggers six automated actions in sequence.
Marianne Gatlabayan designed and built an end-to-end automated booking system that takes a single form submission and handles every downstream step without manual input. The system runs entirely on Google Workspace. No external tools or paid integrations. No maintenance beyond the Google Sheet it logs to.
After deploying this system across live discovery calls, every booking now follows the same process:
Private prep document
A Google Doc is built from a template and populated with the prospect's name, company, website, LinkedIn, selected services, and written description of their challenge.
Welcome email
The prospect receives a personalized confirmation with meeting details, the Meet link, and context about what to expect on the call. The email references the specific services they selected.
Tracker logging
The booking spreadsheet gets a row with the prospect's details, calendar event ID, prep doc link, Meet link, and timestamp. Nothing lives in someone's inbox or memory.
Scheduled trigger
A time-driven trigger checks for new submissions every five minutes. No manual launch required.
Error handling
If a step fails, the system logs the error and keeps processing. One bad email address does not stop the next ten bookings from going through.
What happens between form submission and the actual call?
Nothing manual. The automated booking system reads the submission, creates the calendar event with a Meet link, generates the prep document, sends the confirmation email, and logs the record. The operator receives a calendar invite with a link to their prep doc. They open it before the call and have everything in front of them.
03 / Manual vs. Automated Booking: Side-by-Side
| Step | Manual Process | Automated Booking System |
|---|---|---|
| Calendar event | Open Google Calendar, type details, create Meet link, add guest | Created automatically with Meet link and guest added |
| Prep document | Open Docs, copy-paste from form submission, format | Generated from template with all fields populated |
| Confirmation email | Write email, paste meeting details, attach link | Sent automatically with personalized service references |
| Tracker update | Open spreadsheet, type details into row | Logged instantly with event ID, doc link, and timestamp |
| Error recovery | Hope nothing was missed | Failures logged, processing continues |
| Time per booking | 10 to 15 minutes | Under 1 minute |
04 / Results
A reliable handoff from booking to conversation, measured across live calls.
After running this automated booking system on marianne.click for discovery calls, the results are:
- ✓Zero manual steps between form submission and a fully briefed call
- ✓Every prospect receives the same professional confirmation experience
- ✓The operator arrives at every call with a populated private prep document
- ✓A full audit trail in the booking tracker with no data entry
- ✓Processing time dropped from 10 to 15 minutes per call to under one minute
05 / Technologies Used
This automated booking system runs entirely on Google Workspace:
- Google Apps Script for the automation logic
- Google Sheets for the booking tracker and data source
- Google Calendar for event creation and Meet link generation
- Google Docs for template-based prep document generation
- Gmail for personalized confirmation emails
- Google Meet for video call links
No third-party tools or monthly subscription fees beyond Google Workspace. No API keys to manage.
06 / Why Build on Google Workspace Instead of Calendly or Acuity?
Off-the-shelf scheduling tools handle the calendar invite. They do not handle what happens after the booking. They do not generate a prep document or log to a centralized tracker. And they do not send a confirmation email that references the specific services the prospect selected.
This automated booking system handles the full pipeline from submission to briefed call, using tools the business already pays for. There is no new vendor to evaluate, no new login to manage, and no monthly fee on top of the existing Google Workspace subscription.
For businesses already running on Google Workspace, this approach keeps everything in one ecosystem and gives full control over every step in the process.
07 / Who This Automated Booking System Is Built For
This system fits any business where scheduled calls are a core part of the sales or intake process:
- ✓Consultants and freelancers running discovery calls
- ✓Law firms handling client intake consultations
- ✓Agencies scheduling prospect calls across account managers
- ✓Professional services firms accounting, financial planning, and coaching booking initial assessments
- ✓Fitness studios and wellness providers managing consultation appointments
If the business runs five or more scheduled calls per week and the admin around each call is still manual, this automated booking system pays for itself in the first week.
Frequently Asked Questions
How long does it take to set up this automated booking system?
Marianne Gatlabayan typically delivers a working system within one to two weeks, depending on how many downstream actions need to be configured. The booking form, calendar integration, prep doc template, and confirmation email are all included.
Does this work with an existing website form?
Yes. The automated booking system reads from a Google Sheet, so any form that writes to a Sheet can serve as the input. That includes Google Forms, embedded website forms, and third-party form builders that integrate with Google Sheets.
What if the business uses Outlook instead of Google Workspace?
This particular implementation is built for Google Workspace. A similar pipeline can be built on Microsoft 365 using Power Automate, though the development approach is different. Book a discovery call to discuss what the setup looks like for your stack.
Can the confirmation email be customized?
Fully. The email references the specific services the prospect selected, includes the meeting details and Meet link, and can include any additional context the business wants to share before the call.
What happens if a submission has an error?
The system logs the error and continues processing the next submission. One bad email address or missing field does not break the pipeline. The operator can review the error log in the booking tracker and follow up manually if needed.
For Prospects
This automated booking system is live on this site right now.
When you book a discovery call through marianne.click, you are using it. The calendar event, the confirmation email, and the private prep document reviewed before the call are all generated automatically from your submission.
If your business runs on consultations, intake calls, or scheduled client meetings and you are still doing the admin by hand, this is the kind of system Marianne Gatlabayan builds.
About the Builder
Marianne Gatlabayan is an Industrial Engineer who designs and builds the operational systems businesses depend on. With a BS in Industrial Engineering from the University of Santo Tomas and ten years of experience in operations and data, she builds automation, data pipelines, reporting systems, and governance frameworks for businesses. This automated booking system is one of 12 operational systems she has built and delivered for businesses across multiple industries.