Hi @Kilian_Boshoff - We do have a product request that will allow Retool Workflows to push live data to apps so I have registered this as another potential use-case for that as right now this is not supported.
That said, we do have some existing workarounds from another community post that might be worth checking out. The first is the ability within the advanced settings of a query to run queries periodically but this obviously can have impact on things like quotas. There's also a blog linked here that might be of interest.