domainwidedelegation.comStart free

Use cases → Reporting and data

Report on meeting room usage with a service account

Extract room booking data from multiple calendars to analyse real utilisation, not just scheduled events.

Who it is forFacilities and IT teams tracking room demand and usage trends.
APIsCalendar API, Admin SDK
Typical scopescalendar.readonly, admin.directory.resource.calendar.readonly

The problem

Booking a room doesn't mean it was actually used, but calendar data is the only source at scale. Facilities teams need to see real occupancy patterns to avoid over- or under-provisioning space.

How it works

  1. List all calendar resources using the Admin SDK.
  2. For each resource, use the Calendar API to fetch events within the reporting period.
  3. Filter out recurring holds and declined/cancelled events that don't represent real usage.
  4. Aggregate by room, time, and organiser to build the utilisation report.

What changes

Facilities get a clear view of which rooms are actually in use, for how long, and by whom, supporting data-driven space planning.

The trap in this one. Calendar API's events.list omits private event details when the organiser is external or the event is marked private, even for a delegated service account. This means a significant portion of bookings may show up as 'busy' with no organiser or title, making it impossible to distinguish between internal use and third-party holds. This is not a permissions issue, but a data visibility limitation by design.

Watch it explained

“Claude AI + Google Workspace Automation — Integration Guide (Sheets, Docs, Gmail, Drive & Slides)” — BrightN8 | Ai Automation on YouTube. Third-party video, included because it covers this ground well. We are not affiliated with the channel.

Questions people ask

Can I see who booked a room if the event is private?

No—private events or external organiser bookings only return limited metadata. The Calendar API will show 'busy' without further detail, regardless of delegation.

How do I handle recurring events?

Expand recurring events into individual instances and check for cancellations or exceptions before counting them as real usage.

Want this built?

This is a pattern we run in production. We will set up the delegation and build this on top of it — $500 per hour, most of it working the same day.

Talk to us Or read the setup guide

Related use cases

Report on user activity patterns across Workspace

Aggregate and analyse user activity events using a delegated service account to spot trends, anomalies, and compliance issues across multiple users.

Analyse usage of calendar-based resources across the domain

Aggregate and report on how frequently meeting rooms and shared resources are booked, using delegated access to every relevant calendar.

Report Drive storage usage per organisational unit

Aggregate and report Google Drive storage usage for each organisational unit using a delegated service account with Admin SDK access.