Best answer

How to filter out weekends events on Google Calendar?

  • 17 December 2021
  • 2 replies
  • 241 views

Userlevel 1

Hi follow Zapers, 

 

I have created a Zap that, everytime I create an activity in my private calendar, it will send an invite to my work calendar. I placed a filter in between, so that it will only process activities between 9am and 5pm.   

So far so good, but I need some assistance with the following:

 

I’d love to be able to filter on days of the week, in order to filter out weekends and my part time day off. Unfortunately, google calendar does not include the specific day in their API export, that would have been easy.

Any thoughts on how to do a work around?

 

Thanks!

 

 

icon

Best answer by mzsadiek 17 December 2021, 16:19

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 1

Thank you @mzsadiek!

 

This was really helpful! 

Userlevel 3
Badge +4

Hi @Pairis! You will need to use ‘Formatter by Zapier’, and select ‘Date/Time’.

Use the date as the input. In ‘To Format’ type in a custom value ‘dddd’ which gives you the name of the day. Make sure the timezones are set correctly, and the ‘From Format’ also.

This gives you the ability to make a filter that only continues when the output is not Saturday and not Sunday :)

Hope this helps.