There is an experimental REQUEST function that can be enabled for self-hosted instances of Grist (with a few caveats) with an interface similar to requests.get.
You can see more information in this thread and how to enable the function once self-hosted in this post.