Pabbly filter does not detect automated changes in a google sheet

[OwenWhoosh]

I am currently creating a reminder system that reminds me and my teammates when a contract is running out. I have set up the whole Pabbly structure and it works, but only when i manually update the sheet. The sheet counts down the days till a contract is running out and Pabbly cannot detect it when it reaches the number I want as a trigger. If i cannot automate it, there is no reason for me to use pabbly.
If there any fix around this? Thank you in advance

 

[Arshita]

Hey @OwenWhoosh

Could you please confirm if you have set up the Google Sheets extension in your Google Sheet?

Also, please confirm if you have selected the Pabbly Connects ad ("Send On Event" or "Auto Send On Event").

While setting up the Google Sheets, if you are getting the data from the Google Application or you are feeding the data manually then you can only use "Send On Event" and if the data is coming from a third-party application then you might need to select "Auto Send On Schedule" and "Send on Schedule" which will take exactly 1 hr to forward it.

Also, check whether the data was getting filled till your triggering column or not.