~~
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.
One of the problems I ran into was the address needs to be at the end and not in the middle. mysite.info/(insert) works but I never did get mysite.info/(insert)/balance. I have it so when say sell a6 gets an address cell b6 automatically populates the link it at updates it.
I was also thinking last night about the full node. While I am not to worried I do have unlimited bandwidth and a decent speed. If this works I will use some older hardware I have to run this and just have it do its thing. If it were ever compromised all the would get is a empty address.