Thursday, June 1, 2023

Get cryptocurrency price on your google sheets with Coinmarketcap API

Best Crypto Exchange 👉

Learn how to get cryptocurrency price on your google sheets with Coinmarketcap API.

In this video, I’m going to teach you how to get the cryptocurrency price from Coinmarketcap on Google sheets using Coinmarketcap API and google script.

Follow the below steps to get the crypto price on Google Sheets.

You need to sign up for Coinmarketcap API and get the free API key. Put that API key in request options(Copied from API documentation) that we need to pass in the Urlfetch method.

This UrlFetch method accepts two parameters- URL and request option.

In the URL parameter, you have to pass the server URL with the symbol of cryptocurrency that you want to fetch the latest price.

In the params parameter, you have to pass the request options.

once we send a request, we’ll get back HTTP response in return from Coinmarketcap API.

Then, convert the response to string using method getContextText.

The response we got from CoinmarketcapAPI is in JSON format.

We need to parse the JSON using method JSON.parse and get the latest price of the cryptocurrency.

Source code:

Want to make use of my Portfolio and price alert tracker? – Check out

********** Tutorial Playlists **********
Google apps script tutorial for beginners-
Automate internet explorer with VBA-
Autoit tutorials for beginners-
Selenium Webdriver tutorials for beginners –

****** Contact me ********
FB page:

******* Books written by me ********
Autoit tutorials for beginners:
Excel VBA for beginners:

******* Productivity tool *********
My Favorite YouTube Tools ➜ and ➜

******* Gear Used To Shoot This Video ******
_Audio & Microphone

********Learning partner********
Video courses ➜

Don’t forget to subscribe!

💼 To Hire Me 👉

👉 Kite is a free AI-powered coding assistant that will help you code faster & smarter. It integrates seamlessly with all top editors and IDE. Kite gives you smart completions and documentation while you’re typing. I’ve been using Kite on VSCode for 6 months and I love it! Check out Kite 👉

Source link


Leave a Reply

Your email address will not be published.