You can have your query that is populating your table from sheets run more periodically via selection in the advanced tab of the query. You can also have a button that triggers a refresh of your table component to ensure that it is as up to date as the the user wants it to be.
1 Like