Hi @Ferret You can use this add on:
So two separate things being dicussed here, I think …
- a way to make the app “client” refresh more often in the background — we’ve discussed this a lot internally. Tough to do without making sync more efficient (less onerous on the backend store). We want to avoid having Drive quota exceptions and other such fun stuff happen to you
- a way to run scheduled automation bots on a finer granularity. Adding @prithpal and @Dan_Bahir to hear this requirement and determine if they can support this
This would be useful to run the BOT not on fixed date/time, but can run dynamically on schedule. Yes, it is potentially increase the load on AppSheet server, but this could be constrained by Automation Limit by putting limit for quota etc to reduce the risk?