'Read smart contract information into google sheets

I am trying to set up an automated google sheet for crypto assets.

In order to get APYs etc I need the ability to get read values from a smart contract IE web3: contract.function.call style.

I do not see that ability in google apps script.

The best idea I have would be to run a server that provides the information in json format that the sheet can request but this is definitely not ideal...

I have looked at several plugins but none appear to read from a smart contract

Is there a way to do this without setting up your own server?

Thanks



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source