almost all the Blockchain Explorer APIs that i have seen had some type of Query API which will return Plaintext in their repose that you can use in your google spread sheet
here is blockchain.info https://blockchain.info/q
example:
https://blockchain.info/q/addressbalance/{bitcoinAddress}?confirmations=1
for multiple at once:
https://blockchain.info/q/addressbalance/{add1}|{add2}?confirmations=1

you can change the confirmation to a different number between 0 and 120 to only get the confirmed transactions.