I’ve been playing with https://apipheny.io/
It’s a cool app that allows you to bring API data into your google sheet, without creating scripts or coding.
I’ve been speaking with the founder, and he recorded this video on how to bring data from an API into the sheet, and display it in Glide:
Import Stock Data & Create App From Google Sheets (Apipheny + Glide Demo) - Y
Hope you find it useful!