Scenario stops processing new rows after initial run – filter issue?

[Werley]

Expected behaviour:
My goal is to send random emails to a list of contacts in Google Sheets, following these steps:

1. I have a Google Sheet containing my contacts with columns like name, email, Statut de l’email, and Random. The Statut de l’email column is empty at the start.
2. I’m using the Watch Rows module to retrieve rows from the Google Sheet.

• No filter is applied at this stage since I want to process all rows.

3. A filter is then applied to check if the “Statut de l’email” column is empty.

• Filter condition: {{Statut de l'email}} = empty (which means the email hasn’t been sent yet).

4. The scenario uses a Router, which, based on the value in the Random column (1, 2, or 3), randomly selects one of three emails to send.

• Filter 1 (Route 1): If {{Random}} = 1, the first email is sent.
• Filter 2 (Route 2): If {{Random}} = 2, the second email is sent.
• Filter 3 (Route 3): If {{Random}} = 3, the third email is sent.

5. After sending the email, another module Update a Row updates the Statut de l’email column to “Envoyé” for that contact.
6. The scenario is supposed to run every 45 minutes, processing remaining contacts by sending emails to those with an empty Statut de l’email.

---

Current behaviour:
Here’s what’s happening:

1. During the first run, the first three contacts receive their emails correctly, and the Statut de l’email column is updated to “Envoyé”.
2. During subsequent runs (every 45 minutes), the scenario doesn’t seem to process the other contacts, even though their Statut de l’email is empty.
3. The filter seems to get stuck on the first three rows, and the scenario doesn’t move on to the next rows.
4. I’ve checked that the remaining rows have an empty Statut de l’email and a value in the Random column, but they still aren’t processed.
5. I’m using Watch Rows without a filter initially to retrieve all rows, but that doesn’t seem to solve the problem.

---

What I’ve done:

• In the first Google Sheet, I have the columns name, email, Statut de l’email, and Random.
• I’ve used a Watch Rows module to retrieve these rows, without applying any filter at this stage.
• After that, I applied a filter to check that the Statut de l’email is empty.
• The Router uses the value in the Random column to randomly select which email to send.
• After the email is sent, the Statut de l’email column is updated to “Envoyé” with an Update a Row module.
• The scenario is supposed to run every 45 minutes, continuing to process unprocessed contacts, but after the first three emails, nothing happens for the remaining contacts.

---

Questions:

• Should I use a different module than Watch Rows to ensure all contacts with an empty Statut de l’email are retrieved?
• Could the issue be with the filter or Router, which is not moving to the next rows after the first run?
• Is it possible that the scenario is stuck on the first rows and not processing the new rows during the next runs?

Thanks in advance for your advice and help!