I bought the Tier 3 app sumo deal a few weeks ago, and the google sheets based triggers (which are supposed to be one of their top 5 use cases) are full of bugs and basically useless. On top of this, their documentation is very sparse, and it's not in product. For instance, to use the edit of a row in a google sheet as a trigger, you need to manually copy and paste a complex app script to your google sheet. This isn't mentioned ANYWHERE in the product itself when setting up the integration.
So, unless you go out of your way to search for help in this trigger (and manage to find it), you won't even know that's a step. And the error you receive if you haven't taken this hidden step does nothing to point you toward doing it. Hours wasted.
Then, if you only want the trigger to fire if a certain column of your row is edited, there's no way to do that. Instead, you need to set up a 'filter' that filters on static values instead of dynamic content from your row. And to make matters worse, these filters don't even work for most of the advertised use cases. They either let everything through, or nothing through, not matter how you set them up. They are especially bad at recognizing blank values, which aren't covered in the docs at all.
I really want to love this product, because it was a great deal, but it's half-baked, and the support is terrible. I have sent 5 different messages about the second issue over 10 days and keep getting back messages like 'give me a minute' and then no response for days. Or just no response at all to some of them. It's frustrating, because I eventually reached one support rep named Maneul on a prior issue, and he was GREAT. He took the time to actually read my ticket, dive into what was going on, and report back on what the company would do about the issue, and how I could work around it. The other two reps I keep running into have been either incompetent, or pulling disappearing acts.
I'm also having trouble with the 'new user joins slack' trigger, but don't have time to detail it.
In fairness, some of the other use cases are working as expected, but with the shoddy docs and non-responsive support, it's been a huge time suck with very little pay off. I won't be canceling zapier anytime soon I guess, but I may return this deal if support can't get their act together.