Cryptocurrency

How to set up a Google Sheets CoinMarketCap API in order to auto-update Crypto prices.



✅ Feel free to check out my Patreon: https://www.patreon.com/martinvalk

In this video, I teach you how to set up an API in Google Sheets to auto-update the Crypto prices. Give it a try and let me know what you think!

✅ Please consider subscribing: https://bit.ly/3gDnvMy

— — — — — — — — — —

𝐈𝐍𝐅𝐎:

🔗 𝐂𝐨𝐢𝐧𝐌𝐚𝐫𝐤𝐞𝐭𝐂𝐚𝐩 𝐀𝐏𝐈 𝐋𝐢𝐧𝐤:
https://coinmarketcap.com/api/

𝐌𝐞𝐭𝐡𝐨𝐝:
GET

𝐀𝐏𝐈 𝐔𝐑𝐋 𝐩𝐚𝐭𝐡:
https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?limit=3000

𝐎𝐀𝐮𝐭𝐡:
None

𝐇𝐞𝐚𝐝𝐞𝐫𝐬:
X-CMC_PRO_API_KEY
API Key
Accept
application/json

𝐃𝐞𝐬𝐭𝐢𝐧𝐚𝐭𝐢𝐨𝐧 𝐬𝐡𝐞𝐞𝐭:
CMC API

𝐍𝐚𝐦𝐞:
CMC API

— — — — — — — — — —

𝐋𝐈𝐍𝐊𝐒:

𝐊𝐞𝐯𝐢𝐧 𝐂𝐚𝐠𝐞 𝐰𝐚𝐥𝐤𝐢𝐧𝐠 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐦𝐲 𝐂𝐫𝐲𝐩𝐭𝐨 𝐏𝐨𝐫𝐭𝐟𝐨𝐥𝐢𝐨 𝐓𝐫𝐚𝐜𝐤𝐞𝐫:
🔗 https://www.youtube.com/watch?v=PEQNnt3-Wmo

𝐌𝐲 𝐂𝐫𝐲𝐩𝐭𝐨 𝐏𝐨𝐫𝐭𝐟𝐨𝐥𝐢𝐨 𝐓𝐫𝐚𝐜𝐤𝐞𝐫:
🔗 https://docs.google.com/spreadsheets/d/1W2thDH2VomGgg704gdd9leJKS6LuY2su2Vy0fZ6Nlr8/edit?usp=sharing

— — — — — — — — — —

🔗 𝐖𝐞𝐛𝐬𝐢𝐭𝐞: https://www.BullishSwag.com
High-quality Crypto gifts and merchandise, check it out and let me know if you would like me to add anything specific.

🔗 𝐓𝐰𝐢𝐭𝐭𝐞𝐫: https://twitter.com/martincpvalk
Please consider following me on Twitter, it means a lot to me, and it is where I share the most information.

🔗 𝐓𝐢𝐤𝐓𝐨𝐤: https://www.tiktok.com/@martincpvalk
On TikTok, I put out short (60-second max) videos keeping you up to date with all the crypto news.

🔗 𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦: https://www.instagram.com/mcpvalk/
On Instagram, I share my “Falcon Crypto Rating” scores as well as short videos (60-second max) to keep you up to date with all the important news.

🔗 𝐔𝐧𝐬𝐭𝐨𝐩𝐩𝐚𝐛𝐥𝐞 𝐃𝐨𝐦𝐚𝐢𝐧𝐬: https://unstoppabledomains.com/r/2ce1e79bd9f849d
Use this link and get $10 off your first purchase worth $40 or more!

— — — — — — — — — —

⚠️ Everything I talk about is my opinion and is for information purposes only. It is not intended to be investment advice. Seek a duly licensed professional for investment advice.

#Crypto #API #Price

42 Comments

  6. Ruud de Nooij

    Thanks, I tried and followed all steps. API set up and CMC API tab is filled with data. But on the MAIN tab, it does not fetch the prices of the crypto i have filled out on the tab Exchanges Used & Crypto Owned. Is there a solution?

  7. Jean-Luc Scheefer

    Nice one !!
    Based on your idea, I did an improvment of it if you'd like it.
    Let's say you have your crypto portfolio on several lines where the first column is the id of the crypto.
    The sheet is going to take the first values of the first colum to query the only crypto needed. Then it will fill the portfolios prices as you did.
    The request is going really fast and only request for 10 cryptos if the portfolio contains 10 cryptos.
    If you'd like to have this version, just tell me.

  11. Ben.

    Great video Martin. I’ve had this exact question for a while now, glad to see this as a solution!
    Question for you – Would this same type of CMC API integration be possible in the Mac Notes app for documents that aren’t spreadsheets? Of course I see you’re using an extension for the API via Google Sheets, but I’m wondering if something similar is possible in Notes, maybe with a bit of coding? Let me know your thoughts, and thanks for all your work. ✊🏽

  17. Lachlan M.

    Thanks Martin – was very easy to follow. I got the price to display and all went well until the very last step of Refreshing All on the API Connector. Got the following Error Message:

    Reports ran: 2

    1) Demo Request: Request ran successfully

    2) CMC API: Completed with errors

    – We received an error from the API server (400) show response

    {"status":{"timestamp":"2021-11-06T01:40:41.187Z","error_code":400,"error_message":""limit" must be less than or equal to 5000","elapsed":0,"credit_count":0}}

    I have my limit set to 9000 in order to fetch the small caps that I play with (certified degen right here). This worked initially to pull the data but appears will not work when refreshing the data?

  24. Ans Gibson

    This is great Martin! Very excellent, I never knew you could add the APIs into Sheets! This helps with the passive income and node tracker sheet I was working on.

  32. TokyoSander

    Hey Martin. Love this tracker. Great visual aid. Asked some questions on Patreon also, but today it seems there is an issue with the API refreshing. Can you confirm the issue ?

  35. Carven Yong

    Great video and explanations! Is the API connector free version enough to use for this purpose? I saw there saying subsription valid until 2021 Nov 24 in your video.

  38. kathleen smith

    Nice presentation — but how to you get it to automatically update — it really annoys when you guys leave this stuff out and I know you do it on purpose. Plus you don't answer any of the questions. Now why would someone join your account?

  42. Tony Tones

    i get this message : It looks like your formula is missing one or more open parentheses. If you don't want to enter a formula, begin your text with an apostrophe (').

    i done exactly what you did?? =VLOOKUP(AG3,'CMC API'!I:BE,47,false)

    fully stressing me out lol

    strangley i done this method before and it worked so whats going on?? please help..somebody..anyone out there??

Write A Comment

Share via