We’d like to keep an overview of where people are working.
Could I use Zapier to sync work location from Google Calendar to e.g. Sheets and/or Slack?
I’m thinking this would be a daily scheduled sync, with possibly an additional Zap triggered on working location update. However I’ve not found an obvious way to get this info for all org members.
Hello
You may use zapier to sync work locations across google calendar; google sheets,. Create a daily zap that triggers on calendar events containing specified location related keywords. This Zap can collect location data and update a shared Google Sheet.
+14Hi
Zap trigger: Schedule - Daily
If you are trying to pull multiple GCal Events, then the GCal API would need to be used.
https://developers.google.com/calendar/api/guides/overview
Thanks for the responses so far. They’re not quite what I have in mind.
In Calendar you can set your normal working locations, and override it as needed by directly updating the calendar.
The event.list API looks relevant, however querying for {"eventTypes": ["workingLocation"]} returns 400 lines of events for one user. I would like to get just the working location for today, and I’d like to get it for all org members.
I realize that this is probably more of a Google API question than a Zapier question, but I’m hoping that someone here has struggled with this before.
+14You’d likely have to further refine the API request based on the API endpoint documentation.
Try asking ChatGPT for help configuring the proper API request.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
