Tracking Calendar Event Attendance

Title: Tracking Calendar Event Attendance

Use Case: I needed to determine who attended all of category of meetings over the course of one fiscal year. The meetings and the RSVPs were listed in my bCal. Some meetings were in person, some were remote. I used Google Gemini Canvas to guide me through writing a Google Apps Script that would retrieve this information on an ongoing basis, automatically. This use case is currently in production.

Impact: This immediately created a Google Sheet with the information I was seeking, and where I could query it for further details. The Sheet can also be shared with others. Having attendance information available in a single place for all meetings makes it easier and faster to determine whether recurring missed attendance is occurring. One challenge is that data integrity relies on the accuracy of attendee RSVP reporting in Google Calendar.

Audience: Berkeley IT, IT Policy Program. It is used by approximately I person for all in-person and remote meetings for which I am the organizer.

Risk assessment: This use case involves Berkeley licensed tools appropriate for use with up to P3 information. This use case hasn't been advised upon by risk-related bodies.

For more information: Learn more about the tool from https://gemini.google.com/canvas. For additional questions, contact Jenny Bombasaro Brady.

★ Rate this use case (Berkeley sign-in required) · See top-rated use cases

Inclusion in the AI Use Case Library does not constitute endorsement of any products, tools, or services. Before deploying AI tools for your use case, see Guidance on the Appropriate Use of AI at UC Berkeley and consult applicable policy.