I drive around a lot for appointments. I want to use Make to pull from my google calendar, then add a meeting before and after my scheduled meetings to account for my driving time. The reason for this is that I then want to use Calendly for people to book calls with me, but I can’t take a call when I am driving and some of my appointments are an hour apart, so I want these to show as “busy” when people look at my availability on calendly.
I have integrated with google calendar and google maps successfully. I am pulling a list of meetings from my calendar. I order them by date so the earlier is first. I need to group them by day, then the first event of each day needs to use the static starting point of my home, and the last event should end at my home. I only need duration from maps, with my arrival time 10 minutes before the meeting starts. So if I am supposed to be in “location1” at 9AM and it takes 50 minutes to drive there and it is my first appointment, I need to pass that start location (my home) and end location (location1) to google maps (with an “arrive by” time of 8:50AM since the meeting is 9AM) and it returns a duration and when I need to leave my home. Then I want Make to add an event on my calendar from 8:00-8:50 and call it “Driving to location1”. I don’t understand how to iterate through the events and how to tag the first and last to be my home.
This seems like a generally useful automation but I can’t find anyone doing it.
Or I’m just making it horribly complicated and there is some checkbox in Google calendar someplace to do this??
Thanks for any help you can provide.
Kevin