Hi AnsleyWilliams,
Thanks for reaching out with your need for a more seamless trigger workflow in Google Sheets. We understand the importance of this feature for you and have been looking into it.
Unfortunately, due to technical limitations on Google’s end, we’re unable to offer a real-time update solution right now. We’re on it, though, and as soon as we can make it work, we will.
For now, our public API could help manage workflows manually after updates, it’s not perfect, but it might help in the interim.
Appreciate your understanding and patience. We’ll keep you posted.