Hi, I’m seeking some help regarding Google Sheets. I’m looking for the correct google sheet module and/or the correct module setting to configure so that each time my scenario runs, it scans the entire sheet.
Ideally, I’d like to use the Watch New Row module, but have the scenario scan the entire sheet each time it runs.
Background on my scenario: I’m loading a list of prospects onto a google sheet, each prospect has a communication status along with a status timestamp that the scenario applies. My scenario contains a filter based on status timestamp.
So I seemingly can not use the Watch Changes module, as at the time of running the scenario will pick up on the row that was updated based on the last scenario run, but it will get filtered out unless it meets my status timestamp requirement… and seemingly will not get picked up again on the next run since there wasn’t a subsequent change.
Any suggestions/tips would be much appreciated.