Find all Google Calendar events tomorrow with a certain word

[wibbler]

Every day, I want my workflow to find all Google Calendar events tomorrow which have [certain word] in description.

What is the best way to do this?

- When I choose "Search Events", I can only search for a string, not a timeframe. This will search for [certain word] in the whole of the calendar (I presume) which will find thousands of entries - certainly, the workflow goes incredibly slowly when this is set. I can then filter to a timeframe with Router but there would only be one Route and this doesn't seem very intuitive or efficient. It also (I think) only finds one entry and then stops.

- When I choose "Get All Events", again it will find all the events in the calendar, and the workflow is slow again and must have a high overhead on Pabbly's resource too. too. I then have to filter on timeframe and [certain word] in the Router. Again, I think it also only finds one entry and then stops.

What would be ideal is if Search Events could search in a timeframe and apply the following actions to all results it finds. Or is there another route I am missing?

 

[Pabblymember11]

Hey @wibbler

Can you briefly tell us what filter condition you wanted to use in your workflow to get the specific Google Events from your calendar?

 

[wibbler]

I want to find all events in my calendar that have a date of TOMORROW and have a certain text string.

Then, I want to extract the email address from the description of each one it finds (I know how to do this), and send an email to each one (at the moment, I think I can only act on one of the instances it finds).

Even "find all events in my calendar that have a date of TOMORROW" seems hard currently, but maybe I'm doing it wrong.

Thanks!

 

[Pabblymember11]

Hey @wibbler

Please check out the following screenshot for your above filter condition which you can use in your workflow.

 

[wibbler]

Hi,

This sadly is not resolved, as Pabbly cannot find more than (i think) 250 events at a time. The search you describe finds more than 250 events, and so does not reach the events that I need, and anyway is not a very efficient way to search!

This really is turning into a feature request - can you add functionality on "Search Events" to search a Timeframe?
For example, find all events tomorrow (which is my use case?) so I can send out a pre-event email.
Or another use case is: find all events that happened yesterday (so that I can send an after-event email).

I'm moving from Automate.io - what they do is scan for events, and then allow me to specify a certain number of minutes before or after an event in the workflow. Zapier also allow this.

 

[PabblyMember3]

@wibbler Just added the requested action in the Google Calendar application.

Could you please try that and let us know your feedback.

 

[wibbler]

Wow, that was a really fast implementation, thank you! I have set it up and will report back. It should be working within 24 hours.