Identifying the user that have book a meeting room

Google Workspace Developers Q&A
1

Hi there!

We’re building a product called Comeen that is available on the Google Workspace Marketplace.
It’s basically a Workplace Experience Platform built on top of Google Workspace.

In our offer, we have features that enhance meeting room experience.

Our main feature is an automatic Google Chat notification sent through our Google Chat bot.

This notification allows you to check-in or release a meeting room for your upcoming event:

61f2a19dce707e41eef3b004_Group 1104.png
61f2a19dce707e41eef3b004_Group 1104.png1527×1124 149 KB

In order to be the most useful as possible, we’re sending this notification to the user that have added the meeting room to the Google Calendar event.

It’s not necessarily the organiser.

This information isn’t available in the Google Calendar API.
So we’re reading the Google Workspace Audit report in order to identify the right user.

CleanShot 2022-03-18 at 18.54.09@2x.png
CleanShot 2022-03-18 at 18.54.09@2x.png648×782 43.5 KB

While it’s a key feature of our product, some Enterprise Account doesn’t accept to give this scope to our platform, which we understand.

This scope can be given through the Comeen’s Dashboard:

CleanShot 2022-03-18 at 18.56.05@2x.png
CleanShot 2022-03-18 at 18.56.05@2x.png2880×1800 404 KB

I see different possibilities/workaround to solve this issue:

  • Add this information to the Google Calendar API (would be the best),
  • Give more granularity on a u user access to Admin report. For instance: a specific user can only access meeting room calendar informations regarding Audit Report,
  • Our customers build an in-house API to expose data from Admin Report,
  • Our customers export Audit Report to BigQuerry.
    There is a feature in Google Workspace Enterprise that let’s you do the export: https://support.google.com/a/answer/9079365?hl=en
    But we’re not sure that this information is exported since “There are a few differences between the data that’s available in the BigQuery dataset and the data retrieved from the Reports API.”

What’s your feeling on this? Any thoughts?

Thanks a lot,

Benjamin.

2

@tapiamario @CharlesMaxson do you have any recommendations? :slightly_smiling_face:

3

Sent you a DM …

4

Hello Benjamin,

A bit in late but we can understand that some clients don’t want to share all logs and it is a bit overkill in terms of access for just that.

On my side I’m not sure it is the best way. Do you check on watcher side ? https://developers.google.com/calendar/api/v3/reference/events/watch

With Apps Script I had implemented this for demo purpose : https://medium.com/@stephane.giron/react-on-google-calendar-change-with-apps-script-and-eventupdated-trigger-2d092547ab17

With an admin account not necessary a super admin account you can monitor a Salendar Resource and you will get a notification when something change. The bad side is when you receive notification you don’t know who do the action you just get Event ID and you can do and events.get() request. In the request I don’t know if in the resource calendar the owner or actor will be the person that create the event or the person that add the resource ? Must be tested.

I would check on this way intead of the report api.

Stéphane