blog thumbnail
sigma-school

How a Student Built a Full-Stack Booking App That Syncs with Google Calendar

Sigma School
5th June 2025

From Lecture Halls to Launch Screens: Alfred’s Journey into Tech

When Alfred joined Sigma School, he wasn't just interested in learning to code — he wanted to solve real problems. A student with a sharp eye for inefficiencies and a drive to improve the education system, Alfred realized that modern schooling wasn't keeping up with the digital age, especially when it came to scheduling and communication.

A fan of streamlined tools and efficient systems, he didn’t want to just build another app. He wanted to build something for students, by a student — a motto that eventually shaped the core of his capstone project: EZBook.


Booking Appointments Shouldn’t Feel Like Homework: The Problem He Set Out to Solve

Alfred noticed a recurring pain point in his school and others like it: booking academic appointments or mentor sessions was unnecessarily complicated.

Many schools rely on manual communication or use multiple platforms that don’t talk to each other. One particular tool inspired him — it worked but required users to constantly send links back and forth, creating confusion and wasted time. For students and educators juggling packed schedules, this just wasn't sustainable.

So Alfred asked: What if everything — booking, calendars, meetings — could happen in one place?


One Platform to Book Them All: Inside EZBook’s Tech Stack

With EZBook, Alfred built a full-stack educational booking platform designed to simplify and centralize appointment scheduling. Here's how he did it:

  • Frontend: React.js and React-Bootstrap for responsive UI
  • Backend: Next.js for API handling and server-side logic
  • Database: NeonDB for storing user data, schedules, and bookings
  • Authentication: Google OAuth for seamless sign-in
  • Calendar Integration: Google Calendar API to auto-create and sync appointments with reminders
  • User Roles: Custom flows for students and educators with separate views and actions

EZBook allows students to log in, browse available appointments from educators, and book directly. Once booked, it sends a Google Calendar invite — no extra steps, no copy-paste.

Educators, on the other hand, can create and manage their availability, view student bookings, and receive instant notifications — all within the same platform.


“I Googled Everything”: The Unexpected Challenges and Big Wins

Building EZBook wasn’t without its hurdles.

One of Alfred's biggest challenges was designing the database. With different user roles, appointment types, and integrations to consider, structuring the backend logic took serious planning. To stay organized, Alfredi hand-sketched flowcharts and data relationships before writing code — a strategy that helped him avoid many headaches later.

Then came the beast: Google Calendar API integration. Setting up authorization through Google Cloud Console was no small feat. The documentation was dense, the setup was tricky, and debugging ate up countless nights. But Alfredi persisted. Using Google, Stack Overflow, and a whole lot of trial-and-error, he finally cracked the code.

“Time management was key,” he says. Balancing university classes, the capstone project, and learning new technologies all at once taught him the importance of focus and prioritization.


More Than Just a School Project: What EZBook Represents

Alfred's project isn’t just a working app — it’s a proof of concept for how tech-savvy students can build tools that solve real-world problems.

“Every school needs students. But to get students, you need a better education system. That starts with better platforms.”
Alfred, Creator of EZBook

Though there’s still room for improvement — like cleaning up the codebase and improving UI design — Alfred sees this as just the beginning. With more time, he plans to automate Google Meet link generation and polish the platform’s responsiveness across devices.


Final Words

EZBook stands as a testament to what can happen when passion meets purpose. In just a few months, Alfred went from beginner to builder — creating a fully functional, real-world application that could genuinely improve how schools run their appointments.

At Sigma School, we’re proud to see students like Alfredi push boundaries, build bold, and solve problems that matter.