Skip to main content
Best answer

How to filter out weekends events on Google Calendar?

  • December 17, 2021
  • 2 replies
  • 310 views

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!

 

 

Best answer by mzsadiekBest answer by mzsadiek

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.

 

View original
Did this topic help you find an answer to your question?
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

mzsadiek
Forum|alt.badge.img+4
  • Zapier Expert
  • 88 replies
  • Answer
  • December 17, 2021

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.

 


  • Author
  • Beginner
  • 1 reply
  • December 17, 2021

Thank you @mzsadiek!

 

This was really helpful!