Built and deployed an end-to-end inquiry-to-booking management system connecting a customer-facing website to an Airtable CRM, automated communications, and an internal dashboard for tracking inquiries and upcoming events.
Project type: Business operations automation demo
The Challenge
C&C Captures & Events collected event inquiries through a Google Form linked to Instagram. There was an opportunity to improve how customer information, event requests, and booking statuses were organized, while making confirmations and follow-ups easier to manage. Without a structured system, inquiry details were at risk of being missed, duplicate submissions could go undetected, and follow-up communications depended on manual effort.
The Solution
Built and deployed a customer-facing website with a custom event inquiry form, connected to an automated Make workflow and an Airtable CRM. The system handles the full process from initial inquiry submission through duplicate detection, record creation, customer confirmation, internal notification, event reminder scheduling, and dashboard reporting.
Workflow
The customer submits an event inquiry through the website form. Make searches Airtable for an existing record using the customer's email address. A two-branch router separates the path based on the result. New inquiries are processed through record creation, internal notification, and customer confirmation email. Duplicate submissions are stopped without creating another record or triggering additional emails. Booked events receive scheduled reminders. All inquiry and booking data is tracked in an Airtable dashboard.
System Architecture
Platform: Make.com. Integrations: Lovable, Make, Airtable, Gmail. Trigger: New inquiry submission via website form. Logic: Email-based duplicate detection, two-branch router, conditional record creation, automated customer confirmation, internal business notification, event reminder scheduling, Airtable CRM and dashboard reporting.
What I Built
Built and deployed a website for C&C Captures & Events with a custom event inquiry form.
Gives the business a professional online presence and a structured entry point for customer inquiries.
The workflow searches Airtable for an existing inquiry record using the customer's email address before processing the submission.
Prevents duplicate records from being created and avoids sending repeat confirmation emails to the same customer.
A router separates new inquiries from duplicate submissions. New inquiries continue through the full workflow.
Duplicate submissions are stopped at this stage without creating additional records or triggering communications.
New inquiry details including customer information, event requirements, and booking status are stored automatically in Airtable.
Gives the business a single place to manage all incoming inquiries.
A confirmation email is sent automatically to the customer when a new inquiry is received.
Reduces the need for manual follow-up at the first stage of the process.
A notification is sent to the business when a new inquiry comes in.
Keeps the team informed without requiring them to check the CRM manually for new submissions.
Reminders are scheduled automatically for booked events.
Reduces the risk of missed follow-ups and keeps the business prepared ahead of confirmed bookings.
A dashboard provides visibility into inquiry volumes, booking statuses, and upcoming events.
Gives the business a clear view of the pipeline without manually reviewing individual records.
Operational impact
Tools Used
Lovable, Make.com, Airtable, Gmail
Outcome
Delivered a working demonstration of an end-to-end inquiry-to-booking management system, connecting a customer-facing website, Make automation, Airtable CRM, and Gmail communications in one process. The system is designed to reduce manual data entry, make inquiry tracking more consistent, and reduce the need to manually manage customer confirmations and event reminders. Note: This case study describes the capabilities of a deployed demonstration system. No specific time savings, conversion improvements, or other measured business results have been established.
All data shown in screenshots is sample data used for demonstration purposes.