Uploaded April 2023 | Updated September 2026, 2 weeks ago

---

Important: Please visit youtu.be/CKs83Q_ddoA for updated solution.

In this video, I am going to show you how to pull cryptocurrency data in Google Sheets from CoinMarketCap.

CoinMarketCap is a website that provides information about cryptocurrencies. It was launched in 2013 and has become one of the most popular cryptocurrecny platform today.

📑 Sign Up For CoinMarketCap API: pro.coinmarketcap.com/api

📑 App Scripts Source Code: learndataanalysis.org/source-code-coinmarketcap-crypto-listings-app-scripts-in-google-sheet

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🛒 By shopping on Amazon → amzn.to/2JkGeMD
👩‍💻 Follow me on Linked: linkedin.com/in/jiejenn
🌳 Becoming a Patreon supporter: patreon.com/JieJenn
✉️ Business Inquiring: YouTube@LearnDataAnalysis.org

⏲ Timestamp
00:00 - intro
00:15 - Create CoinMarketCap API key
00:54 - CoinMarketCap API Pricing
01:39 - Free Tier Quota Limit
01:56 - Create AppScript function to pull crypto data
06:21 - Schedule AppScript execution
#googlesheets #appscripts #coinmarket #crypto #cryptocurrency