Extracting office location data from Google Calendar using Apps Script

I’m trying to figure out how to retrieve the working location information from Google Calendar through Google Apps Script. I’ve been looking through the documentation but can’t find any methods or properties that would let me access this data.

This isn’t about getting event locations, but rather the working location setting that users can configure in their calendar. Has anyone managed to pull this information programmatically?

I’ve checked the Calendar service reference but nothing seems to match what I need. Any suggestions on how to approach this would be really helpful.

Thanks in advance for any guidance!

Been down this exact rabbit hole - it’s frustrating. Google’s working location feature is new and hasn’t been exposed through Apps Script yet.

Hit this wall 6 months ago when HR wanted a dashboard showing who was working from where. Wasted too much time digging through every API endpoint.

The working location data lives in a different part of Google’s infrastructure than regular calendar events. It’s tied to Workspace’s people management system, not the calendar itself.

Best bet right now: use the Admin SDK Directory API if you’ve got admin access. You can pull user profiles and sometimes get location info, but it’s not the same granular data you see in Calendar.

Workaround: have users add working location as a recurring all-day event with a specific naming convention. Then parse those events with Apps Script. Not elegant, but it works.

Google rolls out API access for new features slowly. Keep checking their release notes - this will probably get added eventually.