Best answer

Notion -- Google Calendar with range date but without time [time glitch]

  • 22 April 2022
  • 1 reply

I’m trying to use Notion as a weekly planner and I usually add my action items first to Notion. It’ll be helpful if this can be automatically added to my google calendar.

I did so by passing the date column from notion (a date range without time as is shown in the picture ), then I let zapier use the property date start and property date end as the google calendar start and end date respectively (I found out that zapier automatically breaks down the notion date range into start and end date).

The issue is, if I set “All Day” as yes, the final calendar event range will be one day short. For example, the original date range in notion is 04.26-04.30, the one shown in the calendar would be 04.26-04.29. It seems if all day is set as yes, google calendar still uses the “dateTime_pretty”, whose time is auto-set as 12:00am, and google calendar does not consider 04.30 12:00am as 04.30 but 04.29 instead.

Can someone help me with this? I can somehow solve the issue by forcing adding one hour to the time to make it 01:00am and set all day as no, but the result look terrible since it’ll show on google calendar.



Best answer by christina.d 26 April 2022, 07:24

View original

1 reply

Userlevel 7
Badge +9

Hey there, @ActuallyAndyYao! Thanks so much for reaching out and welcome to the Community! 🎉

I wonder if some of these posts could help get you on the right track. 🤗 


Adjust date and time values in Zaps


Keep us posted on your progress! We’d love to know!