Trigger Workflow From Update

AnsleyWilliams

We have data input workbooks set up for a clients that feed to master files we’ve set up to configure and push out custom reports, etc.

We’ve been using importrange & custom app scripts we’ve built internally, but it’s not a great user experience for clients.

Any ideas how I can trigger the workflow for a client when they’re done updating their data input worksheet in google sheets? They update them at different times/schedules/days - and sometimes as needed so the scheduled setting doesn’t work. I don’t want it to do it every 15 minutes or hour, because that’s not necessary, it’s just once a day but the when during the day varies.

Vitor from Sheetgo

Hello AnsleyWilliams I understand your case, I will work with my team to see what’s the best possible solution for your case 😄

Willian from Sheetgo

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.

Eugenia

If you are already using scripts, I feel like leveraging the API might be the best option in your case… You could have a script that detects the last edit on files in a particular folder and compares it with a stored value for last run, hence triggering it when there’s a difference.