So I got curious and based on others approaches was able to pretty easily implement this in zapier. I’ll do a full blog post later explaining what I did, but basically set up a checkbox field that I labeled ‘Ready for Update’. I think one of the concerns with update triggers is when to perform them, what if you updated one cell, then in the process of updating the next cell and your process triggers due to the first update. By having a field that you have to check to notify its ready for updating, you avoid that issue.
Then, as Roman suggested, create a view that is filtered to only show rows who have this ‘Ready for Update’ checked.
Then, in zapier, you can perform a lookup for everytime a row is added to this view. That will trigger your workflow.
Then at the end of the workflow, I go back and use the ID i got in the first step, and update that row to uncheck the ‘Ready for Update’. Now if you update it again and check that box, it will re-trigger the workflow again in zapier.
Pretty slick! Full write up to come.