Could I use Zapier to sync work location from Google Calendar to e.g. Sheets or Slack?
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.
Page 1 / 1
Hello @Jean
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.
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.
@Jean
You’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.