This is a very good question, and I have to add to it.
My MAIN issue comes after creating an automation.
When I connect the sheet in the initial process, it is confusing how to get it to recognize a new row.
For example, say I connect a sheet, and it has 10 rows in it. When I publish the sheet, does it start on row 11, or does it start after the row I selected in the example data for testing? Or does it start from the top and if no row is ever added to row 2 (because it already existed) then will it never run?
From my testing it is very hard to figure out what is going on and why my automations only seem to start half the time.