Hi @Stoyan_Vatov sure.
Below is a screenshot of my existing scenario.
Each week I add about 40-50 new prospects to my google sheet, new prospects are automatically assigned a status of ‘New’ within my google sheet. The intention is that New prospects receive an Email, then the google sheet status column is updated for that prospect (From ‘New’ to ‘Email No.1 Sent’) along with a time stamp and a small delay of about 30 secs before moving on to the next new row/prospect.
Each time I run the scenario I’d like it to execute on 5 rows at a time. (So I’m looking to run this on a custom schedule or very 30 mins or so each day, so that over the course of a day or so it will run through all my prospects/rows.
The intention of the router is to filter prospects so that they receive Emails No.2, No.3, etc. With Email No. 2 going out 7 days after the first email… and Email No. 3 going out 14 days after the the 2nd email.
My filter is working fine.
The challenge I’m having is using the right google sheets module based on how I’d like it to run.
For example when I choose the Watch New Rows, it works fine for the first execution… but then it only picks up the new set of prospects I load the following week… it doesn’t run on the rows that had the status and status timestamp updated. So Email No.1 goes out… but none of the sequential emails.
If I choose the Watch Changes Module, when I run the scenario it picks up the updated rows, but those row don’t pass my filter, then next time it runs, doesn’t pick up that row anymore.
i.e Today it runs on a New Prospect and emails the prospect Email No.1, updates the status to Email No. 1 sent and timestamps it with todays date. The Second path in my router is filtering to status = Email No. Sent no earlier than 7 days ago… so if the Watch Changes Module run tomorrow, it will pick up that prospect but they don’t pass my filter and then are not picked up again my the module.
Hope this helps clarify my post.