~~
OP specifically mentioned not wanting to rely on a third party. He is already using a service like you are describing.
yes, i can read.
but also he said this:
~
Everything in in google sheets and automatically updates every time I load it up. Due to api limits/server~~chainz.cryptoid.info/btc/api~~~
which means the problem is in the API service provider he is using. in other words chainz.cryptoid API is limiting him to 1 call per every 10 seconds and this limit does not exist in blockchain.info query so it is not really the same service you see.
besides not relying on a third party means he has to run his own full node and connect to that which i doubt that he wants to do that just for updating his balance based on his comments.