You probably shouldn’t be querying google sheets directly.
But the problem here is googlesheets is rejecting your with a 4xx
So not an “extensions fault”
Would a Google Cloud Function be a better alternative to this? At the very least it is technically more secure.
Thats up to you to decide based on what your storage services supports and how you want to build it.
Personally I wouldn’t use a cloudfunction as I just don’t use cloud.
I prefer bare metal so I have full control over the infrastructure/caching layers and so on.
A cloudfunction might work here but since I don’t use them I don’t know if it works best here.
It’s also logically possible the front end doesn’t need to call a backend at all and it just returns the data that is written to the configuration service instead.
And you have a cron style function that writes to the configuration service.
Theres many options and some work better than others.
I don’t know if your error with google sheets is becuase loading data client side is allowed by google sheets or not. Or something else. But then I don’t use google sheets as a storage medium.