I spend enormous amounts of time to figure out automation bugs. Testing will show success. Automation monitor will show completed. But it does not work.
Best way is to check in audit history. Most of the time audit history works perfectly because it was implemented in early stages of AppSheet. Features in automation are really messy and a beginner user will have difficult time to understand and fix bugs in automation bots.