Build a Crypto Portfolio Tracking App: Part 4 - APIs and importJSON()

In part 4 we connect a Google Sheet to the CoinGecko market aggregator API to retrieve a current list of all cryptocurrency assets in our app.
importJSON() Github: gist.github.com/paulgambill/c...
Google Sheet formula to retrieve asset list from CoinGecko API:
=importJSON("api.coingecko.com/api/v3/coin...")
CoinGecko API Documentation:
www.coingecko.com/en/api
-----------------------------------
This is a series where we build a Crypto/Stock Portfolio tracking app from scratch. The helps users efficiently track Bitcoin, Ethereum, and stock market assets prices and networth. This video teaches advanced concepts such as creating change logs, retrieving information from APIs.
Template app that you can copy for your personal use: www.appsheet.com/templates/cr...

[@fouadmaizar2914]

Hi, Thanks , this is very helpful.

[@Ottodecar]

Hi! First of all i want ti thank your for this videos. I was very usefull for me. I am using this guide as a second project, i discovered appsheet for mm purposes. I get to the fourth video to find out that coingecko has made a change on their policy and now the importJSON formula is not working anymore, resulting in an error. May I ask you if is there a solution to that issue already? I am just guessing it could be related to reducin the calls rate to the API. Thanks in advance, i am not a professional programmer but i am doing my best effort.

[@appify]

I am releasing a video tomorrow that should help with this. It will go over how to do API calls with Apps Script and return values to AppSheet.