I have a Google Sheets Watch New Rows trigger on my scenario. I’d like to turn it on every Monday, let it process the new data, and then turn it off once there’s no new data.
I’ve set up a Router with filers for data/no data, BUT the prob is that when the Watch New Rows returns no data it doesn’t actually proceed into the scenario path at all. ie it doesn’t even hit that Router/filtering.
Any suggestions?
Hi @meg and welcome to the Make Community!
The goal of automation is to take some data and do something with it. If there’s no data, it stops. Without this, most people would have to put a filter after their initial trigger to force it to stop if there is no data.
One option is to replace the “Watch New Rows” trigger with a basic trigger followed by a “Search Rows” module. Then, even if it returns no data, you can still execute the rest of your scenario.
L
Welcome to the Make community!
@L_Duperval is correct. The “Watch New Rows” module only continues if there are NEW items.
If you want to continue whether there are new items or none at all, you need to use a search module, with a filter to only process items between now and the previous run. This can be achieved with another column tracking the timestamp or “processed” status.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!
Makes total sense! Appreciate you taking the moment to explain, and thanks for the suggestions for the workaround.
