Notification when travel time is >1h and start time of an event named "meeting" is within 2 hours

Configuration
1

I have a (for me) difficult task. I would like to receive a notification (how to send a notification after a trigger is known) when the conditions in the title are met. Unformtunately I really dont know how to start. I know how to create a template from a state. The state is “start_time” and the format is ‘2020-01-18 19:45:00’. Another state is “message” and the state is ‘call meeting office MT’.

So I can make two sensors: First is with start time (how get I rid of date) and second is message. But then… How can I make the condition meeting within 2h set to true?

2

Post both sensor information from the developer tools -> states page, please include the attributes.

3

This are the states from the google calendar. But another meetings has another message. So the message text should contain “meeting” AND time should be within two ours of the starting time. And another sensor should say traveltime more than >2 hours.

Traveltime: (entity sensor by waze)

attribution: Powered by Waze
duration: 77.43333333333334
distance: 130.836
route: A12 - E35; A15 - E31
origin: ‘51.908477, 6.115053’
destination: ‘52.826127, 4.989139’
unit_of_measurement: min
friendly_name: toabbeyroad
icon: ‘mdi:car’

Google calendar:
message: Call meeting office MT
all_day: false
start_time: ‘2020-01-18 19:45:00’
end_time: ‘2020-01-18 21:30:00’
location: ‘Abbeyroad 4’
description: |-
Meeting monthly

offset_reached: false
friendly_name: Officecalendar

4

that timestamp for the start_time is in UTC or Local?

5

This is probably CET. I live in the Netherlands