A colleague of mine was building something similar with NFL/College Fantasy and I remember he used this API in his app:
However, you would need a way to get data from their API imported into your Google Sheet, thus keeping your Fantasy Glide app updated for your users.
Cool idea, hope your build goes well!