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.