Currently the spreadsheet has 10k+ lines in it, but the recipe only triggered until the 1000th. There was a time where the recipe was stopped and started since it was throwing errors (right at the 1000 mark). The recipe was started again and there were additional lines added after that and also updated after.
As additional information about what is in the trigger, the trigger in the recipe is the New/Updated row Real Time trigger, and I have assigned a column to monitor (column 4). There are currently no trigger filters.
What may be causing this and what can be done to get the rest of the rows to trigger it?
In this particular instance, it might be useful to try copying the recipe, and hitting "test" to see if it picks up any changes. Then, you can add a trigger condition to filter out the first 1000 rows, start the recipe, and see if it picks up anything.
In this particular instance, it might be useful to try copying the recipe, and hitting "test" to see if it picks up any changes. Then, you can add a trigger condition to filter out the first 1000 rows, start the recipe, and see if it picks up anything.
Derek Schmidt
Google Sheets: Trigger Not Capturing All Lines
Currently the spreadsheet has 10k+ lines in it, but the recipe only triggered until the 1000th. There was a time where the recipe was stopped and started since it was throwing errors (right at the 1000 mark). The recipe was started again and there were additional lines added after that and also updated after.
As additional information about what is in the trigger, the trigger in the recipe is the New/Updated row Real Time trigger, and I have assigned a column to monitor (column 4). There are currently no trigger filters.
What may be causing this and what can be done to get the rest of the rows to trigger it?
Hey Derek, we typically suggest that anybody with trigger issues follow the following troubleshooting process: https://support.workato.com/support/solutions/articles/1000240921-troubleshooting-my-trigger-isn-t-working-
In this particular instance, it might be useful to try copying the recipe, and hitting "test" to see if it picks up any changes. Then, you can add a trigger condition to filter out the first 1000 rows, start the recipe, and see if it picks up anything.
Kyle Tan
Hey Derek, we typically suggest that anybody with trigger issues follow the following troubleshooting process: https://support.workato.com/support/solutions/articles/1000240921-troubleshooting-my-trigger-isn-t-working-
In this particular instance, it might be useful to try copying the recipe, and hitting "test" to see if it picks up any changes. Then, you can add a trigger condition to filter out the first 1000 rows, start the recipe, and see if it picks up anything.