Integrate Bitcoin price in Google Sheets through Google Script
I suggest using a library for this.
This is the one I use: link
Code would then be: =CRYPTOFINANCE(&quot;COINMARKETCAP:ETH/USD&quot;, &quot;price&quot;)
The library explains itself rather well.