Portfolio Demonstration

Google Workspace Operations Hub

Conference Room Booking & Resource Management System

A custom-built operations hub leveraging Google Workspace to automate resource allocation, streamline internal communications, and provide real-time tracking for organizational projects. This system eliminates manual scheduling conflicts and centralizes all operational data into a single, accessible portal.

View Live Demo

Back to Projects

The Problem

PROJECT OVERVIEW: A professional system designed to solve a critical organizational challenge: managing shared physical resources across a growing team. This project demonstrates the integration of Google Workspace tools to create a user-friendly, automated operations hub that replaces manual spreadsheets and fragmented communication.

THE PROBLEM: The organization lacked a centralized, real-time system for booking conference rooms. Employees relied on manual check-ins and static calendars that were frequently out of date, leading to double-booked rooms, meeting interruptions, and general operational friction.

Without automated confirmations or a simplified way to modify reservations, the administrative team spent significant hours each week troubleshooting scheduling conflicts and manually coordinating resource allocation through long email threads.

The Solution

The solution was to build a centralized Operations Hub using a Google Site as an internal employee portal. This hub integrated a custom booking form (Google Forms) with backend automation (Google Apps Script and Sheets) to manage room and equipment availability, prevent scheduling conflicts, and provide automated communication for all workspace activities.

How the Workflow Operates

Google Site

→

Google Form

→

Google Sheets

→

Google Apps Script

→

Google Calendar + Gmail

→

Manage Booking

1. User Request

Employee navigates to the Google Site portal and accesses the embedded Booking Form.

2. Logic Validation

Submit data is logged in a central Google Sheet. Apps Script triggers to check the spreadsheet and calendar for room/time availability.

3. Confirmation & Automation

If available, the event is automatically added to the Google Calendar and a confirmation email is sent via Gmail.

4. Conflict Management

If a conflict is detected, the request is rejected, and the user receives a notification to select an alternative time.

5. Self-Service Management

Confirmation emails include unique links to a separate Apps Script Web App for rescheduling or canceling reservations.

6. Administrative Reporting

Admins maintain a real-time log and booking history sheet to track resource utilization and long-term trends.

Google Form Interface: Initial Page, Room Selection, and Attendee Details

Real-time Booking Log Tracking

Comprehensive Booking History Archive

Reschedule Reservation Web Interface

Cancel Reservation Web Interface

Key Features

Tools Used

Documentation

Staff Booking Portal: A centralized Google Site where team members can check room availability and submit booking requests.
Automated Calendar Sync: A Google Apps Script that reads form submissions and automatically creates events on the Sinclair Room Google Calendar.
Conflict Prevention: Built-in logic to prevent double-bookings or overlapping reservations.
Automated Confirmations: Instant email notifications sent to the user upon successful booking.
Self-Service Management: A custom web app interface allowing users to view, reschedule, or cancel their existing reservations.
Administrative Log: A dedicated Google Sheet that tracks every transaction for reporting and oversight.

Google Sites, Google Forms, Google Sheets, Google Apps Script, Google Calendar, Gmail, Google Drive.

The system is supported by a comprehensive Employee User Guide for general staff and an Administrator Standard Operating Procedure (SOP) for backend management and troubleshooting.

What This Project Demonstrates

This case study showcases the development of a complex operational ecosystem using native Google Workspace tools. It highlights the ability to transform manual, fragmented tasks into a centralized, automated system that enhances organizational transparency and user efficiency. Key outcomes include:

Strategic Tool Integration: Linking disparate apps (Sites, Forms, Sheets, Calendar) into a single source of truth.
Workflow Automation: Leveraging Google Apps Script to eliminate duplicate data entry and manual notification cycles.
User-Centric Interface Design: Creating clean, accessible portals for employees to manage their own data.
Operational Scalability: Building low-cost, high-impact systems that grow with the organization without increasing licensing overhead.
Data Governance: Implementing automated logs and history sheets to ensure accountability and long-term record keeping.

PORTFOLIO DISCLOSURE: This project is a Portfolio Demonstration created by Kerry Augustin. The 'Sinclair Global' organization, its employees, and all booking data shown in screenshots and the live hub are fictional and intended for test and demonstration purposes only. This system demonstrates functional capabilities in Google Workspace development and operations management.