Google Calendar Offset

[navigonic]

Hi!

I’m trying to setup a light to wake me up 30 min before events on a Google calendar sheet, the sensor turns to ON --> Light turns ON. What I’m trying to do is to have all events in the calendar be read with a x-minute offset, without having to edit them to add “!!-30” to them. Is this possible?

[navigonic]

Maybe there’s a way of checking the start_time interval regularly using an automation? Some kind of logic to check if start_time - x is at the offset one wants the event to trigger?

[navigonic]

Has anyone succeeded in doing something similar?

[Wim_L]

very late reply, but had the same issue. Solved it here:

Calendar date offset

I cannot enter an offset as its a calendar not made by me, only imported, with my daily work schedule To get the offset, without the ‘offset’ title thingie - condition: template value_template:'{% set diff = as_timestamp(states.calendar.treinbestuurder_be.attributes.start_time) -as_timestamp(now()) %}# create a timestamp of the calendar time attr and substract current time {{ diff<32400 and diff > 18000 }}' # compare difference in seconds, will match…