Get cryptocurrency price on your google sheets with Coinmarketcap API

Best Crypto Exchange 👉 https://bit.ly/cryptoBestPlatform

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: https://gist.github.com/erajanraja24/117bf3de60970ff78d1671153d4eab73

Want to make use of my Portfolio and price alert tracker? - Check out https://gum.co/getCryptoTracker

********** Tutorial Playlists **********
Google apps script tutorial for beginners- https://bit.ly/google-apps-script-tutorial-for-beginners
Automate internet explorer with VBA- https://goo.gl/Xmy8Af
Autoit tutorials for beginners- https://goo.gl/JHB1E2
Selenium Webdriver tutorials for beginners -https://goo.gl/QqxTrF

****** Contact me ********
Blog: http://www.amarindaz.com/contact/
FB page: http://www.facebook.com/amarindaz

******* Books written by me ********
Autoit tutorials for beginners: http://amzn.to/2GjaDbD
Excel VBA for beginners: http://amzn.to/2nhI067

******* Productivity tool *********
My Favorite YouTube Tools ➜ https://goo.gl/MX9Z4p and ➜https://goo.gl/UW1uRX

******* Gear Used To Shoot This Video ******
_Audio & Microphone
http://amzn.to/2GibdGu

********Learning partner********
Video courses ➜https://click.linksynergy.com/fs-bin/click?id=832arX/53N8&offerid=323058.81&type=3&subid=0

Don't forget to subscribe! https://goo.gl/J2453w

💼 To Hire Me 👉 https://fwd.cx/WLGgpTiZW5HK

👉 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 👉 http://bit.ly/get-kite

Видео Get cryptocurrency price on your google sheets with Coinmarketcap API канала Amarindaz