• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Find all Google Calendar events tomorrow with a certain word

wibbler

Member
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?
 
P

Pabblymember11

Guest
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

Member
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!
 
Last edited:
P

Pabblymember11

Guest
Hey @wibbler

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

2022-05-24_11h03_29.png
 

wibbler

Member
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.
 
P

PabblyMember3

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

1654260756815.png


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