Click-up to Google Cal

Question

Hi There, I’m having a nightmare with my Zap between Click-Up and Google Calendar.

I use Click-up for my social media content so once a post is approved it is moved into the ‘scheduled’ collumn within Click-up.

I want a Zap to activate when a task moves to ‘scheduled’ within Click-up and to appear as an all day event in Google Cal on it’s designated ‘Due date’ to be posted.

At the moment, I have to select a start and end time for the zap to work, but because this ‘event’ doesn’t actually have that, I have to select ‘due date’ for both start & end options but it won’t appear properly in Google Cal.

Every time I try this the event adds itself to google across multiple days starting at a random point in time or it works for a while and then breaks.

Any help or insight would be much appreciated.

Kind regards,

Sam

icon

Best answer by SamB 7 September 2021, 15:19

View original

SamB · Accepted Answer

Just wanted to follow up here to add that when creating an event using the Google Calendar integration you’ll need to ensure that the date is supplied in MM/DD/YYYY format to prevent the date being interpreted incorrectly: Is the event created on the wrong date, specifically with the month and day switched?

To do that you’d use a Formatter (Date / time > Format) action to convert the date (in the above example this would be the Task Due Date from ClickUp). Then select the reformatted date that’s output from the Formatter step in the Start Date & Time and End Date & Time fields. More on how to format dates here:

Next, as Troy mentioned, you’d need to add +1d to the end date. You would do that by typing in +1d into the End Date & Time field to ensure that the all-day event spans the entire previous day. Like so:

Troy Tessalone · Answer

Hi @Sam_Tern HeadsAre you creating an all-day event?All-day events in Google Calendar end at midnight on the last day, so they're exclusive of the end date. For example, an event created via Zapier for August 10 - August 15 will appear to span August 10 - August 14 in Google Calendar, because the event will end at 12:00:00 on August 15.To fix this:Update your trigger data so that it lasts for an extra day.Or, modify the end date in your Zap directly by adjusting the date/time to include +1d. This will cause the event to last for an extra day.

Are you creating an all-day event?

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded