Operations and facility management Case study
Also: Brand and business sites
Booking reports and website for a tour operator
Make scenarios move tour bookings and expenses from Google Sheets into MongoDB; weekly and monthly PDF reports for each city go out by email. Plus WordPress pages for the tour sites.
Overview
A tour operator running tours in several cities collected bookings and expenses in Google Sheets. Make scenarios take that data into a MongoDB database, and an application generates weekly and monthly PDF reports for each city and emails them, with a dashboard for bookings, guides and weekly tours. We fixed the reporting, checked the figures end to end, and also built pages for the company's WordPress tour sites.
The challenge
Reports that failed to generate or attach for some cities even when the Make scenario reported success, bookings missing from or landing in the wrong city's calendar, and a webhook flow that loses bookings if it does not fire.
What we built
- Event-based Make scenarios that take tour data from Google Sheets into MongoDB
- Weekly and monthly PDF reports per city, emailed to the team, with fixes where reports were not generated or attached
- A monthly sheet module with expenses and calculations, and checks of revenue, expenses, gross and net profit
- Checks that dashboard figures, PDF reports and MongoDB records match
- Missing bookings added to Google Calendar, and an investigation of bookings shown in the wrong city's calendar
- A proposed scheduled recovery scenario in Make for bookings missed when the webhook does not fire
- Deployment of the application to the client's GitHub repository and hosting
- WordPress staging sites and pages built with Elementor: home, tour, blog and gallery pages
Technology used
| Layer | Choice | Purpose |
|---|---|---|
| Websites | WordPress, Elementor | tour site pages |
| Automation | Make.com | scenarios and webhooks for booking and expense intake |
| Data | Google Sheets, MongoDB | source sheets and the reporting database behind the PDF reports |
| Calendar | Google Calendar | bookings per city |
| Hosting | Vercel | the reporting application |
What happened next
- Delivered
The work described above was delivered to the client.
- Operational facts
- Our work on this project took place in 2026.
Could this be your project?
- Your product has to connect to payment, accounting, messaging or other third-party systems.
- You need a web application with user accounts, admin tools and reporting. Website and web app development
- You work in operations and facility management and want a team that has built for it before. Operations and facility management work
Questions about this project
How long did this project take?
Our work on it took place in 2026.
What technology was used?
MongoDB, WordPress, Make.com, Google Sheets, Google Calendar, Elementor, Vercel.
Similar work
Also WordPress, same industry
My Taxi Ride: taxi dispatch and booking platform
Passenger and driver apps for iOS and Android, a dispatch admin panel with reporting, APIs, SIP calling and the public website for the My Taxi Ride dispatch system, built over four years.
Also WordPress, same industry
Property rental website with automated rental reports
A WordPress site for property owners and renters, with HubSpot lead capture and a Zapier flow that fetches Rentometer data and produces a formatted rental report PDF.
Also MongoDB, same industry
GoAquatix: aquatic workforce management platform
A MEAN-stack web app and iOS/Android apps for field-staff scheduling, duty and incident reports, water-safety testing, repair requests, training and hiring across aquatic facilities, built and maintained for six years.