I’m trying to think of a creative way on how to manually trigger a data sync from within a free version of an app and was wondering if some Glide experts could help validate my solution.
I have data that is being pulled into my google sheets (importHTML() formula) from websites and when data is updated from the website, my sheet receives the data. Only problem is that i don’t think that sort of action is recognized by Glide to sync right away.
A possible workaround I was thinking is to create a button on my App to ‘Fresh’ and grab data. The button would have a glide action attached to it and create a new row in a different table and add it to the google sheets. Then create a script within google sheets that when there is a new row, wait let’s say 1 minute then delete the row. This way the app isn’t using unnecessary rows just for refreshes.
Now my assumption is: Adding a new row will invoke Glide to pull any updates into the glide tables.
Does anyone know if this would work?