With that structure I did have one thought. For the query you have going to your Supabase you could use the query's advanced setting of enabling "run this query periodically" and set it for a duration that you are ok with. That way it will keep refreshing the data in your app without you needing to manually run, but you will need to think about how often you want it to hit your database.
It may also be helpful to check out the provided solution from this forum post: Button Script - Trigger API call, Poll Response and display loading will polling