Okay, understood.
So I don’t think connecting the Google Sheet to your App is the solution, as you’ll still have sync delays to deal with.
I think you probably have two options:
- Deploy your script as a cloud function, in the same way that Andrew Davies did in that thread that Thinh linked to earlier.
- Find an alternative weather API (one that doesn’t require authentication), and call it directly from Glide using JavaScript.
The second option would be easier, I think. I’m pretty sure there are lots of free weather API’s out there. You could do it with your current API, but you would be risking exposing your API key.