I’ve been wondering about this issue for quite some time. On the one hand, App Script offer incredible features and limitless customization. On the other hand, there’s no doubt that Zapier, Integromat (and others) are far easier to configure. However, these are 3rd party solutions, outside the Google Ecosystem, which means we have to share our data with yet another party. This is no biggy for non-sensitive apps, but when it comes to corporate data and client privacy, it starts to be a dilemma. Yes, it’s encrypted and yes, it’s (supposed to be) safe. Any safeguards we take, we’re still placing our information with another ecosystem.
Am I being too paranoid? These aren’t national security secrets we’re talking about, but these corporate clients would not be very happy if there data is somehow breached.
Also, as I don’t have experience with these services, I don’t really know how easy they are to manage once up and running. App Script is, generally speaking, rather straightforward and simple to support. Same issue, opposite side, I’ve read here that the “On Change” trigger can sometimes underperform. Is it indeed a trigger prone to failures? I don’t recall having such issues when using the “On Form Submit”, during my pre-Glide days. It triggered all the time (or so I think).
Last, but by far not least, I’m not sure these services will allow the total and complete customization we have when coding with App Script. I assume they do offer this, but would be happy to hear from you if you’ve faced some dramatic limitations here.