Build a Crypto Portfolio Tracking App: Part 6 - Persist API Data to Prevent "Error!"

In part 6 we solve for an issue where price data and asset names are unavailable if the coinGecko API has a timeout. This video will show you how to setup a table to store the API data using a scheduled automation.

Crypto prices API endpoint https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&ids={ids}

Google Sheet importJSON() Formula Used in this Video: =importJSON("https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&ids="&join(",",unique(Assets!C2:C)))

CoinGecko API Documenation: https://www.coingecko.com/en/api

importJSON() Github: https://gist.github.com/paulgambill/cacd19da95a1421d3164?_ga=2.236386500.45128186.1638373241-258018777.1638373241

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: https://www.appsheet.com/templates/cryptoportfolio?appGuidString=8b222955-9baf-44e2-984a-80cf0cc3d78a