When I first started using Activepieces I noticed and repeatedly reported very similar fragility to what’s described here. See for example: ⚡ Updated Row Trigger & Insert Multiple Rows Action for Google Sheets - #5 by HoldYourWaffle, Discord thread #1 and Discord thread #2. The Discord threads describe an “identity column(s)” mechanism that can solve this fragility.
I’m in a similar position. I believe in this project and would love to deploy it more widely, but this kind of fragility and unreliability is a wider problem with this otherwise super high potential product.