CINXE.COM

<!DOCTYPE html><html lang="en"><head><meta charSet="utf-8"/><meta name="twitter:card" content="summary_large_image"/><meta name="twitter:site" content="@CoinMarketCap"/><meta name="twitter:creator" content="@CoinMarketCap"/><meta property="og:image:alt" content="CoinMarketCap Academy"/><meta property="og:site_name" content="CoinMarketCap Academy"/><script>window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'UA-40475998-1');</script><meta name="viewport" content="width=device-width, initial-scale=1.0"/><link rel="preconnect" href="https://api.coinmarketcap.com/alexandria/api"/><link rel="preconnect" href="https://academy-public.coinmarketcap.com"/><link rel="shortcut icon" href="https://coinmarketcap.com/academy/images/ico/favicon.ico"/><link rel="icon" type="image/x-icon" sizes="16x16 32x32" href="https://coinmarketcap.com/academy/images/ico/favicon.ico"/><link rel="icon" sizes="32x32" href="https://coinmarketcap.com/academy/images/ico/favicon-32.png"/><link rel="icon" sizes="192x192" href="https://coinmarketcap.com/academy/images/ico/favicon-192.png"/><link rel="manifest" href="/manifest.json"/><meta name="theme-color" content="#2e2e2e"/><meta name="apple-mobile-web-app-capable" content="yes"/><meta name="apple-mobile-web-app-status-bar-style" content="black-translucent"/><meta name="ahrefs-site-verification" content="86f2f08131d8239e3a4d73b0179d556eae74fa62209b410a64ff348f74e711ea"/><meta name="google-site-verification" content="wyJEt1aEuf8X_of3aofK_Tl5WprWou38Ze4o3ZeeGts"/><meta name="naver-site-verification" content="e70af2cacdaf993fe72ef9fd208822bbebc2e028"/><meta name="yandex-verification" content="7e56260ff92b3c3f"/><script> (function(h,o,t,j,a,r){ h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)}; h._hjSettings={hjid:1060636,hjsv:6}; a=o.getElementsByTagName('head')[0]; r=o.createElement('script');r.async=1; r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv; a.appendChild(r); })(window,document,'https://static.hotjar.com/c/hotjar-','.js?sv='); </script><script charSet="UTF-8">var projectName="cmc",sensors=window.sensorsDataAnalytic201505;!function(e){var t=e.sdk_url,r=e.name,s=window,n=document,a="script",c=null,o=null;if(void 0!==s.sensorsDataAnalytic201505)return!1;s.sensorsDataAnalytic201505=r,s[r]=s[r]||function(e){return function(){(s[r]._q=s[r]._q||[]).push([e,arguments])}};for(var i=["track","quick","register","registerPage","registerOnce","clearAllRegister","trackSignup","trackAbtest","setProfile","setOnceProfile","appendProfile","incrementProfile","deleteProfile","unsetProfile","identify","login","logout","trackLink"],l=0;l<i.length;l++)s[r][i[l]]=s[r].call(null,i[l]);s[r]._t||(c=n.createElement(a),o=n.getElementsByTagName(a)[0],c.async=1,c.src=t,c.setAttribute("charset","UTF-8"),s[r].para=e,o.parentNode.insertBefore(c,o))}({sdk_url:"https://cdn.jsdelivr.net/npm/sa-sdk-javascript@1.23.1/sensorsdata.min.js",name:"sensors",web_url:"https://anylysis.sasdconsoles.com/?project="+projectName,server_url:"https://sensors.saasexch.com/sa?project="+projectName,is_track_single_page:!0,use_client_time:!0,send_type:"beacon",app_js_bridge:!0,show_log:!1,heatmap:{scroll_notice_map:"scroll_notice_map",collect_tags:{div:!0}}});sensors.registerPage({ df_5:function(){try{return localStorage.getItem("continuousUid")}catch(e){console.error(e)}}});</script><link rel="alternate" href="https://coinmarketcap.com/academy/article/how-to-integrate-coinmarketcap-api-with-google-sheets" hrefLang="en"/><link rel="alternate" hrefLang="x-default" href="https://coinmarketcap.com/academy/article/how-to-integrate-coinmarketcap-api-with-google-sheets"/><title>How to integrate CoinMarketCap API with Google Sheets | CoinMarketCap</title><meta name="robots" content="index,follow"/><meta name="googlebot" content="index,follow"/><meta name="description" content="Learn how to integrate CoinMarketCap API with Google Sheets"/><meta property="og:url" content="https://coinmarketcap.com/academy/article/how-to-integrate-coinmarketcap-api-with-google-sheets"/><meta property="og:type" content="article"/><meta property="og:title" content="How to integrate CoinMarketCap API with Google Sheets | CoinMarketCap"/><meta property="og:description" content="Learn how to integrate CoinMarketCap API with Google Sheets"/><meta property="og:image" content="https://academy-public.coinmarketcap.com/optimized-uploads/23daa0764a1244b9993851f43d6bc2dd.png"/><link rel="canonical" href="https://coinmarketcap.com/academy/article/how-to-integrate-coinmarketcap-api-with-google-sheets"/><meta name="robots" content="max-image-preview:large"/><script> (function() { var _sf_async_config = window._sf_async_config = (window._sf_async_config || {}); _sf_async_config.uid = 66377; _sf_async_config.domain = "coinmarketcap.com"; _sf_async_config.path = window && window.location && (window.location.host + window.location.pathname); _sf_async_config.flickerControl = false; _sf_async_config.authors = "CoinMarketCap"; _sf_async_config.sections = "How-to Guides"; function loadChartbeat() { var e = document.createElement('script'); var n = document.getElementsByTagName('script')[0]; e.type = 'text/javascript'; e.async = true; e.src = '//static.chartbeat.com/js/chartbeat.js'; n.parentNode.insertBefore(e, n); } loadChartbeat(); })(); </script><script async="" src="//static.chartbeat.com/js/chartbeat_mab.js"></script><script type="application/ld+json">{ "@context": "https://schema.org", "@type": "Article", "mainEntityOfPage": { "@type": "WebPage", "@id": "https://coinmarketcap.com/academy/article/how-to-integrate-coinmarketcap-api-with-google-sheets" }, "headline": "How to integrate CoinMarketCap API with Google Sheets", "image": [ "https://academy-public.coinmarketcap.com/optimized-uploads/23daa0764a1244b9993851f43d6bc2dd.png" ], "datePublished": "2023-11-27T15:28:43.735Z", "dateModified": "2023-11-27T16:05:59.760Z", "author": {"@type": "Person","name": "CoinMarketCap"}, "publisher": { "@type": "Organization", "name": "CoinMarketCap", "logo": { "@type": "ImageObject", "url": "https://coinmarketcap.com/academy/images/apple-touch-icon.png" } }, "description": "Learn how to integrate CoinMarketCap API with Google Sheets" }</script><link rel="preload" as="image" imagesrcset="https://academy-public.coinmarketcap.com/optimized-uploads/23daa0764a1244b9993851f43d6bc2dd.png 1x, https://academy-public.coinmarketcap.com/optimized-uploads/23daa0764a1244b9993851f43d6bc2dd.png 2x"/><meta name="next-head-count" content="41"/><link rel="preload" href="/academy/fonts/inter/Inter-Light.woff2" as="font" type="font/woff2" crossorigin="anonymous"/><link rel="preload" href="/academy/fonts/inter/Inter-Regular-new.woff2" as="font" type="font/woff2" crossorigin="anonymous"/><link rel="preload" href="/academy/fonts/inter/Inter-Medium-new.woff2" as="font" type="font/woff2" crossorigin="anonymous"/><link rel="preload" href="/academy/fonts/inter/Inter-SemiBold-new.woff2" as="font" type="font/woff2" crossorigin="anonymous"/><noscript data-n-css=""></noscript><script defer="" nomodule="" src="/academy/_next/static/chunks/polyfills-c67a75d1b6f99dc8.js"></script><script src="/academy/_next/static/chunks/webpack-d71eb689cc8b029c.js" defer=""></script><script src="/academy/_next/static/chunks/framework-79bce4a3a540b080.js" defer=""></script><script src="/academy/_next/static/chunks/main-8bdf0f52bb8e5f2f.js" defer=""></script><script src="/academy/_next/static/chunks/pages/_app-edd7ddbb38071a06.js" defer=""></script><script src="/academy/_next/static/chunks/7333-208862063e788035.js" defer=""></script><script src="/academy/_next/static/chunks/5675-c533e9dd4ffb9e8e.js" defer=""></script><script src="/academy/_next/static/chunks/1216-adf5b65e656b6355.js" defer=""></script><script src="/academy/_next/static/chunks/8852-fd471e3425bb32c2.js" defer=""></script><script src="/academy/_next/static/chunks/8480-f990c2145bab0a16.js" defer=""></script><script src="/academy/_next/static/chunks/5907-242064479deba16b.js" defer=""></script><script src="/academy/_next/static/chunks/8309-a3d53741d9546e4e.js" defer=""></script><script src="/academy/_next/static/chunks/6951-96d082638485567b.js" defer=""></script><script src="/academy/_next/static/chunks/5098-904e60f58fbad254.js" defer=""></script><script src="/academy/_next/static/chunks/pages/article/%5Bslug%5D-4e1306f201ae081c.js" defer=""></script><script src="/academy/_next/static/oHakgmGhbYgYmk5auBHHF/_buildManifest.js" defer=""></script><script src="/academy/_next/static/oHakgmGhbYgYmk5auBHHF/_ssgManifest.js" defer=""></script><style data-styled="" data-styled-version="5.2.1">.cKSfzR{color:#000;width:20px;height:20px;}/*!sc*/ .guyNMq{color:#000;width:32px;}/*!sc*/ .uqPkp{vertical-align:middle;color:#000;width:32px;height:intrinsic;}/*!sc*/ .dLcezr{font-size:18px;color:#000;font-weight:400;line-height:1.45;}/*!sc*/ .kCeqsc{vertical-align:middle;width:20px;}/*!sc*/ .kmkzFK{width:20px;height:20px;}/*!sc*/ .gmJjjk{padding:8px;max-height:none;}/*!sc*/ @media screen and (min-width:768px){.gmJjjk{max-height:400px;}}/*!sc*/ @media screen and (min-width:1200px){.gmJjjk{max-height:400px;}}/*!sc*/ .jZXIMD{color:#FFFFFF;-webkit-box-pack:justify;-webkit-justify-content:space-between;-ms-flex-pack:justify;justify-content:space-between;width:100%;margin-left:24px;-webkit-flex:1;-ms-flex:1;flex:1;display:none;}/*!sc*/ @media screen and (min-width:768px){.jZXIMD{display:none;}}/*!sc*/ @media screen and (min-width:1200px){.jZXIMD{display:block;}}/*!sc*/ .eBAqEu{width:12px;margin-left:8px;}/*!sc*/ .hGITez{padding:8px;}/*!sc*/ .bRtkcJ{font-size:16px;color:#000;font-weight:400;line-height:1.45;}/*!sc*/ .ecKBcM{vertical-align:middle;width:24px;height:24px;}/*!sc*/ .kGZDmf{max-width:752px;min-height:calc(100vh - 208px);padding-top:24px;padding-bottom:24px;padding-left:16px;padding-right:16px;}/*!sc*/ .lifqWE{-webkit-transform:translateY(-100px);-ms-transform:translateY(-100px);transform:translateY(-100px);}/*!sc*/ .cjnMxG{white-space:nowrap;overflow:hidden;text-overflow:ellipsis;-webkit-order:1;-ms-flex-order:1;order:1;-webkit-box-flex:1;-webkit-flex-grow:1;-ms-flex-positive:1;flex-grow:1;-webkit-flex-basis:75%;-ms-flex-preferred-size:75%;flex-basis:75%;font-weight:500;padding-right:8px;color:#14151A;font-size:16px;line-height:1.45;}/*!sc*/ @media screen and (min-width:768px){.cjnMxG{-webkit-flex-basis:auto;-ms-flex-preferred-size:auto;flex-basis:auto;}}/*!sc*/ .gQbnxJ{display:none;-webkit-order:2;-ms-flex-order:2;order:2;margin-left:0;}/*!sc*/ @media screen and (min-width:768px){.gQbnxJ{-webkit-order:3;-ms-flex-order:3;order:3;margin-left:24px;}}/*!sc*/ @media screen and (min-width:1200px){.gQbnxJ{display:block;}}/*!sc*/ .jvVtgT{-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-box-pack:center;-webkit-justify-content:center;-ms-flex-pack:center;justify-content:center;}/*!sc*/ .fWNSXR{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-order:3;-ms-flex-order:3;order:3;margin-left:0;-webkit-box-pack:end;-webkit-justify-content:flex-end;-ms-flex-pack:end;justify-content:flex-end;-webkit-box-flex:1;-webkit-flex-grow:1;-ms-flex-positive:1;flex-grow:1;}/*!sc*/ @media screen and (min-width:768px){.fWNSXR{-webkit-order:3;-ms-flex-order:3;order:3;margin-left:24px;-webkit-box-flex:0;-webkit-flex-grow:0;-ms-flex-positive:0;flex-grow:0;}}/*!sc*/ @media screen and (min-width:1200px){.fWNSXR{display:none;}}/*!sc*/ .gSUsoi{width:24px;height:24px;}/*!sc*/ .haGBPZ{-webkit-order:2;-ms-flex-order:2;order:2;}/*!sc*/ @media screen and (min-width:768px){.haGBPZ{-webkit-order:2;-ms-flex-order:2;order:2;}}/*!sc*/ .fJwUeL{font-size:12px;color:#14151A;font-weight:400;line-height:1.45;}/*!sc*/ @media screen and (min-width:768px){.fJwUeL{font-size:16px;}}/*!sc*/ .erLLvd{width:8px;margin-left:8px;}/*!sc*/ .blnIOn{background-color:#3861FB;}/*!sc*/ .jStWLp{color:#3861FB;font-size:16px;font-weight:400;line-height:1.45;}/*!sc*/ .hoXOTC{font-size:24px;margin-bottom:16px;line-height:1.3;color:#14151A;font-weight:600;}/*!sc*/ @media screen and (min-width:768px){.hoXOTC{font-size:32px;margin-bottom:32px;}}/*!sc*/ .clhOqr{color:#76808F;font-size:16px;margin-right:16px;font-weight:400;line-height:1.45;}/*!sc*/ .kKBMco{vertical-align:middle;width:16px;height:16px;color:#76808F;}/*!sc*/ .gtVAYr{color:#76808F;margin-left:4px;font-size:16px;font-weight:400;line-height:1.45;}/*!sc*/ .eDxZZL{color:#76808F;margin-right:16px;font-size:16px;font-weight:400;line-height:1.45;}/*!sc*/ .ihJtHv{padding-top:24px;padding-bottom:24px;padding-left:32px;padding-right:32px;margin-top:16px;margin-bottom:16px;font-size:16px;}/*!sc*/ @media screen and (min-width:768px){.ihJtHv{padding-top:40px;padding-bottom:40px;margin-top:40px;margin-bottom:40px;}}/*!sc*/ .eEqGWC{background-color:#F8FAFD;padding-top:24px;padding-bottom:24px;padding-left:32px;padding-right:32px;margin-top:24px;}/*!sc*/ @media screen and (min-width:768px){.eEqGWC{padding-top:32px;padding-bottom:32px;}}/*!sc*/ .ksiqdi{font-size:24px;margin-bottom:8px;color:#14151A;font-weight:600;line-height:1.45;}/*!sc*/ .bjGZcz{color:#3861FB;font-weight:600;font-size:16px;line-height:1.45;}/*!sc*/ .cdVqKV{padding-left:0;padding-right:0;padding-top:16px;padding-bottom:16px;max-width:1136px;}/*!sc*/ @media screen and (min-width:768px){.cdVqKV{padding-top:56px;padding-bottom:56px;}}/*!sc*/ .iLpgJa{margin-bottom:32px;color:#14151A;font-size:16px;font-weight:600;line-height:1.45;}/*!sc*/ .kVrfYF{overflow-wrap:break-word;margin-bottom:24px;font-size:16px;line-height:1.6;color:#14151A;font-weight:400;}/*!sc*/ @media screen and (min-width:768px){.kVrfYF{margin-bottom:32px;font-size:18px;}}/*!sc*/ .gbfvns{color:#3861FB;font-size:16px;font-weight:400;line-height:1.45;}/*!sc*/ @media screen and (min-width:768px){.gbfvns{font-size:18px;}}/*!sc*/ .iumvLK{padding-top:32px;padding-bottom:32px;background-color:#F5F5F5;padding-left:24px;padding-right:24px;margin-bottom:40px;}/*!sc*/ .fdbMey{font-size:16px;font-weight:700;line-height:1.6;margin-top:16px;color:#14151A;}/*!sc*/ .byJUJo{color:#14151A;font-size:16px;font-weight:400;line-height:1.45;}/*!sc*/ .gPOvAF{margin-top:24px;margin-bottom:48px;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-box-pack:center;-webkit-justify-content:center;-ms-flex-pack:center;justify-content:center;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;}/*!sc*/ .hZZWDZ{height:20px;width:24px;color:#808A9D;}/*!sc*/ .bFLuOX{margin-left:8px;font-size:14px;color:#14151A;font-weight:400;line-height:1.45;}/*!sc*/ .dCEoLC{max-width:752px;padding-top:24px;padding-bottom:24px;padding-left:16px;padding-right:16px;}/*!sc*/ .dBQaiO{background-color:#F8FAFD;padding-top:40px;padding-bottom:40px;margin-top:56px;}/*!sc*/ .kA-dzTb{max-width:1136px;padding-top:24px;padding-bottom:24px;padding-left:16px;padding-right:16px;}/*!sc*/ .bjGlIw{font-size:32px;color:#14151A;font-weight:600;line-height:1.45;}/*!sc*/ .bGWzuD{padding-top:56px;padding-bottom:56px;}/*!sc*/ .iXxiMt{display:block;}/*!sc*/ .ftOUaZ{margin-bottom:24px;padding-top:56.25%;}/*!sc*/ .jzZbpr{margin-bottom:24px;-webkit-flex:1;-ms-flex:1;flex:1;}/*!sc*/ .bXSEgn{color:#14151A;margin-bottom:8px;font-size:16px;font-weight:600;line-height:1.45;}/*!sc*/ .hOMFgM{color:#76808F;font-size:14px;font-weight:400;line-height:1.45;}/*!sc*/ .fDPsJm{color:#76808F;font-size:12px;font-weight:400;line-height:1.45;}/*!sc*/ .hAnSfs{vertical-align:middle;width:12px;height:12px;color:#76808F;}/*!sc*/ .czscDz{color:#76808F;margin-left:4px;font-size:12px;font-weight:400;line-height:1.45;}/*!sc*/ .bwxocM{vertical-align:middle;width:24px;}/*!sc*/ .jKSHrp{max-width:1200px;padding-top:24px;padding-bottom:24px;padding-left:16px;padding-right:16px;}/*!sc*/ .iCRjms{padding-top:56px;padding-bottom:56px;background-color:#F5F5F5;}/*!sc*/ .bFOiFL{font-size:16px;text-align:center;color:#3861FB;margin-bottom:24px;font-weight:400;line-height:1.45;}/*!sc*/ @media screen and (min-width:768px){.bFOiFL{text-align:left;}}/*!sc*/ @media screen and (min-width:1200px){.bFOiFL{font-size:18px;}}/*!sc*/ .epLOPA{font-size:24px;margin-bottom:8px;text-align:center;line-height:1.2;color:#14151A;font-weight:600;}/*!sc*/ @media screen and (min-width:768px){.epLOPA{text-align:left;}}/*!sc*/ @media screen and (min-width:1200px){.epLOPA{font-size:32px;}}/*!sc*/ data-styled.g1[id="sc-bdfBwQ"]{content:"cKSfzR,guyNMq,uqPkp,dLcezr,kCeqsc,kmkzFK,gmJjjk,jZXIMD,eBAqEu,hGITez,bRtkcJ,ecKBcM,kGZDmf,lifqWE,cjnMxG,gQbnxJ,jvVtgT,fWNSXR,gSUsoi,haGBPZ,fJwUeL,erLLvd,blnIOn,jStWLp,hoXOTC,clhOqr,kKBMco,gtVAYr,eDxZZL,ihJtHv,eEqGWC,ksiqdi,bjGZcz,cdVqKV,iLpgJa,kVrfYF,gbfvns,iumvLK,fdbMey,byJUJo,gPOvAF,hZZWDZ,bFLuOX,dCEoLC,dBQaiO,kA-dzTb,bjGlIw,bGWzuD,iXxiMt,ftOUaZ,jzZbpr,bXSEgn,hOMFgM,fDPsJm,hAnSfs,czscDz,bwxocM,jKSHrp,iCRjms,bFOiFL,epLOPA,"}/*!sc*/ .inJjsD{position:relative;height:80px;-webkit-box-pack:justify;-webkit-justify-content:space-between;-ms-flex-pack:justify;justify-content:space-between;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;background-color:#ffffff;padding-left:16px;padding-right:16px;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ @media screen and (min-width:768px){.inJjsD{padding-left:24px;padding-right:24px;}}/*!sc*/ .fBYRBQ{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ @media screen and (min-width:768px){.fBYRBQ{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}}/*!sc*/ @media screen and (min-width:1200px){.fBYRBQ{display:none;}}/*!sc*/ .jUEeyM{-webkit-box-pack:justify;-webkit-justify-content:space-between;-ms-flex-pack:justify;justify-content:space-between;margin-bottom:24px;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ .kupqjK{-webkit-box-pack:justify;-webkit-justify-content:space-between;-ms-flex-pack:justify;justify-content:space-between;margin-bottom:0;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ .irrFZf{-webkit-box-pack:justify;-webkit-justify-content:space-between;-ms-flex-pack:justify;justify-content:space-between;margin-top:24px;margin-bottom:24px;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ .kSSfgv{-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ .leStXf{color:#000;margin-right:32px;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ .cZWuHU{-webkit-box-pack:center;-webkit-justify-content:center;-ms-flex-pack:center;justify-content:center;padding-left:16px;padding-right:16px;padding-top:16px;padding-bottom:16px;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ .kAuvPc{-webkit-box-pack:center;-webkit-justify-content:center;-ms-flex-pack:center;justify-content:center;margin-left:16px;margin-right:16px;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ .cHCQYY{-webkit-flex:1;-ms-flex:1;flex:1;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ .bgZavq{box-shadow:0px 0px 1px rgba(20,21,26,0.1),0px 7px 14px rgba(71,77,87,0.08),0px 3px 6px rgba(20,21,26,0.08);height:auto;-webkit-flex-wrap:wrap;-ms-flex-wrap:wrap;flex-wrap:wrap;padding-left:24px;padding-right:24px;padding-top:8px;padding-bottom:8px;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ @media screen and (min-width:768px){.bgZavq{height:64px;-webkit-flex-wrap:nowrap;-ms-flex-wrap:nowrap;flex-wrap:nowrap;padding-left:24px;padding-right:24px;padding-top:0;padding-bottom:0;}}/*!sc*/ @media screen and (min-width:1200px){.bgZavq{padding-left:56px;padding-right:56px;}}/*!sc*/ .hSEAzV{cursor:pointer;color:#474D57;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ .qFvDU{margin-bottom:24px;-webkit-flex-wrap:wrap;-ms-flex-wrap:wrap;flex-wrap:wrap;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ @media screen and (min-width:768px){.qFvDU{margin-bottom:48px;}}/*!sc*/ .jZlgey{display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;margin-right:16px;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ .hFwcgf{-webkit-box-pack:center;-webkit-justify-content:center;-ms-flex-pack:center;justify-content:center;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ .ghfBCu{-webkit-flex-direction:column;-ms-flex-direction:column;flex-direction:column;-webkit-align-items:start;-webkit-box-align:start;-ms-flex-align:start;align-items:start;height:100%;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ .hoYWsg{padding-bottom:8px;font-size:12px;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ .gvdfNf{padding-bottom:24px;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ .dSCuHF{display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;margin-left:16px;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ data-styled.g2[id="sc-gsTCUz"]{content:"inJjsD,fBYRBQ,jUEeyM,kupqjK,irrFZf,kSSfgv,leStXf,cZWuHU,kAuvPc,cHCQYY,bgZavq,hSEAzV,qFvDU,jZlgey,hFwcgf,ghfBCu,hoYWsg,gvdfNf,dSCuHF,"}/*!sc*/ .jcleUz{-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;border:1px solid transparent;border-radius:4px;display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;font-weight:500;-webkit-box-pack:center;-webkit-justify-content:center;-ms-flex-pack:center;justify-content:center;white-space:nowrap;outline:0;font-size:14px;height:32px;line-height:20px;padding-left:16px;padding-right:16px;background-color:#F5F5F5;color:#14151A;}/*!sc*/ .jcleUz:hover{cursor:pointer;}/*!sc*/ .jcleUz:focus{box-shadow:0 0 0 2px #222531;}/*!sc*/ .jcleUz:disabled{cursor:not-allowed;}/*!sc*/ .jcleUz:hover:not(:disabled){background-color:#F2F2F2;}/*!sc*/ .jcleUz:active:not(:disabled){background-color:#F5F5F5;}/*!sc*/ .jcleUz:focus{background-color:#FAFAFA;}/*!sc*/ .jcleUz:disabled{background-color:#F5F5F5;color:#76808F;}/*!sc*/ .cCzBkx{-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;border:1px solid transparent;border-radius:4px;display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;font-weight:500;-webkit-box-pack:center;-webkit-justify-content:center;-ms-flex-pack:center;justify-content:center;white-space:nowrap;outline:0;font-size:16px;height:48px;line-height:24px;padding-left:16px;padding-right:16px;background-image:linear-gradient(180deg,#3861FB 0%,#3861FB 100%);color:#fff;border-width:0;}/*!sc*/ .cCzBkx:hover{cursor:pointer;}/*!sc*/ .cCzBkx:focus{box-shadow:0 0 0 2px #222531;}/*!sc*/ .cCzBkx:disabled{cursor:not-allowed;}/*!sc*/ .cCzBkx:hover:not(:disabled){background-image:linear-gradient(180deg,#3861FB 0%,#3861FB 100%);}/*!sc*/ .cCzBkx:active:not(:disabled){background-image:linear-gradient(180deg,#3861FB 0%,#3861FB 100%);}/*!sc*/ .cCzBkx:focus{background-image:linear-gradient(180deg,#3861FB 0%,#3861FB 100%);}/*!sc*/ .cCzBkx:disabled{background-image:none;background-color:linear-gradient(180deg,#3861FB 0%,#3861FB 100%);color:#fff;}/*!sc*/ .bxNOKk{-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;border:1px solid transparent;border-radius:4px;display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;font-weight:500;-webkit-box-pack:center;-webkit-justify-content:center;-ms-flex-pack:center;justify-content:center;white-space:nowrap;outline:0;font-size:14px;height:40px;line-height:20px;padding-left:16px;padding-right:16px;border-radius:8px;background-color:#222531;color:#FFFFFF;}/*!sc*/ .bxNOKk:hover{cursor:pointer;}/*!sc*/ .bxNOKk:focus{box-shadow:0 0 0 2px #222531;}/*!sc*/ .bxNOKk:disabled{cursor:not-allowed;}/*!sc*/ .bxNOKk:hover:not(:disabled){background-color:#2B2F36;}/*!sc*/ .bxNOKk:active:not(:disabled){background-color:#2B2F36;}/*!sc*/ .bxNOKk:focus{background-color:#2B2F36;}/*!sc*/ .bxNOKk:disabled{background-color:#F5F5F5;color:#76808F;}/*!sc*/ data-styled.g3[id="Button__StyledButton-sc-1kvh4an-0"]{content:"jcleUz,cCzBkx,bxNOKk,"}/*!sc*/ .cEbvLE{margin-left:0.5em;}/*!sc*/ .cEbvLE svg{display:block;}/*!sc*/ data-styled.g4[id="Button__EndIcon-sc-1kvh4an-1"]{content:"cEbvLE,"}/*!sc*/ .khdEkh{margin:auto;}/*!sc*/ data-styled.g8[id="Container-sc-4c5vqs-0"]{content:"khdEkh,"}/*!sc*/ .eYLPhT{display:grid;grid-template-columns:1fr;grid-gap:8px;grid-template-rows:auto;}/*!sc*/ @media screen and (min-width:768px){}/*!sc*/ @media screen and (min-width:1200px){.eYLPhT{grid-template-columns:1fr;}}/*!sc*/ .hhlnuT{display:grid;grid-template-columns:1fr 1fr;grid-template-rows:auto;}/*!sc*/ .hfyApF{display:grid;grid-template-columns:repeat(4,1fr);grid-gap:16px;grid-template-rows:auto;}/*!sc*/ .iaLNSR{display:grid;grid-template-rows:repeat(4,1fr);grid-gap:16px;grid-template-columns:auto;}/*!sc*/ .ZAQjM{display:grid;grid-gap:16px;grid-template-columns:1fr;grid-template-rows:auto;}/*!sc*/ @media screen and (min-width:768px){.ZAQjM{grid-template-columns:1fr 1fr;}}/*!sc*/ @media screen and (min-width:1200px){.ZAQjM{grid-template-columns:1fr 1fr 1fr;}}/*!sc*/ data-styled.g9[id="Grid-sc-3uwl3g-0"]{content:"eYLPhT,hhlnuT,hfyApF,iaLNSR,ZAQjM,"}/*!sc*/ .dAnDNe{word-break:break-word;}/*!sc*/ .ehzvDo{font-size:32px;line-height:40px;word-break:break-word;}/*!sc*/ .gYQtxK{font-size:24px;line-height:32px;word-break:break-word;}/*!sc*/ .ffRerq{font-size:18px;line-height:28px;word-break:break-word;}/*!sc*/ data-styled.g13[id="Heading-juwhnu-0"]{content:"dAnDNe,ehzvDo,gYQtxK,ffRerq,"}/*!sc*/ .bBRENP{background-color:#ffffff;border-radius:4px;box-shadow:0px 0px 1px rgba(0,0,0,0.1),0px 3px 6px rgba(0,0,0,0.04),0px 1px 2px rgba(0,0,0,0.04);position:relative;}/*!sc*/ data-styled.g25[id="Dropdown__Menu-egbkvi-0"]{content:"bBRENP,"}/*!sc*/ .dpplru{display:none;position:absolute;width:-webkit-max-content;width:-moz-max-content;width:max-content;z-index:1000;bottom:100%;left:auto;padding:0 0 16px 0;right:auto;top:auto;}/*!sc*/ @media screen and (min-width:768px){.dpplru{bottom:auto;left:auto;padding:16px 0 0 0;right:auto;top:100%;}}/*!sc*/ .gaITVH{display:none;position:absolute;width:-webkit-max-content;width:-moz-max-content;width:max-content;z-index:1000;bottom:auto;left:auto;padding:16px 0 0 0;right:auto;top:100%;}/*!sc*/ .jrosAA{display:none;position:absolute;width:-webkit-max-content;width:-moz-max-content;width:max-content;z-index:1000;bottom:auto;left:auto;padding:16px 0 0 0;right:0;top:100%;}/*!sc*/ .jpFHJB{display:none;position:absolute;width:-webkit-max-content;width:-moz-max-content;width:max-content;z-index:1000;bottom:auto;left:auto;padding:16px 0 0 0;right:auto;top:100%;}/*!sc*/ @media screen and (min-width:768px){.jpFHJB{bottom:auto;left:auto;padding:16px 0 0 0;right:0;top:100%;}}/*!sc*/ data-styled.g26[id="Dropdown__DropdownWrapper-egbkvi-1"]{content:"dpplru,gaITVH,jrosAA,jpFHJB,"}/*!sc*/ .iOZaIg{display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;position:relative;}/*!sc*/ .iOZaIg:after{border-color:transparent;border-style:solid;border-width:8px;content:"";display:none;height:0;position:absolute;-webkit-transform:translate(rotate(-45deg));-ms-transform:translate(rotate(-45deg));transform:translate(rotate(-45deg));-webkit-transform-origin:0 0;-ms-transform-origin:0 0;transform-origin:0 0;width:0;z-index:1001;}/*!sc*/ .iOZaIg:hover::after,.iOZaIg:focus-within::after{border-color:#FFFFFF transparent transparent transparent;bottom:100%;display:block;-webkit-filter:drop-shadow(0px 2px 1px rgba(0,0,0,0.1));filter:drop-shadow(0px 2px 1px rgba(0,0,0,0.1));left:50%;margin-left:-8px;right:auto;top:auto;}/*!sc*/ @media screen and (min-width:768px){.iOZaIg:hover::after,.iOZaIg:focus-within::after{bottom:auto;border-color:transparent transparent #FFFFFF transparent;display:block;-webkit-filter:drop-shadow(0px -1px 1px rgba(0,0,0,0.1));filter:drop-shadow(0px -1px 1px rgba(0,0,0,0.1));left:50%;margin-left:-8px;right:auto;top:100%;}}/*!sc*/ .iOZaIg:hover .Dropdown__DropdownWrapper-egbkvi-1,.iOZaIg:focus-within .Dropdown__DropdownWrapper-egbkvi-1,.iOZaIg.wrapper--open .Dropdown__DropdownWrapper-egbkvi-1{display:block;}/*!sc*/ .hjcGbS{display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;position:relative;}/*!sc*/ .hjcGbS:after{border-color:transparent;border-style:solid;border-width:8px;content:"";display:none;height:0;position:absolute;-webkit-transform:translate(rotate(-45deg));-ms-transform:translate(rotate(-45deg));transform:translate(rotate(-45deg));-webkit-transform-origin:0 0;-ms-transform-origin:0 0;transform-origin:0 0;width:0;z-index:1001;}/*!sc*/ .hjcGbS:hover::after,.hjcGbS:focus-within::after{bottom:auto;border-color:transparent transparent #FFFFFF transparent;display:block;-webkit-filter:drop-shadow(0px -1px 1px rgba(0,0,0,0.1));filter:drop-shadow(0px -1px 1px rgba(0,0,0,0.1));left:50%;margin-left:-8px;right:auto;top:100%;}/*!sc*/ .hjcGbS:hover .Dropdown__DropdownWrapper-egbkvi-1,.hjcGbS:focus-within .Dropdown__DropdownWrapper-egbkvi-1,.hjcGbS.wrapper--open .Dropdown__DropdownWrapper-egbkvi-1{display:block;}/*!sc*/ .dKySxu{display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;position:relative;}/*!sc*/ .dKySxu:after{border-color:transparent;border-style:solid;border-width:8px;content:"";display:none;height:0;position:absolute;-webkit-transform:translate(rotate(-45deg));-ms-transform:translate(rotate(-45deg));transform:translate(rotate(-45deg));-webkit-transform-origin:0 0;-ms-transform-origin:0 0;transform-origin:0 0;width:0;z-index:1001;}/*!sc*/ .dKySxu:hover::after,.dKySxu:focus-within::after{bottom:auto;border-color:transparent transparent #FFFFFF transparent;display:block;-webkit-filter:drop-shadow(0px -1px 1px rgba(0,0,0,0.1));filter:drop-shadow(0px -1px 1px rgba(0,0,0,0.1));left:50%;margin-left:-8px;right:auto;top:100%;}/*!sc*/ @media screen and (min-width:768px){.dKySxu:hover::after,.dKySxu:focus-within::after{bottom:auto;border-color:transparent transparent #FFFFFF transparent;display:block;-webkit-filter:drop-shadow(0px -1px 1px rgba(0,0,0,0.1));filter:drop-shadow(0px -1px 1px rgba(0,0,0,0.1));left:50%;margin-left:-8px;right:auto;top:100%;}}/*!sc*/ .dKySxu:hover .Dropdown__DropdownWrapper-egbkvi-1,.dKySxu:focus-within .Dropdown__DropdownWrapper-egbkvi-1,.dKySxu.wrapper--open .Dropdown__DropdownWrapper-egbkvi-1{display:block;}/*!sc*/ data-styled.g27[id="Dropdown__Wrapper-egbkvi-2"]{content:"iOZaIg,hjcGbS,dKySxu,"}/*!sc*/ .jmfAe{-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;background-color:transparent;border:0;border-radius:4px;color:#000;cursor:pointer;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;height:40px;-webkit-box-pack:center;-webkit-justify-content:center;-ms-flex-pack:center;justify-content:center;outline:0;padding:0;width:40px;}/*!sc*/ .jmfAe:hover{background-color:#ccc;}/*!sc*/ .jmfAe:focus{box-shadow:0 0 0 2px #3861FB;}/*!sc*/ data-styled.g31[id="NavButton-sc-1sr7lbk-0"]{content:"jmfAe,"}/*!sc*/ .gitnvH{position:fixed;top:80px;right:16px;max-height:100%;max-width:343px;width:100%;pointer-events:none;}/*!sc*/ data-styled.g32[id="notification__NotificationContainer-ru7pbh-0"]{content:"gitnvH,"}/*!sc*/ .hQeyNG{width:60px;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;}/*!sc*/ .hQeyNG svg{height:40px;display:block;}/*!sc*/ .hQeyNG svg:first-child{padding-right:8px;}/*!sc*/ .hQeyNG svg:last-child{padding-left:8px;}/*!sc*/ data-styled.g34[id="Logo__SvgContainer-hxzlkl-0"]{content:"hQeyNG,"}/*!sc*/ .iOKdEn{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;border-radius:8px;padding:16px;background:transparent;color:#000;}/*!sc*/ .iOKdEn:hover{background:#000;color:#fff;}/*!sc*/ @media screen and (max-width:767px){.iOKdEn:hover{background:inherit;color:inherit;}}/*!sc*/ data-styled.g36[id="ListCTA__Link-rp0q6e-0"]{content:"iOKdEn,"}/*!sc*/ @media screen and (max-width:1200px){.iSSjsx{color:#ffffff;background-color:#ffffff;width:50px;height:50px;}.iSSjsx:hover{background-color:#F5F5F5;}}/*!sc*/ data-styled.g38[id="LanguageSwitcher__Button-sc-1rgi4yk-0"]{content:"iSSjsx,"}/*!sc*/ .cZFSA-d{padding:16px 24px;}/*!sc*/ data-styled.g39[id="MainPanel__Container-dujdt9-0"]{content:"cZFSA-d,"}/*!sc*/ .ljOoWA{background:#ffffff;padding:16px 24px 80px 24px;}/*!sc*/ data-styled.g40[id="MainPanel__ListContainer-dujdt9-1"]{content:"ljOoWA,"}/*!sc*/ .cIKCMm:hover{background-color:#f8fafd;}/*!sc*/ data-styled.g41[id="Navbar__MenuItem-zbdsw1-0"]{content:"cIKCMm,"}/*!sc*/ .jabPmx{position:fixed;background:#ffffff;top:0;right:-375px;width:100%;max-width:375px;height:100vh;overflow-y:auto;-webkit-transition:right 0.4s;transition:right 0.4s;z-index:11;}/*!sc*/ data-styled.g44[id="Panel__Wrapper-rgznpu-0"]{content:"jabPmx,"}/*!sc*/ .jtlwNr{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-box-pack:justify;-webkit-justify-content:space-between;-ms-flex-pack:justify;justify-content:space-between;padding:16px 24px;background:#ffffff;}/*!sc*/ data-styled.g45[id="Panel__Header-rgznpu-1"]{content:"jtlwNr,"}/*!sc*/ .hbrKEE{display:none;}/*!sc*/ data-styled.g47[id="Navbar__Input-midvey-1"]{content:"hbrKEE,"}/*!sc*/ .LHhmf{margin-left:8px;}/*!sc*/ data-styled.g48[id="Navbar__Label-midvey-2"]{content:"LHhmf,"}/*!sc*/ .fJcvOH{background-color:#fff;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;max-width:375px;overflow:hidden;position:absolute;right:0;top:0;-webkit-transition:width 400ms linear;transition:width 400ms linear;width:0;box-shadow:1px 1px 2px 0 rgb(88 102 126 / 42%),4px 4px 40px 0 rgb(88 102 126 / 28%);margin-top:8px;}/*!sc*/ data-styled.g50[id="SearchForm-sc-1vfffbc-0"]{content:"fJcvOH,"}/*!sc*/ .hZCLgD{background-color:#fff;border:0;color:#000;font-size:20px;width:100%;height:64px;outline:0;padding-left:24px;padding-right:24px;}/*!sc*/ data-styled.g51[id="SearchForm__Input-sc-1vfffbc-1"]{content:"hZCLgD,"}/*!sc*/ .eSLlrc{background-color:transparent;border:0;color:#000;cursor:pointer;height:64px;outline:0;width:64px;}/*!sc*/ data-styled.g52[id="SearchForm__CloseButton-sc-1vfffbc-2"]{content:"eSLlrc,"}/*!sc*/ .cMwSJN{-webkit-flex:1;-ms-flex:1;flex:1;}/*!sc*/ data-styled.g53[id="SearchForm__Label-sc-1vfffbc-3"]{content:"cMwSJN,"}/*!sc*/ .cgHWSS{padding:24px;}/*!sc*/ .cgHWSS footer{background:#12141d;color:#fff;padding:48px;border-radius:16px;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;}/*!sc*/ .cgHWSS footer > *{-webkit-flex:1;-ms-flex:1;flex:1;}/*!sc*/ .cgHWSS .logo svg path{fill:#fff;}/*!sc*/ .cgHWSS .social{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-box-pack:center;-webkit-justify-content:center;-ms-flex-pack:center;justify-content:center;}/*!sc*/ .cgHWSS .social > a svg{height:32px;margin:0 12px;}/*!sc*/ .cgHWSS .copyright{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-box-pack:end;-webkit-justify-content:flex-end;-ms-flex-pack:end;justify-content:flex-end;}/*!sc*/ @media screen and (max-width:930px){.cgHWSS footer{-webkit-flex-direction:column;-ms-flex-direction:column;flex-direction:column;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;}.cgHWSS footer > *{padding:16px 0;}}/*!sc*/ data-styled.g55[id="Footer__FooterContainer-sc-1xgrmdq-1"]{content:"cgHWSS,"}/*!sc*/ @font-face{font-family:"Inter";font-style:normal;font-weight:300;font-display:swap;src:url("/academy/fonts/inter/Inter-Light.woff2") format("woff2"),url("/fonts/inter/Inter-Light.woff") format("woff");}/*!sc*/ @font-face{font-family:"Inter";font-style:normal;font-weight:400;font-display:swap;src:url("/academy/fonts/inter/Inter-Regular-new.woff2") format("woff2"),url("/fonts/inter/Inter-Regular-new.woff") format("woff");}/*!sc*/ @font-face{font-family:"Inter";font-style:normal;font-weight:500;font-display:swap;src:url("/academy/fonts/inter/Inter-Medium-new.woff2") format("woff2"),url("/fonts/inter/Inter-Medium-new.woff") format("woff");}/*!sc*/ @font-face{font-family:"Inter";font-style:normal;font-weight:600;font-display:swap;src:url("/academy/fonts/inter/Inter-SemiBold-new.woff2") format("woff2"),url("/fonts/inter/Inter-SemiBold-new.woff") format("woff");}/*!sc*/ :root{--tooltip-border-radius:4px;--tooltip-color:#0B0E11;--tooltip-text-color:#FFFFFF;--tooltip-font-size:12px;--tooltip-move:4px;}/*!sc*/ html,body,div,span,applet,object,iframe,h1,h2,h3,h4,h5,h6,p,blockquote,pre,a,abbr,acronym,address,big,cite,code,del,dfn,em,img,ins,kbd,q,s,samp,small,strike,strong,sub,sup,tt,var,b,u,i,center,dl,dt,dd,ol,ul,li,fieldset,form,label,legend,table,caption,tbody,tfoot,thead,tr,th,td,article,aside,canvas,details,embed,figure,figcaption,footer,header,hgroup,menu,nav,output,ruby,section,summary,time,mark,audio,video{margin:0;padding:0;border:0;font-size:100%;vertical-align:baseline;}/*!sc*/ article,aside,details,figcaption,figure,footer,header,hgroup,menu,nav,section{display:block;}/*!sc*/ body{line-height:1;}/*!sc*/ ol,ul{list-style:disc;list-style-position:inside;}/*!sc*/ blockquote,q{quotes:none;}/*!sc*/ blockquote:before,blockquote:after,q:before,q:after{content:"";content:none;}/*!sc*/ table{border-collapse:collapse;border-spacing:0;}/*!sc*/ *,*::before,*::after{box-sizing:border-box;}/*!sc*/ *{font-family:"Inter","Helvetica Neue",Arial,sans-serif;}/*!sc*/ [role="button"]{cursor:pointer;}/*!sc*/ body{background-color:#FFFFFF;}/*!sc*/ a{color:inherit;-webkit-text-decoration:none;text-decoration:none;}/*!sc*/ .no-scroll{overflow:hidden;}/*!sc*/ svg,img{max-width:100%;height:auto;}/*!sc*/ iframe{max-width:100%;}/*!sc*/ .coverImage{border-radius:16px;}/*!sc*/ amp-img img{object-fit:contain;}/*!sc*/ data-styled.g56[id="sc-global-bMnJLL1"]{content:"sc-global-bMnJLL1,"}/*!sc*/ .kEBbNN{list-style-position:outside;margin-left:16px;margin-bottom:24px;}/*!sc*/ .kEBbNN li{font-size:16px;}/*!sc*/ @media screen and (min-width:768px){.kEBbNN li{font-size:20px;}}/*!sc*/ .kEBbNN li:not(:last-child){margin-bottom:4px;}/*!sc*/ .kEBbNN li ul{margin-top:16px;}/*!sc*/ .kEBbNN li > ul{margin-left:16px;}/*!sc*/ data-styled.g62[id="Renderer__List-mfgg8t-1"]{content:"kEBbNN,"}/*!sc*/ .ldGcwa{cursor:pointer;-webkit-box-pack:center;-webkit-justify-content:center;-ms-flex-pack:center;justify-content:center;width:24px;height:24px;-webkit-transition:ease-out 0.2s;transition:ease-out 0.2s;color:#76808F;}/*!sc*/ .ldGcwa:hover{color:#1DA1F2;}/*!sc*/ .ldGcwa svg{width:100%;height:100%;}/*!sc*/ .kINMVY{cursor:pointer;-webkit-box-pack:center;-webkit-justify-content:center;-ms-flex-pack:center;justify-content:center;width:24px;height:24px;-webkit-transition:ease-out 0.2s;transition:ease-out 0.2s;color:#76808F;}/*!sc*/ .kINMVY:hover{color:#4267B2;}/*!sc*/ .kINMVY svg{width:100%;height:100%;}/*!sc*/ .kWcfCj{cursor:pointer;-webkit-box-pack:center;-webkit-justify-content:center;-ms-flex-pack:center;justify-content:center;width:24px;height:24px;-webkit-transition:ease-out 0.2s;transition:ease-out 0.2s;color:#76808F;}/*!sc*/ .kWcfCj:hover{color:#0088cc;}/*!sc*/ .kWcfCj svg{width:100%;height:100%;}/*!sc*/ .sHTpX{cursor:pointer;-webkit-box-pack:center;-webkit-justify-content:center;-ms-flex-pack:center;justify-content:center;width:24px;height:24px;-webkit-transition:ease-out 0.2s;transition:ease-out 0.2s;color:#76808F;}/*!sc*/ .sHTpX:hover{color:black;}/*!sc*/ .sHTpX svg{width:100%;height:100%;}/*!sc*/ data-styled.g68[id="SocialLink__IconWrapper-sc-1toayxk-0"]{content:"ldGcwa,kINMVY,kWcfCj,sHTpX,"}/*!sc*/ .eMGdpa{-webkit-transition:width 300ms linear 0s;transition:width 300ms linear 0s;height:4px;}/*!sc*/ data-styled.g70[id="ProgressBar__Bar-sc-7ekl2x-0"]{content:"eMGdpa,"}/*!sc*/ .eMCbwr{background-color:#FFFFFF;position:fixed;top:0;left:0;width:100%;-webkit-transition:-webkit-transform 0.3s ease-in;-webkit-transition:transform 0.3s ease-in;transition:transform 0.3s ease-in;z-index:1;}/*!sc*/ data-styled.g71[id="StickyBarWrapper__Wrapper-sc-8z2dej-0"]{content:"eMCbwr,"}/*!sc*/ .iPCECF{border-radius:8px;height:40px;padding:0;width:40px;}/*!sc*/ data-styled.g72[id="SocialShareMobile__IconButton-wlnyr9-0"]{content:"iPCECF,"}/*!sc*/ .estnki{padding:16px;width:60px;}/*!sc*/ data-styled.g73[id="SocialShareMobile__Menu-wlnyr9-1"]{content:"estnki,"}/*!sc*/ .PywUU{padding:16px;max-height:calc(100vh - 105px);max-width:320px;overflow-y:auto;width:100%;}/*!sc*/ data-styled.g74[id="StickyBar__ToC-rk0m1f-0"]{content:"PywUU,"}/*!sc*/ .eGrglv{border-radius:8px;font-weight:300;line-height:1.45;padding:16px;}/*!sc*/ .eGrglv:hover{background-color:#f5f5f5;cursor:pointer;}/*!sc*/ data-styled.g75[id="StickyBar__ToCButton-rk0m1f-1"]{content:"eGrglv,"}/*!sc*/ @media screen and (min-width:832px){.bVYJZw{margin:0 -40px;width:calc(100% + 80px);max-width:calc(100vw - 32px);}.bVYJZw > *{width:100%;}}/*!sc*/ data-styled.g76[id="ArticleCover__CoverBox-sc-9pmloj-0"]{content:"bVYJZw,"}/*!sc*/ .ljODsN h2 a,.ljODsN h3 a,.ljODsN h4 a{font-size:inherit;}/*!sc*/ .ljODsN figure.w-richtext-figure-type-video{margin:0 auto 32px;}/*!sc*/ .ljODsN figure.w-richtext-figure-type-video.w-richtext-figure-type-video{height:0;width:60%;position:relative;}/*!sc*/ .ljODsN figure.w-richtext-figure-type-video.w-richtext-figure-type-video.w-richtext-align-fullwidth{width:100%;}/*!sc*/ .ljODsN figure.w-richtext-figure-type-video.w-richtext-figure-type-video iframe{position:absolute;top:0;left:0;height:100%;}/*!sc*/ .ljODsN figure.w-richtext-figure-type-video iframe{width:100%;}/*!sc*/ .ljODsN figure,.ljODsN img{margin-bottom:16px;}/*!sc*/ @media screen and (min-width:768px){.ljODsN figure,.ljODsN img{margin-bottom:32px;}}/*!sc*/ .ljODsN .twitter-tweet-rendered{margin:0 auto;}/*!sc*/ .ljODsN .disclaimer{margin-top:24px;margin-bottom:24px;color:#58667e;font-size:12px;line-height:20px;}/*!sc*/ .ljODsN .disclaimer p{margin-bottom:8px;}/*!sc*/ .ljODsN .fr-video{height:0;padding-bottom:56.206088992974244%;position:relative;display:inline-block;width:100%;}/*!sc*/ .ljODsN .fr-video iframe{position:absolute;top:0;left:0;width:100%;height:100%;}/*!sc*/ data-styled.g80[id="ArticleContent__ArticleContainer-sc-18n1x4l-0"]{content:"ljODsN,"}/*!sc*/ .dwcfaP{border-left:4px solid #3ce9a8;background:#f8fafd;line-height:1.4;}/*!sc*/ data-styled.g81[id="ArticleContent__ArticleSummaryBox-sc-18n1x4l-1"]{content:"dwcfaP,"}/*!sc*/ .fiqiCA{border-radius:32px;}/*!sc*/ .fiqiCA ul{list-style-position:outside;padding-left:20px;}/*!sc*/ .fiqiCA .toc-link *{font-size:inherit;}/*!sc*/ data-styled.g82[id="ArticleContent__TableOfContents-sc-18n1x4l-2"]{content:"fiqiCA,"}/*!sc*/ .gMCoqt .name{color:#000;}/*!sc*/ data-styled.g83[id="ArticleContent__AuthorLink-sc-18n1x4l-3"]{content:"gMCoqt,"}/*!sc*/ .bKWLgX{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;background:#f8fafd;padding:24px 40px 24px 24px;border-radius:16px;}/*!sc*/ .bKWLgX .image-link{border-radius:20px;overflow:hidden;margin-right:24px;display:block;-webkit-flex:0 0 72px;-ms-flex:0 0 72px;flex:0 0 72px;}/*!sc*/ .bKWLgX h3{margin-bottom:4px;}/*!sc*/ .bKWLgX p{line-height:1.5;color:#58667e;}/*!sc*/ data-styled.g84[id="ArticleAuthor__AuthorSection-t18p1k-0"]{content:"bKWLgX,"}/*!sc*/ .fqZiSi{background-position:center center;background-repeat:no-repeat;background-size:cover;background-color:#d3d3d3;border-radius:16px;display:block;height:0;max-width:100%;position:relative;width:100%;}/*!sc*/ data-styled.g85[id="LazyBackground__Background-sc-16pnu62-0"]{content:"fqZiSi,"}/*!sc*/ .gRgJsG:hover{-webkit-text-decoration:none;text-decoration:none;}/*!sc*/ data-styled.g86[id="Title__StyledTitle-sc-6yi3ll-0"]{content:"gRgJsG,"}/*!sc*/ .jZHrE{position:relative;height:100%;}/*!sc*/ data-styled.g88[id="ArticleCard__ArticleBox-sc-4ctgqh-0"]{content:"jZHrE,"}/*!sc*/ .SmqGy{color:#3861FB;line-height:1.5;padding-bottom:4px;}/*!sc*/ data-styled.g89[id="ArticleCard__Category-sc-4ctgqh-1"]{content:"SmqGy,"}/*!sc*/ .pQehZ{padding-left:32px;padding-right:32px;}/*!sc*/ .pQehZ p,.pQehZ h3{text-align:center;}/*!sc*/ .pQehZ .form{margin:24px auto 0;}/*!sc*/ data-styled.g92[id="Newsletter__NewsletterSection-tgkqos-0"]{content:"pQehZ,"}/*!sc*/ .eTnhwi{display:-webkit-inline-box;display:-webkit-inline-flex;display:-ms-inline-flexbox;display:inline-flex;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-box-pack:center;-webkit-justify-content:center;-ms-flex-pack:center;justify-content:center;position:relative;box-sizing:border-box;background-color:transparent;outline:0px;border:0px;margin:0px;padding:0px;cursor:pointer;-webkit-user-select:none;-moz-user-select:none;-ms-user-select:none;user-select:none;vertical-align:middle;-webkit-appearance:none;-moz-appearance:none;appearance:none;-webkit-text-decoration:none;text-decoration:none;}/*!sc*/ @media (hover:none){.eTnhwi{cursor:inherit;}}/*!sc*/ data-styled.g93[id="LikeButton__StyledButton-sc-1xl44e6-0"]{content:"eTnhwi,"}/*!sc*/ </style></head><body data-commit="30ab5bd5" data-commit-time="" data-ts="2025-02-18T00:07:32.509Z"><script async="" src="https://www.googletagmanager.com/gtag/js?id=UA-40475998-1"></script><div id="__next" data-reactroot=""><div class="notification__NotificationContainer-ru7pbh-0 gitnvH"><div></div></div><div class="sc-bdfBwQ"><nav class="sc-gsTCUz inJjsD"><div class="Logo__SvgContainer-hxzlkl-0 hQeyNG"><a href="/"><svg viewBox="0 0 76.52 77.67" xmlns="http://www.w3.org/2000/svg" color="primary"><path d="M66.54 46.41a4.09 4.09 0 01-4.17.28C60.83 45.82 60 43.78 60 41v-8.52c0-4.09-1.62-7-4.33-7.79-4.58-1.34-8 4.27-9.32 6.38l-8.1 13.11v-16c-.09-3.69-1.29-5.9-3.56-6.56-1.5-.44-3.75-.26-5.94 3.08L10.64 53.77A32 32 0 017 38.83C7 21.31 21 7.06 38.25 7.06s31.3 14.25 31.3 31.77v.18c.17 3.39-.93 6.09-3 7.4zm10-7.57v-.17C76.4 17.32 59.28 0 38.25 0S0 17.42 0 38.83s17.16 38.84 38.25 38.84a37.81 37.81 0 0026-10.36 3.56 3.56 0 00.18-5 3.43 3.43 0 00-4.86-.23A30.93 30.93 0 0115 60l16.3-26.2v12.09c0 5.81 2.25 7.69 4.14 8.24s4.78.17 7.81-4.75l9-14.57c.28-.47.55-.87.79-1.22V41c0 5.43 2.18 9.77 6 11.91a11 11 0 0011.21-.45c4.2-2.73 6.49-7.67 6.25-13.62z" fill="#17181b"></path></svg></a></div><div class="sc-gsTCUz fBYRBQ"><button aria-label="Open search bar" class="NavButton-sc-1sr7lbk-0 jmfAe"><svg viewBox="0 0 22 22" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 cKSfzR"><path d="M13.5 2.57457e-06C11.9038 -0.00124001 10.3396 0.447331 8.98664 1.29429C7.6337 2.14125 6.54681 3.35231 5.85056 4.78864C5.15432 6.22496 4.87691 7.82841 5.05014 9.41517C5.22337 11.0019 5.84023 12.5077 6.82999 13.76L0.299988 20.29L1.70999 21.7L8.23999 15.17C9.30415 16.0093 10.5536 16.5818 11.8841 16.8399C13.2146 17.098 14.5875 17.0341 15.8883 16.6535C17.1891 16.273 18.3799 15.5868 19.3615 14.6523C20.3431 13.7178 21.087 12.5621 21.531 11.2816C21.975 10.0011 22.1062 8.63293 21.9138 7.29136C21.7214 5.9498 21.211 4.67371 20.425 3.5696C19.639 2.46549 18.6003 1.56539 17.3957 0.94443C16.191 0.323466 14.8553 -0.000352271 13.5 2.57457e-06ZM13.5 15C12.2144 15 10.9577 14.6188 9.88878 13.9046C8.81986 13.1903 7.98674 12.1752 7.49477 10.9874C7.0028 9.79973 6.87408 8.49279 7.12488 7.23191C7.37569 5.97104 7.99475 4.81285 8.90379 3.90381C9.81283 2.99477 10.971 2.3757 12.2319 2.1249C13.4928 1.87409 14.7997 2.00282 15.9874 2.49479C17.1751 2.98676 18.1903 3.81988 18.9045 4.8888C19.6188 5.95772 20 7.21442 20 8.5C19.9966 10.2229 19.3107 11.8742 18.0925 13.0925C16.8742 14.3108 15.2229 14.9967 13.5 15Z" fill="currentColor"></path></svg></button><label for="mobileMenuButton" aria-label="Open mobile menu" class="Navbar__Label-midvey-2 LHhmf"><svg viewBox="0 0 24 24" role="button" aria-label="Open mobile menu" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 guyNMq"><path d="M19.5 4.5H4.5V6.5H19.5V4.5Z"></path><path d="M19.5 17.5H4.5V19.5H19.5V17.5Z"></path><path d="M19.5 11H4.5V13H19.5V11Z"></path></svg><input type="checkbox" id="mobileMenuButton" class="Navbar__Input-midvey-1 hbrKEE"/></label><div class="Panel__Wrapper-rgznpu-0 jabPmx"><div class="Panel__Header-rgznpu-1 jtlwNr"><div class="Logo__SvgContainer-hxzlkl-0 hQeyNG"><a href="/"><svg viewBox="0 0 76.52 77.67" xmlns="http://www.w3.org/2000/svg" color="primary"><path d="M66.54 46.41a4.09 4.09 0 01-4.17.28C60.83 45.82 60 43.78 60 41v-8.52c0-4.09-1.62-7-4.33-7.79-4.58-1.34-8 4.27-9.32 6.38l-8.1 13.11v-16c-.09-3.69-1.29-5.9-3.56-6.56-1.5-.44-3.75-.26-5.94 3.08L10.64 53.77A32 32 0 017 38.83C7 21.31 21 7.06 38.25 7.06s31.3 14.25 31.3 31.77v.18c.17 3.39-.93 6.09-3 7.4zm10-7.57v-.17C76.4 17.32 59.28 0 38.25 0S0 17.42 0 38.83s17.16 38.84 38.25 38.84a37.81 37.81 0 0026-10.36 3.56 3.56 0 00.18-5 3.43 3.43 0 00-4.86-.23A30.93 30.93 0 0115 60l16.3-26.2v12.09c0 5.81 2.25 7.69 4.14 8.24s4.78.17 7.81-4.75l9-14.57c.28-.47.55-.87.79-1.22V41c0 5.43 2.18 9.77 6 11.91a11 11 0 0011.21-.45c4.2-2.73 6.49-7.67 6.25-13.62z" fill="#17181b"></path></svg></a></div><svg viewBox="0 0 24 24" role="button" aria-label="Close mobile menu" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 uqPkp"><path d="M13.4 12L20 18.6L18.6 20L12 13.4L5.4 20L4 18.6L10.6 12L4 5.4L5.4 4L12 10.6L18.6 4L20 5.4L13.4 12Z"></path></svg></div><div class="MainPanel__Container-dujdt9-0 MainPanel__ListContainer-dujdt9-1 cZFSA-d ljOoWA"><div role="button" class="sc-gsTCUz jUEeyM"><div class="sc-bdfBwQ Text-msjfkz-0 dLcezr">Learn</div><svg viewBox="0 0 24 24" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 kCeqsc"><path d="M8.59003 16.59L13.17 12L8.59003 7.41L10 6L16 12L10 18L8.59003 16.59Z" fill="currentColor"></path></svg></div><div role="button" class="sc-gsTCUz jUEeyM"><div class="sc-bdfBwQ Text-msjfkz-0 dLcezr">Topics</div><svg viewBox="0 0 24 24" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 kCeqsc"><path d="M8.59003 16.59L13.17 12L8.59003 7.41L10 6L16 12L10 18L8.59003 16.59Z" fill="currentColor"></path></svg></div><div role="button" class="sc-gsTCUz jUEeyM"><div class="sc-bdfBwQ Text-msjfkz-0 dLcezr">CMC Updates</div><svg viewBox="0 0 24 24" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 kCeqsc"><path d="M8.59003 16.59L13.17 12L8.59003 7.41L10 6L16 12L10 18L8.59003 16.59Z" fill="currentColor"></path></svg></div><div role="button" class="sc-gsTCUz kupqjK"><div class="sc-bdfBwQ Text-msjfkz-0 dLcezr">Language</div><svg viewBox="0 0 24 24" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 kCeqsc"><path d="M8.59003 16.59L13.17 12L8.59003 7.41L10 6L16 12L10 18L8.59003 16.59Z" fill="currentColor"></path></svg></div><a href="/academy/glossary" class="sc-gsTCUz irrFZf"><div class="sc-bdfBwQ Text-msjfkz-0 dLcezr">Glossary</div></a><a href="/academy/authors" class="sc-gsTCUz irrFZf"><div class="sc-bdfBwQ Text-msjfkz-0 dLcezr">Authors</div></a></div><div class="MainPanel__Container-dujdt9-0 cZFSA-d"><div class="sc-gsTCUz kSSfgv"><div class="sc-bdfBwQ Dropdown__Wrapper-egbkvi-2 iOZaIg wrapper--top,bottom"><button aria-label="Change language" class="NavButton-sc-1sr7lbk-0 LanguageSwitcher__Button-sc-1rgi4yk-0 jmfAe iSSjsx"><svg viewBox="0 0 20 21" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 kmkzFK"><path d="M9.99 0.00440563C8.01262 0.00638301 6.0802 0.594553 4.43703 1.69457C2.79385 2.79458 1.51369 4.35706 0.758342 6.18449C0.00299907 8.01193 -0.193608 10.0223 0.193372 11.9614C0.580353 13.9006 1.53355 15.6815 2.93247 17.079C4.33139 18.4765 6.11324 19.4279 8.05278 19.813C9.99231 20.198 12.0025 19.9994 13.8291 19.2422C15.6558 18.4851 17.217 17.2033 18.3154 15.5591C19.4138 13.9148 20 11.9818 20 10.0044C20.0006 8.69016 19.7421 7.3887 19.2392 6.1745C18.7362 4.9603 17.9987 3.85721 17.069 2.92836C16.1392 1.99952 15.0354 1.26316 13.8207 0.761427C12.606 0.259696 11.3042 0.0024476 9.99 0.00440563ZM16.92 6.00441H13.97C13.657 4.76586 13.1936 3.5703 12.59 2.44441C14.4141 3.07238 15.9512 4.33611 16.92 6.00441ZM10 2.04441C10.84 3.2563 11.4845 4.59258 11.91 6.00441H8.09C8.51549 4.59258 9.16 3.2563 10 2.04441ZM2.26 12.0044C1.91334 10.6936 1.91334 9.31521 2.26 8.00441H5.64C5.55288 8.66762 5.50612 9.33552 5.5 10.0044C5.50612 10.6733 5.55288 11.3412 5.64 12.0044H2.26ZM3.08 14.0044H6.03C6.34297 15.243 6.80642 16.4385 7.41 17.5644C5.58396 16.9399 4.04582 15.6752 3.08 14.0044ZM6.03 6.00441H3.08C4.04582 4.33357 5.58396 3.06896 7.41 2.44441C6.80642 3.5703 6.34297 4.76586 6.03 6.00441ZM10 17.9644C9.16001 16.7525 8.51549 15.4162 8.09 14.0044H11.91C11.4845 15.4162 10.84 16.7525 10 17.9644ZM12.34 12.0044H7.66C7.56122 11.3422 7.50777 10.6739 7.5 10.0044C7.50736 9.33486 7.56082 8.66661 7.66 8.00441H12.34C12.4392 8.66661 12.4926 9.33486 12.5 10.0044C12.4922 10.6739 12.4388 11.3422 12.34 12.0044ZM12.59 17.5644C13.1936 16.4385 13.657 15.243 13.97 14.0044H16.92C15.9512 15.6727 14.4141 16.9364 12.59 17.5644ZM14.36 12.0044C14.4471 11.3412 14.4939 10.6733 14.5 10.0044C14.4939 9.33552 14.4471 8.66762 14.36 8.00441H17.74C18.0867 9.31521 18.0867 10.6936 17.74 12.0044H14.36Z"></path></svg></button><div class="Dropdown__DropdownWrapper-egbkvi-1 dpplru"><div class="Dropdown__Menu-egbkvi-0 bBRENP"><div style="overflow-y:auto" class="sc-bdfBwQ Grid-sc-3uwl3g-0 gmJjjk eYLPhT"><a href="/academy/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">English</a><a href="/academy/id/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Bahasa Indonesia</a><a href="/academy/de/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Deutsch</a><a href="/academy/es/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Español</a><a href="/academy/pt/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Português Brasil</a><a href="/academy/vi/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Tiếng Việt</a><a href="/academy/tr/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Türkçe</a><a href="/academy/ru/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Русский</a><a href="/academy/uk/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Українська</a><a href="/academy/th/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">ไทย</a></div></div></div></div></div></div></div></div><div class="sc-bdfBwQ jZXIMD"><div class="sc-gsTCUz kSSfgv"><div class="sc-bdfBwQ Dropdown__Wrapper-egbkvi-2 hjcGbS wrapper--bottom"><div role="button" class="sc-gsTCUz leStXf">Learn<svg viewBox="0 0 8 4" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 eBAqEu"><path d="M0.666672 0.666626L4 3.99996L7.33334 0.666626H0.666672Z"></path></svg></div><div class="Dropdown__DropdownWrapper-egbkvi-1 gaITVH"><div class="Dropdown__Menu-egbkvi-0 bBRENP"><div class="sc-bdfBwQ Grid-sc-3uwl3g-0 hGITez hhlnuT"><a href="/academy/categories/alpha-radar" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Alpha Radar</div></a><a href="/academy/categories/blog" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Blog</div></a><a href="/academy/categories/cmc-research" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">CMC Research</div></a><a href="/academy/categories/crypto-basics" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Crypto Basics</div></a><a href="/academy/categories/how-to-guides" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">How-to Guides</div></a><a href="/academy/categories/market-musing" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Crypto News</div></a><a href="/academy/categories/tech-deep-dives" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Tech Deep Dives</div></a><a href="/academy/categories/trading-analysis" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Trading Analysis</div></a></div></div></div></div><div class="sc-bdfBwQ Dropdown__Wrapper-egbkvi-2 hjcGbS wrapper--bottom"><div role="button" class="sc-gsTCUz leStXf">Topics<svg viewBox="0 0 8 4" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 eBAqEu"><path d="M0.666672 0.666626L4 3.99996L7.33334 0.666626H0.666672Z"></path></svg></div><div class="Dropdown__DropdownWrapper-egbkvi-1 gaITVH"><div class="Dropdown__Menu-egbkvi-0 bBRENP"><div class="sc-bdfBwQ Grid-sc-3uwl3g-0 hGITez hhlnuT"><a href="/academy/categories/altcoins" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Altcoins</div></a><a href="/academy/categories/bitcoin" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Bitcoin</div></a><a href="/academy/categories/blockchain" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Blockchain</div></a><a href="/academy/categories/defi" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">DeFi</div></a><a href="/academy/categories/ethereum" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Ethereum</div></a><a href="/academy/categories/gamefi" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">GameFi</div></a><a href="/academy/categories/metaverse" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Metaverse</div></a><a href="/academy/categories/nfts" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">NFTs</div></a><a href="/academy/categories/trading" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Trading</div></a></div></div></div></div><div class="sc-bdfBwQ Dropdown__Wrapper-egbkvi-2 hjcGbS wrapper--bottom"><div role="button" class="sc-gsTCUz leStXf">CMC Updates<svg viewBox="0 0 8 4" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 eBAqEu"><path d="M0.666672 0.666626L4 3.99996L7.33334 0.666626H0.666672Z"></path></svg></div><div class="Dropdown__DropdownWrapper-egbkvi-1 gaITVH"><div class="Dropdown__Menu-egbkvi-0 bBRENP"><div class="sc-bdfBwQ Grid-sc-3uwl3g-0 hGITez hhlnuT"><a href="/academy/categories/announcements" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Announcements</div></a><a href="/academy/categories/feature-explorer" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Feature Explorer</div></a><a href="/academy/categories/marketing" class="sc-gsTCUz Navbar__MenuItem-zbdsw1-0 cZWuHU cIKCMm"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Marketing</div></a></div></div></div></div><a href="/academy/glossary" class="sc-gsTCUz kAuvPc"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Glossary</div></a><a href="/academy/authors" class="sc-gsTCUz kAuvPc"><div class="sc-bdfBwQ Text-msjfkz-0 bRtkcJ">Authors</div></a><div class="sc-gsTCUz cHCQYY"></div><button aria-label="Open search bar" class="NavButton-sc-1sr7lbk-0 jmfAe"><svg viewBox="0 0 22 22" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 cKSfzR"><path d="M13.5 2.57457e-06C11.9038 -0.00124001 10.3396 0.447331 8.98664 1.29429C7.6337 2.14125 6.54681 3.35231 5.85056 4.78864C5.15432 6.22496 4.87691 7.82841 5.05014 9.41517C5.22337 11.0019 5.84023 12.5077 6.82999 13.76L0.299988 20.29L1.70999 21.7L8.23999 15.17C9.30415 16.0093 10.5536 16.5818 11.8841 16.8399C13.2146 17.098 14.5875 17.0341 15.8883 16.6535C17.1891 16.273 18.3799 15.5868 19.3615 14.6523C20.3431 13.7178 21.087 12.5621 21.531 11.2816C21.975 10.0011 22.1062 8.63293 21.9138 7.29136C21.7214 5.9498 21.211 4.67371 20.425 3.5696C19.639 2.46549 18.6003 1.56539 17.3957 0.94443C16.191 0.323466 14.8553 -0.000352271 13.5 2.57457e-06ZM13.5 15C12.2144 15 10.9577 14.6188 9.88878 13.9046C8.81986 13.1903 7.98674 12.1752 7.49477 10.9874C7.0028 9.79973 6.87408 8.49279 7.12488 7.23191C7.37569 5.97104 7.99475 4.81285 8.90379 3.90381C9.81283 2.99477 10.971 2.3757 12.2319 2.1249C13.4928 1.87409 14.7997 2.00282 15.9874 2.49479C17.1751 2.98676 18.1903 3.81988 18.9045 4.8888C19.6188 5.95772 20 7.21442 20 8.5C19.9966 10.2229 19.3107 11.8742 18.0925 13.0925C16.8742 14.3108 15.2229 14.9967 13.5 15Z" fill="currentColor"></path></svg></button><div class="sc-bdfBwQ Dropdown__Wrapper-egbkvi-2 hjcGbS wrapper--bottom-right"><button aria-label="Change language" class="NavButton-sc-1sr7lbk-0 LanguageSwitcher__Button-sc-1rgi4yk-0 jmfAe iSSjsx"><svg viewBox="0 0 20 21" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 kmkzFK"><path d="M9.99 0.00440563C8.01262 0.00638301 6.0802 0.594553 4.43703 1.69457C2.79385 2.79458 1.51369 4.35706 0.758342 6.18449C0.00299907 8.01193 -0.193608 10.0223 0.193372 11.9614C0.580353 13.9006 1.53355 15.6815 2.93247 17.079C4.33139 18.4765 6.11324 19.4279 8.05278 19.813C9.99231 20.198 12.0025 19.9994 13.8291 19.2422C15.6558 18.4851 17.217 17.2033 18.3154 15.5591C19.4138 13.9148 20 11.9818 20 10.0044C20.0006 8.69016 19.7421 7.3887 19.2392 6.1745C18.7362 4.9603 17.9987 3.85721 17.069 2.92836C16.1392 1.99952 15.0354 1.26316 13.8207 0.761427C12.606 0.259696 11.3042 0.0024476 9.99 0.00440563ZM16.92 6.00441H13.97C13.657 4.76586 13.1936 3.5703 12.59 2.44441C14.4141 3.07238 15.9512 4.33611 16.92 6.00441ZM10 2.04441C10.84 3.2563 11.4845 4.59258 11.91 6.00441H8.09C8.51549 4.59258 9.16 3.2563 10 2.04441ZM2.26 12.0044C1.91334 10.6936 1.91334 9.31521 2.26 8.00441H5.64C5.55288 8.66762 5.50612 9.33552 5.5 10.0044C5.50612 10.6733 5.55288 11.3412 5.64 12.0044H2.26ZM3.08 14.0044H6.03C6.34297 15.243 6.80642 16.4385 7.41 17.5644C5.58396 16.9399 4.04582 15.6752 3.08 14.0044ZM6.03 6.00441H3.08C4.04582 4.33357 5.58396 3.06896 7.41 2.44441C6.80642 3.5703 6.34297 4.76586 6.03 6.00441ZM10 17.9644C9.16001 16.7525 8.51549 15.4162 8.09 14.0044H11.91C11.4845 15.4162 10.84 16.7525 10 17.9644ZM12.34 12.0044H7.66C7.56122 11.3422 7.50777 10.6739 7.5 10.0044C7.50736 9.33486 7.56082 8.66661 7.66 8.00441H12.34C12.4392 8.66661 12.4926 9.33486 12.5 10.0044C12.4922 10.6739 12.4388 11.3422 12.34 12.0044ZM12.59 17.5644C13.1936 16.4385 13.657 15.243 13.97 14.0044H16.92C15.9512 15.6727 14.4141 16.9364 12.59 17.5644ZM14.36 12.0044C14.4471 11.3412 14.4939 10.6733 14.5 10.0044C14.4939 9.33552 14.4471 8.66762 14.36 8.00441H17.74C18.0867 9.31521 18.0867 10.6936 17.74 12.0044H14.36Z"></path></svg></button><div class="Dropdown__DropdownWrapper-egbkvi-1 jrosAA"><div class="Dropdown__Menu-egbkvi-0 bBRENP"><div style="overflow-y:auto" class="sc-bdfBwQ Grid-sc-3uwl3g-0 gmJjjk eYLPhT"><a href="/academy/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">English</a><a href="/academy/id/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Bahasa Indonesia</a><a href="/academy/de/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Deutsch</a><a href="/academy/es/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Español</a><a href="/academy/pt/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Português Brasil</a><a href="/academy/vi/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Tiếng Việt</a><a href="/academy/tr/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Türkçe</a><a href="/academy/ru/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Русский</a><a href="/academy/uk/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">Українська</a><a href="/academy/th/article/how-to-integrate-coinmarketcap-api-with-google-sheets" style="justify-content:center" class="ListCTA__Link-rp0q6e-0 iOKdEn">ไทย</a></div></div></div></div></div></div><form method="get" target="_self" action="/academy/search" class="SearchForm-sc-1vfffbc-0 fJcvOH"><label for="headerSearchInput" aria-label="Search articles" class="SearchForm__Label-sc-1vfffbc-3 cMwSJN"><input type="text" id="headerSearchInput" name="term" placeholder="Search..." class="SearchForm__Input-sc-1vfffbc-1 hZCLgD"/></label><button type="button" aria-label="Close search bar" class="SearchForm__CloseButton-sc-1vfffbc-2 eSLlrc"><svg viewBox="0 0 24 24" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 ecKBcM"><path d="M13.4 12L20 18.6L18.6 20L12 13.4L5.4 20L4 18.6L10.6 12L4 5.4L5.4 4L12 10.6L18.6 4L20 5.4L13.4 12Z"></path></svg></button></form></nav><div><span></span><div class="sc-bdfBwQ Container-sc-4c5vqs-0 kGZDmf khdEkh"><div class="sc-bdfBwQ StickyBarWrapper__Wrapper-sc-8z2dej-0 lifqWE eMCbwr"><div class="sc-gsTCUz bgZavq"><div class="sc-bdfBwQ Text-msjfkz-0 cjnMxG">How to integrate CoinMarketCap API with Google Sheets</div><div class="sc-bdfBwQ gQbnxJ"><div class="sc-bdfBwQ Grid-sc-3uwl3g-0 jvVtgT hfyApF"><div class="sc-bdfBwQ Grid__GridItem-sc-3uwl3g-2"><a href="https://twitter.com/intent/tweet?url=https://coinmarketcap.com/academy/article/how-to-integrate-coinmarketcap-api-with-google-sheets&text=How%20to%20integrate%20CoinMarketCap%20API%20with%20Google%20Sheets" aria-label="Share this article on twitter" rel="noopener noreferrer" target="_blank" class="sc-gsTCUz SocialLink__IconWrapper-sc-1toayxk-0 SocialLink-sc-1toayxk-1 kSSfgv ldGcwa"><svg viewBox="0 0 18 14" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0"><path d="M5.90944 13.7676C7.18903 13.7764 8.45762 13.5308 9.64152 13.0452C10.8254 12.5596 11.901 11.8436 12.8058 10.9387C13.7107 10.0339 14.4267 8.95831 14.9123 7.77442C15.398 6.59052 15.6435 5.32193 15.6347 4.04234C15.6347 3.89424 15.6318 3.74692 15.6251 3.6004C16.294 3.11637 16.8714 2.51704 17.3301 1.83048C16.7065 2.10711 16.0448 2.28853 15.3673 2.36867C16.081 1.9415 16.6151 1.26951 16.8702 0.47784C16.1993 0.875917 15.4653 1.15658 14.7 1.30773C14.1847 0.759649 13.5031 0.396688 12.7607 0.275024C12.0184 0.153359 11.2566 0.279775 10.5933 0.634706C9.93003 0.989637 9.40223 1.55329 9.09159 2.23844C8.78095 2.92358 8.7048 3.69201 8.87492 4.4248C7.51583 4.35687 6.18622 4.00382 4.97245 3.38858C3.75868 2.77334 2.6879 1.90967 1.82965 0.853666C1.39239 1.60611 1.2584 2.49693 1.45497 3.3447C1.65154 4.19248 2.16388 4.93344 2.88765 5.41668C2.34485 5.40017 1.81395 5.25358 1.33958 4.98925C1.3388 5.00353 1.3388 5.01782 1.3388 5.03287C1.33896 5.82207 1.61213 6.58691 2.11194 7.19765C2.61176 7.8084 3.30746 8.22744 4.08103 8.38371C3.57776 8.52103 3.0497 8.5411 2.53745 8.4424C2.75578 9.12162 3.18095 9.7156 3.75349 10.1413C4.32603 10.5669 5.01731 10.803 5.73063 10.8164C4.51983 11.7668 3.02454 12.2822 1.48533 12.2798C1.21283 12.2799 0.940561 12.264 0.669922 12.2322C2.23287 13.2363 4.05177 13.7693 5.90944 13.7676Z"></path></svg></a></div><div class="sc-bdfBwQ Grid__GridItem-sc-3uwl3g-2"><a href="https://www.facebook.com/sharer/sharer.php?u=https://coinmarketcap.com/academy/article/how-to-integrate-coinmarketcap-api-with-google-sheets&t=How%20to%20integrate%20CoinMarketCap%20API%20with%20Google%20Sheets" aria-label="Share this article on Facebook" rel="noopener noreferrer" target="_blank" class="sc-gsTCUz SocialLink__IconWrapper-sc-1toayxk-0 SocialLink-sc-1toayxk-1 kSSfgv kINMVY"><svg viewBox="0 0 20 20" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0"><path d="M19.375 10.06a9.383 9.383 0 0 1-7.907 9.257V12.77h2.185l.408-2.71h-2.593V8.3a1.356 1.356 0 0 1 1.521-1.468h1.2V4.53a14.7 14.7 0 0 0-2.1-.182 3.31 3.31 0 0 0-3.547 3.643v2.068h-2.38v2.71h2.38v6.546a9.374 9.374 0 1 1 10.843-9.257z"></path></svg></a></div><div class="sc-bdfBwQ Grid__GridItem-sc-3uwl3g-2"><a href="https://t.me/share/url?url=https://coinmarketcap.com/academy/article/how-to-integrate-coinmarketcap-api-with-google-sheets&text=How%20to%20integrate%20CoinMarketCap%20API%20with%20Google%20Sheets" aria-label="Share this article on Telegram" rel="noopener noreferrer" target="_blank" class="sc-gsTCUz SocialLink__IconWrapper-sc-1toayxk-0 SocialLink-sc-1toayxk-1 kSSfgv kWcfCj"><svg viewBox="0 0 18 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0"><path d="M16.5257 0.95613L0.992894 6.94483C-0.066948 7.37023 -0.061323 7.96196 0.800144 8.22551L4.78605 9.46968L14.0138 3.64787C14.4499 3.3832 14.8494 3.52537 14.5213 3.81704L7.04397 10.5643L7.12095 10.6987L7.04397 10.5649L6.76974 14.675C6.92584 14.6731 7.07947 14.6358 7.21913 14.566C7.35878 14.4963 7.48083 14.3958 7.57613 14.2721L9.51318 12.389L13.5423 15.3662C14.2841 15.7748 14.8191 15.5629 15.004 14.6773L17.6491 2.21212C17.9199 1.12644 17.2349 0.634171 16.5258 0.956163"></path></svg></a></div><div class="sc-bdfBwQ Grid__GridItem-sc-3uwl3g-2"><div aria-label="Copy the link to your clipboard" class="sc-gsTCUz SocialLink__IconWrapper-sc-1toayxk-0 kSSfgv sHTpX"><svg viewBox="0 0 14 17" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0"><path d="M13.8801 0V12.26H11.8801V2H4.12012V0H13.8801Z"></path><path d="M0.120117 3.97998V16.24H9.88012V3.99998L0.120117 3.97998ZM7.87012 14.26H2.12012V5.99998H7.88012L7.87012 14.26Z"></path></svg></div></div></div></div><div class="sc-bdfBwQ fWNSXR"><div class="sc-bdfBwQ"><div class="sc-bdfBwQ Dropdown__Wrapper-egbkvi-2 hjcGbS wrapper--bottom-right"><button aria-label="Share this article on the social media of your choice" class="sc-bdfBwQ Button__StyledButton-sc-1kvh4an-0 jcleUz SocialShareMobile__IconButton-wlnyr9-0 iPCECF"><svg viewBox="0 0 24 24" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 gSUsoi"><path d="M17.8476 13.1998C16.9476 13.1998 16.0476 13.5998 15.5476 14.2998L9.24756 11.9998H9.14756H9.24756L15.4476 9.69981C15.9476 10.3998 16.8476 10.7998 17.7476 10.7998C19.4476 10.7998 20.7476 9.3998 20.7476 7.7998C20.7476 6.0998 19.4476 4.7998 17.7476 4.7998C16.0476 4.7998 14.7476 6.0998 14.7476 7.7998L8.54756 10.0998C8.04756 9.3998 7.24756 8.99981 6.24756 8.99981C4.54756 8.99981 3.24756 10.2998 3.24756 11.9998C3.24756 13.5998 4.54756 14.9998 6.24756 14.9998C7.14756 14.9998 8.04756 14.5998 8.54756 13.8998L14.7476 16.1998C14.7476 17.7998 16.0476 19.1998 17.7476 19.1998C19.4476 19.1998 20.7476 17.7998 20.7476 16.1998C20.8476 14.5998 19.4476 13.1998 17.8476 13.1998ZM17.8476 6.7998C18.3476 6.7998 18.8476 7.2998 18.8476 7.7998C18.8476 8.2998 18.3476 8.7998 17.8476 8.7998C17.3476 8.7998 16.8476 8.2998 16.8476 7.7998C16.8476 7.2998 17.2476 6.7998 17.8476 6.7998ZM6.24756 12.9998C5.74756 12.9998 5.24756 12.4998 5.24756 11.9998C5.24756 11.3998 5.74756 10.9998 6.24756 10.9998C6.74756 10.9998 7.24756 11.3998 7.24756 11.9998C7.24756 12.4998 6.84756 12.9998 6.24756 12.9998ZM17.8476 17.1998C17.3476 17.1998 16.8476 16.6998 16.8476 16.1998C16.8476 15.6998 17.3476 15.1998 17.8476 15.1998C18.3476 15.1998 18.8476 15.6998 18.8476 16.1998C18.8476 16.6998 18.3476 17.1998 17.8476 17.1998Z" fill="currentColor"></path></svg></button><div class="Dropdown__DropdownWrapper-egbkvi-1 jrosAA"><div class="Dropdown__Menu-egbkvi-0 bBRENP"><div class="SocialShareMobile__Menu-wlnyr9-1 estnki"><div class="sc-bdfBwQ Grid-sc-3uwl3g-0 jvVtgT iaLNSR"><div class="sc-bdfBwQ Grid__GridItem-sc-3uwl3g-2"><a href="https://twitter.com/intent/tweet?url=https://coinmarketcap.com/academy/article/how-to-integrate-coinmarketcap-api-with-google-sheets&text=How%20to%20integrate%20CoinMarketCap%20API%20with%20Google%20Sheets" aria-label="Share this article on twitter" rel="noopener noreferrer" target="_blank" class="sc-gsTCUz SocialLink__IconWrapper-sc-1toayxk-0 SocialLink-sc-1toayxk-1 kSSfgv ldGcwa"><svg viewBox="0 0 18 14" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0"><path d="M5.90944 13.7676C7.18903 13.7764 8.45762 13.5308 9.64152 13.0452C10.8254 12.5596 11.901 11.8436 12.8058 10.9387C13.7107 10.0339 14.4267 8.95831 14.9123 7.77442C15.398 6.59052 15.6435 5.32193 15.6347 4.04234C15.6347 3.89424 15.6318 3.74692 15.6251 3.6004C16.294 3.11637 16.8714 2.51704 17.3301 1.83048C16.7065 2.10711 16.0448 2.28853 15.3673 2.36867C16.081 1.9415 16.6151 1.26951 16.8702 0.47784C16.1993 0.875917 15.4653 1.15658 14.7 1.30773C14.1847 0.759649 13.5031 0.396688 12.7607 0.275024C12.0184 0.153359 11.2566 0.279775 10.5933 0.634706C9.93003 0.989637 9.40223 1.55329 9.09159 2.23844C8.78095 2.92358 8.7048 3.69201 8.87492 4.4248C7.51583 4.35687 6.18622 4.00382 4.97245 3.38858C3.75868 2.77334 2.6879 1.90967 1.82965 0.853666C1.39239 1.60611 1.2584 2.49693 1.45497 3.3447C1.65154 4.19248 2.16388 4.93344 2.88765 5.41668C2.34485 5.40017 1.81395 5.25358 1.33958 4.98925C1.3388 5.00353 1.3388 5.01782 1.3388 5.03287C1.33896 5.82207 1.61213 6.58691 2.11194 7.19765C2.61176 7.8084 3.30746 8.22744 4.08103 8.38371C3.57776 8.52103 3.0497 8.5411 2.53745 8.4424C2.75578 9.12162 3.18095 9.7156 3.75349 10.1413C4.32603 10.5669 5.01731 10.803 5.73063 10.8164C4.51983 11.7668 3.02454 12.2822 1.48533 12.2798C1.21283 12.2799 0.940561 12.264 0.669922 12.2322C2.23287 13.2363 4.05177 13.7693 5.90944 13.7676Z"></path></svg></a></div><div class="sc-bdfBwQ Grid__GridItem-sc-3uwl3g-2"><a href="https://www.facebook.com/sharer/sharer.php?u=https://coinmarketcap.com/academy/article/how-to-integrate-coinmarketcap-api-with-google-sheets&t=How%20to%20integrate%20CoinMarketCap%20API%20with%20Google%20Sheets" aria-label="Share this article on Facebook" rel="noopener noreferrer" target="_blank" class="sc-gsTCUz SocialLink__IconWrapper-sc-1toayxk-0 SocialLink-sc-1toayxk-1 kSSfgv kINMVY"><svg viewBox="0 0 20 20" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0"><path d="M19.375 10.06a9.383 9.383 0 0 1-7.907 9.257V12.77h2.185l.408-2.71h-2.593V8.3a1.356 1.356 0 0 1 1.521-1.468h1.2V4.53a14.7 14.7 0 0 0-2.1-.182 3.31 3.31 0 0 0-3.547 3.643v2.068h-2.38v2.71h2.38v6.546a9.374 9.374 0 1 1 10.843-9.257z"></path></svg></a></div><div class="sc-bdfBwQ Grid__GridItem-sc-3uwl3g-2"><a href="https://t.me/share/url?url=https://coinmarketcap.com/academy/article/how-to-integrate-coinmarketcap-api-with-google-sheets&text=How%20to%20integrate%20CoinMarketCap%20API%20with%20Google%20Sheets" aria-label="Share this article on Telegram" rel="noopener noreferrer" target="_blank" class="sc-gsTCUz SocialLink__IconWrapper-sc-1toayxk-0 SocialLink-sc-1toayxk-1 kSSfgv kWcfCj"><svg viewBox="0 0 18 16" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0"><path d="M16.5257 0.95613L0.992894 6.94483C-0.066948 7.37023 -0.061323 7.96196 0.800144 8.22551L4.78605 9.46968L14.0138 3.64787C14.4499 3.3832 14.8494 3.52537 14.5213 3.81704L7.04397 10.5643L7.12095 10.6987L7.04397 10.5649L6.76974 14.675C6.92584 14.6731 7.07947 14.6358 7.21913 14.566C7.35878 14.4963 7.48083 14.3958 7.57613 14.2721L9.51318 12.389L13.5423 15.3662C14.2841 15.7748 14.8191 15.5629 15.004 14.6773L17.6491 2.21212C17.9199 1.12644 17.2349 0.634171 16.5258 0.956163"></path></svg></a></div><div class="sc-bdfBwQ Grid__GridItem-sc-3uwl3g-2"><div aria-label="Copy the link to your clipboard" class="sc-gsTCUz SocialLink__IconWrapper-sc-1toayxk-0 kSSfgv sHTpX"><svg viewBox="0 0 14 17" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0"><path d="M13.8801 0V12.26H11.8801V2H4.12012V0H13.8801Z"></path><path d="M0.120117 3.97998V16.24H9.88012V3.99998L0.120117 3.97998ZM7.87012 14.26H2.12012V5.99998H7.88012L7.87012 14.26Z"></path></svg></div></div></div></div></div></div></div></div></div><div class="sc-bdfBwQ Dropdown__Wrapper-egbkvi-2 haGBPZ dKySxu wrapper--bottom,bottom-right"><div class="sc-gsTCUz hSEAzV"><div class="sc-bdfBwQ Text-msjfkz-0 fJwUeL">Table of Contents</div><svg viewBox="0 0 9 6" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 erLLvd"><path d="M4.24 5.65L0 1.41L1.42 0L4.24 2.82L7.06 0L8.48 1.41L4.24 5.65Z"></path></svg></div><div class="Dropdown__DropdownWrapper-egbkvi-1 jpFHJB"><div class="Dropdown__Menu-egbkvi-0 bBRENP"><div class="StickyBar__ToC-rk0m1f-0 PywUU"><div class="StickyBar__ToCButton-rk0m1f-1 eGrglv"><strong>Introduction</strong></div><div class="StickyBar__ToCButton-rk0m1f-1 eGrglv"><strong>Understanding the CoinMarketCap API</strong></div><div class="StickyBar__ToCButton-rk0m1f-1 eGrglv">Key Features of the CoinMarketCap API</div><div class="StickyBar__ToCButton-rk0m1f-1 eGrglv"><strong>Why is it important in the crypto market context?</strong></div><div class="StickyBar__ToCButton-rk0m1f-1 eGrglv"><strong>Prerequisites for Integration</strong></div><div class="StickyBar__ToCButton-rk0m1f-1 eGrglv"><strong>Step-by-Step Integration Guide</strong></div><div class="StickyBar__ToCButton-rk0m1f-1 eGrglv"><strong>Pulling the Latest Bitcoin (BTC) Price</strong></div><div class="StickyBar__ToCButton-rk0m1f-1 eGrglv"><strong>Advanced Usage and Custom Functions</strong></div><div class="StickyBar__ToCButton-rk0m1f-1 eGrglv"><strong>Real-World Applications and Use Cases</strong></div><div class="StickyBar__ToCButton-rk0m1f-1 eGrglv"><strong>Troubleshooting Common Issues</strong></div><div class="StickyBar__ToCButton-rk0m1f-1 eGrglv"><strong>Best Practices for API Integration</strong></div><div class="StickyBar__ToCButton-rk0m1f-1 eGrglv"><strong>Conclusion</strong></div></div></div></div></div></div><div style="width:0%" class="sc-bdfBwQ ProgressBar__Bar-sc-7ekl2x-0 blnIOn eMGdpa"></div></div><a href="/academy/categories/how-to-guides" class="sc-bdfBwQ Text-msjfkz-0 jStWLp">How-to Guides</a><h1 class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 hoXOTC dAnDNe">How to integrate CoinMarketCap API with Google Sheets</h1><div class="sc-gsTCUz qFvDU"><div class="sc-bdfBwQ Text-msjfkz-0 clhOqr"><a href="/academy/author/coinmarketcap" class="ArticleContent__AuthorLink-sc-18n1x4l-3 gMCoqt">By CoinMarketCap</a></div><div class="sc-gsTCUz jZlgey"><svg viewBox="0 0 24 24" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 kKBMco"><path d="M11.9963 4C13.5785 4 15.1252 4.46919 16.4408 5.34824C17.7564 6.22729 18.7818 7.47672 19.3873 8.93853C19.9928 10.4003 20.1512 12.0089 19.8426 13.5607C19.5339 15.1126 18.772 16.538 17.6531 17.6569C16.5343 18.7757 15.1089 19.5376 13.557 19.8463C12.0052 20.155 10.3966 19.9965 8.93481 19.391C7.473 18.7855 6.22358 17.7602 5.34452 16.4446C4.46547 15.129 3.99628 13.5823 3.99628 12C3.99871 9.87901 4.84234 7.84559 6.34211 6.34583C7.84187 4.84606 9.87529 4.00243 11.9963 4ZM11.9963 2C10.0185 2 8.08507 2.58649 6.44058 3.6853C4.79609 4.78412 3.51436 6.3459 2.75749 8.17317C2.00061 10.0004 1.80258 12.0111 2.18843 13.9509C2.57428 15.8907 3.52669 17.6725 4.92521 19.0711C6.32374 20.4696 8.10557 21.422 10.0454 21.8079C11.9852 22.1937 13.9959 21.9957 15.8231 21.2388C17.6504 20.4819 19.2122 19.2002 20.311 17.5557C21.4098 15.9112 21.9963 13.9778 21.9963 12C21.9963 10.6868 21.7377 9.38641 21.2351 8.17315C20.7326 6.95988 19.996 5.85748 19.0674 4.92889C18.1388 4.0003 17.0364 3.26371 15.8231 2.76117C14.6099 2.25863 13.3095 1.99998 11.9963 2Z" fill="currentColor"></path><path d="M15.561 16.972L11.003 12.414V6.004H13.003V11.586L16.975 15.558L15.561 16.972Z" fill="currentColor"></path></svg><span class="sc-bdfBwQ Text-msjfkz-0 gtVAYr">7m</span></div><span class="sc-bdfBwQ Text-msjfkz-0 eDxZZL">Created 1yr ago, last updated 1yr ago</span></div><div class="sc-bdfBwQ ArticleContent__ArticleSummaryBox-sc-18n1x4l-1 ihJtHv dwcfaP"><p>Learn how to integrate CoinMarketCap API with Google Sheets</p></div><div class="sc-bdfBwQ ArticleCover__CoverBox-sc-9pmloj-0 bVYJZw"><span style="box-sizing:border-box;display:inline-block;overflow:hidden;width:initial;height:initial;background:none;opacity:1;border:0;margin:0;padding:0;position:relative;max-width:100%"><span style="box-sizing:border-box;display:block;width:initial;height:initial;background:none;opacity:1;border:0;margin:0;padding:0;max-width:100%"><img style="display:block;max-width:100%;width:initial;height:initial;background:none;opacity:1;border:0;margin:0;padding:0" alt="" aria-hidden="true" src="data:image/svg+xml,%3csvg%20xmlns=%27http://www.w3.org/2000/svg%27%20version=%271.1%27%20width=%27720%27%20height=%27405%27/%3e"/></span><img alt="How to integrate CoinMarketCap API with Google Sheets" srcSet="https://academy-public.coinmarketcap.com/optimized-uploads/23daa0764a1244b9993851f43d6bc2dd.png 1x, https://academy-public.coinmarketcap.com/optimized-uploads/23daa0764a1244b9993851f43d6bc2dd.png 2x" src="https://academy-public.coinmarketcap.com/optimized-uploads/23daa0764a1244b9993851f43d6bc2dd.png" decoding="async" data-nimg="intrinsic" class="coverImage" style="position:absolute;top:0;left:0;bottom:0;right:0;box-sizing:border-box;padding:0;border:none;margin:auto;display:block;width:0;height:0;min-width:100%;max-width:100%;min-height:100%;max-height:100%;object-fit:cover"/></span></div><div class="sc-bdfBwQ ArticleContent__TableOfContents-sc-18n1x4l-2 eEqGWC fiqiCA"><h4 class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 ksiqdi dAnDNe">Table of Contents</h4><ul><li><a class="sc-bdfBwQ Text-msjfkz-0 bjGZcz toc-link" href="#header-0"><strong>Introduction</strong></a></li><li><a class="sc-bdfBwQ Text-msjfkz-0 bjGZcz toc-link" href="#header-1"><strong>Understanding the CoinMarketCap API</strong></a></li><li><a class="sc-bdfBwQ Text-msjfkz-0 bjGZcz toc-link" href="#key-features-of-the-coinmarketcap-api">Key Features of the CoinMarketCap API</a></li><li><a class="sc-bdfBwQ Text-msjfkz-0 bjGZcz toc-link" href="#strong-why-is-it-important-in-the-crypto-market-context-strong"><strong>Why is it important in the crypto market context?</strong></a></li><li><a class="sc-bdfBwQ Text-msjfkz-0 bjGZcz toc-link" href="#header-2"><strong>Prerequisites for Integration</strong></a></li><li><a class="sc-bdfBwQ Text-msjfkz-0 bjGZcz toc-link" href="#header-3"><strong>Step-by-Step Integration Guide</strong></a></li><li><a class="sc-bdfBwQ Text-msjfkz-0 bjGZcz toc-link" href="#header-4"><strong>Pulling the Latest Bitcoin (BTC) Price</strong></a></li><li><a class="sc-bdfBwQ Text-msjfkz-0 bjGZcz toc-link" href="#header-5"><strong>Advanced Usage and Custom Functions</strong></a></li><li><a class="sc-bdfBwQ Text-msjfkz-0 bjGZcz toc-link" href="#header-6"><strong>Real-World Applications and Use Cases</strong></a></li><li><a class="sc-bdfBwQ Text-msjfkz-0 bjGZcz toc-link" href="#header-7"><strong>Troubleshooting Common Issues</strong></a></li><li><a class="sc-bdfBwQ Text-msjfkz-0 bjGZcz toc-link" href="#header-8"><strong>Best Practices for API Integration</strong></a></li><li><a class="sc-bdfBwQ Text-msjfkz-0 bjGZcz toc-link" href="#header-9"><strong>Conclusion</strong></a></li></ul></div><article class="sc-bdfBwQ Container-sc-4c5vqs-0 ArticleContent__ArticleContainer-sc-18n1x4l-0 cdVqKV khdEkh ljODsN"><h2 id="header-0" class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 iLpgJa ehzvDo"><strong>Introduction</strong></h2><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">CoinMarketCap, as a leading cryptocurrency price tracking website, offers an extensive API that provides real-time and historical data on cryptocurrencies, exchanges, and global market metrics. In this blog post, we’ll explore how to integrate the CoinMarketCap API with Google Sheets, a powerful tool for data analysis and visualization.</p><div class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">Integrating the <a href="https://coinmarketcap.com/api/" rel="noopener noreferrer" target="_blank" class="sc-bdfBwQ Text-msjfkz-0 gbfvns">CoinMarketCap API</a> with Google Sheets allows users to create dynamic spreadsheets that update automatically with the latest cryptocurrency data. This can be an invaluable asset for tracking portfolio performance, analyzing market trends, or even building custom dashboards for deeper insights into the crypto market.</div><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">We'll guide you through the entire process, from setting up your API key to writing custom functions in Google Sheets. Whether you’re a seasoned developer or a beginner in programming, our step-by-step guide is designed to provide valuable insights for all skill levels.</p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">Stay tuned as we dive into the world of cryptocurrencies and demonstrate how you can leverage the CoinMarketCap API to bring live data right into your Google Sheets.</p><h2 id="header-1" class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 iLpgJa ehzvDo"><strong>Understanding the CoinMarketCap API</strong></h2><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">Before diving into the integration process, it's essential to understand what the CoinMarketCap API offers. This API is a collection of endpoints that allow you to interact with CoinMarketCap's extensive database of cryptocurrency information. It provides various data points including cryptocurrency prices, market cap rankings, volume, historical data, and more.</p><div class="sc-bdfBwQ iumvLK"><div class="sc-gsTCUz hFwcgf"><a href="/newsletter" class="sc-bdfBwQ Button__StyledButton-sc-1kvh4an-0 cCzBkx">Subscribe</a></div><p class="sc-bdfBwQ Text-msjfkz-0 fdbMey">Join us in showcasing the cryptocurrency revolution, one newsletter at a time. Subscribe now to get daily news and market updates right to your inbox, along with our millions of other subscribers (that’s right, millions love us!) — what are you waiting for?</p></div><h3 id="key-features-of-the-coinmarketcap-api" class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 iLpgJa gYQtxK">Key Features of the CoinMarketCap API</h3><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong><a href="https://coinmarketcap.com/api/documentation/v1/#tag/cryptocurrency" rel="noopener noreferrer" target="_blank" class="sc-bdfBwQ Text-msjfkz-0 gbfvns">Market Data</a></strong>: Access real-time and historical market data for over 2,000 cryptocurrencies.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong><a href="https://coinmarketcap.com/api/documentation/v1/#operation/getV2CryptocurrencyQuotesHistorical" rel="noopener noreferrer" target="_blank" class="sc-bdfBwQ Text-msjfkz-0 gbfvns">Cryptocurrency Details</a></strong>: Retrieve detailed information about individual cryptocurrencies such as their current price, market cap, trading volume, and circulating supply.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong><a href="https://coinmarketcap.com/api/documentation/v1/#tag/exchange" rel="noopener noreferrer" target="_blank" class="sc-bdfBwQ Text-msjfkz-0 gbfvns">Exchange Information</a></strong>: Get data about various cryptocurrency exchanges including trading pairs, volumes, and rankings.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong><a href="https://coinmarketcap.com/api/documentation/v1/#tag/global-metrics" rel="noopener noreferrer" target="_blank" class="sc-bdfBwQ Text-msjfkz-0 gbfvns">Global Metrics</a></strong>: Understand the broader market trends with global metrics like total market cap, Bitcoin dominance, and others.</li></ul><h3 id="strong-why-is-it-important-in-the-crypto-market-context-strong" class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 iLpgJa gYQtxK"><strong>Why is it important in the crypto market context?</strong></h3><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Timely Information</strong>: Having access to the latest data is critical for making informed decisions.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Data Reliability</strong>: CoinMarketCap is known for its comprehensive and accurate data, which is essential for trust in the crypto community.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Market Insights</strong>: The API's extensive data offerings can help users gain deeper insights into market dynamics and trends.</li></ul><h2 id="header-2" class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 iLpgJa ehzvDo"><strong>Prerequisites for Integration</strong></h2><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">To integrate the CoinMarketCap API with Google Sheets, you need:</p><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>A CoinMarketCap API Key</strong>: <a href="https://pro.coinmarketcap.com/signup" rel="noopener noreferrer" target="_blank" class="sc-bdfBwQ Text-msjfkz-0 gbfvns">Sign up</a> on the CoinMarketCap website to obtain your free API key. This key is necessary to authenticate your requests.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Google Sheets</strong>: Basic familiarity with <a href="https://www.google.com/sheets/about/" rel="noopener noreferrer" target="_blank" class="sc-bdfBwQ Text-msjfkz-0 gbfvns">Google Sheets</a> is required. If you're new, spend some time exploring its interface.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Google Apps Script</strong>: This is a <a href="https://www.google.com/script/start/" rel="noopener noreferrer" target="_blank" class="sc-bdfBwQ Text-msjfkz-0 gbfvns">scripting platform developed by Google</a> for light-weight application development in the Google Workspace platform. Basic understanding of JavaScript is a plus.</li></ul><h2 id="header-3" class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 iLpgJa ehzvDo"><strong>Step-by-Step Integration Guide</strong></h2><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">Integrating the CoinMarketCap API with Google Sheets requires a series of steps to ensure seamless data flow and functionality. Here’s a detailed guide to help you through the process:</p><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Accessing Google Sheets and Setting Up a Script</strong></li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Open Google Sheets and create a new spreadsheet.</li></ul></ul><figure><div class="lazyload-wrapper "><div style="height:200px" class="lazyload-placeholder"></div></div></figure><div class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"></div><ul class="Renderer__List-mfgg8t-1 kEBbNN"><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Click on Extensions in the menu, then select Apps Script.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">This opens a new tab where you can write and run Google Apps Script, a JavaScript-based platform.</li></ul><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Writing the Script to Call the CoinMarketCap API</strong></li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">In the Apps Script editor, start by defining a function to call the CoinMarketCap API.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Use the UrlFetchApp method in Google Apps Script to make HTTP requests to the API.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Include your CoinMarketCap API key in the request header for authentication.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Here’s a basic script template for fetching the latest price of a specific cryptocurrency:</li></ul></ul><div class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"></div><figure><div class="lazyload-wrapper "><div style="height:200px" class="lazyload-placeholder"></div></div></figure><div class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"></div><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"><em>function getCryptoData() {<br/><br/> var url = "https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest";<br/> var apiKey = 'YOUR_API_KEY'; // Replace with your API key<br/> var headers = {<br/> "X-CMC_PRO_API_KEY": apiKey,<br/> "Accept": "application/json"<br/> };</em></p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"><em> var response = UrlFetchApp.fetch(url, {'headers': headers});<br/> var json = JSON.parse(response.getContentText());</em></p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"><em> return json.data[0].quote.USD.price; // Example: Fetches the price of the first listed cryptocurrency in USD<br/>}</em></p><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">This script can be customized to fetch different types of data based on your needs.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Importing Data into Google Sheets</li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Once your script is ready, you can call the getCryptoData function from your Google Sheets.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Use the =getCryptoData() formula in a cell where you want the data to appear.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">The data returned by the script will be displayed in the selected cell.</li></ul></ul><div class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"></div><figure><div class="lazyload-wrapper "><div style="height:200px" class="lazyload-placeholder"></div></div></figure><div class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"></div><figure><div class="lazyload-wrapper "><div style="height:200px" class="lazyload-placeholder"></div></div></figure><div class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"></div><figure><div class="lazyload-wrapper "><div style="height:200px" class="lazyload-placeholder"></div></div></figure><div class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"></div><figure><div class="lazyload-wrapper "><div style="height:200px" class="lazyload-placeholder"></div></div></figure><div class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"></div><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Automating Data Refresh</li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">To ensure your data is always up to date, you can set triggers to refresh the data at regular intervals.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">In the Apps Script editor, click on the clock icon to open the Triggers page.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Set a time-driven trigger to run the getCryptoData function periodically (e.g., every hour).</li></ul></ul><h2 id="header-4" class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 iLpgJa ehzvDo"><strong>Pulling the Latest Bitcoin (BTC) Price</strong></h2><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">One of the most common use cases for the CoinMarketCap API is retrieving the latest price of Bitcoin (BTC). This section will walk you through creating a script to fetch the latest BTC price and how to display it in Google Sheets.</p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"><strong>1. Setting Up the Script</strong></p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">To pull the latest BTC price, you'll primarily use the `/v1/cryptocurrency/quotes/latest` endpoint of the CoinMarketCap API.</p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">This endpoint allows you to retrieve the latest quote for one or more cryptocurrencies.</p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"><strong>2. Creating the Function in Google Apps Script</strong></p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">Here’s an example function that fetches the latest price of Bitcoin:</p><div class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">f<em>unction getLatestBTCPrice() {</em></div><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"><em> var url = "https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest";<br/> var apiKey = 'YOUR_API_KEY'; // Replace with your API key<br/> var headers = {<br/> "X-CMC_PRO_API_KEY": apiKey,<br/> "Accept": "application/json"<br/> };</em></p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"><em> var parameters = {<br/> "symbol": "BTC"<br/> };</em></p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"><em> var response = UrlFetchApp.fetch(url + "?" + Object.keys(parameters).map(key => key + '=' + <br/> parameters[key]).join('&'), {'headers': headers});<br/> var json = JSON.parse(response.getContentText());<br/> var btcPrice = json.data.BTC.quote.USD.price;</em></p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"><em> return btcPrice;<br/>}</em></p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">This script makes a request to the CoinMarketCap API for the latest Bitcoin data and parses the JSON response to extract the price in USD.</p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"><strong>3. Implementing the Function in Google Sheets</strong></p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">In Google Sheets, simply type `=getLatestBTCPrice()` in a cell where you want to display the latest BTC price.The function will fetch and display the current price of Bitcoin as per the latest data available from CoinMarketCap.</p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF"><strong>4. Updating the Price Automatically</strong></p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">To ensure the BTC price in your sheet is always current, you can set a time-driven trigger in Google Apps Script to refresh the data periodically.</p><h2 id="header-5" class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 iLpgJa ehzvDo"><strong>Advanced Usage and Custom Functions</strong></h2><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">After mastering the basic integration, you can enhance your Google Sheets with custom functions to perform more complex data manipulations and analyses. This involves writing more sophisticated scripts in Google Apps Script and using them in your Sheets. Here’s how to proceed:</p><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Creating Advanced Scripts</strong></li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Write functions in Google Apps Script to perform tasks like aggregating data, filtering based on certain criteria, or converting currency values.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">For example, you might write a function to calculate the average price of a selection of cryptocurrencies over a given period.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">These scripts can utilize loops, conditionals, and other JavaScript functionalities to process the data from CoinMarketCap.</li></ul><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Using Custom Functions in Sheets</strong></li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Similar to built-in functions in Google Sheets, your custom functions can be called directly in the cells.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">For instance, if you have written a function named getAveragePrice, you can use it in a cell by typing =getAveragePrice(“Bitcoin”, “30days”).</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">This approach allows for dynamic and interactive data analysis directly within Google Sheets.</li></ul><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Visualizing Data</strong></li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Google Sheets offers various ways to visualize your data, like charts and graphs.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Utilize these tools to create dynamic visualizations that update automatically as your CoinMarketCap data changes.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">This can be particularly useful for tracking market trends or comparing the performance of different cryptocurrencies.</li></ul></ul><h2 id="header-6" class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 iLpgJa ehzvDo"><strong>Real-World Applications and Use Cases</strong></h2><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">Integrating the CoinMarketCap API with Google Sheets has numerous practical applications. Here are some examples to illustrate its potential:</p><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Portfolio Tracking</strong></li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Create a spreadsheet that tracks the value of your cryptocurrency portfolio in real-time.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Automatically update your holdings' values based on the current market prices.</li></ul><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Market Analysis</strong></li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Analyze market trends by fetching historical data and visualizing it in Google Sheets.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Compare the performance of various cryptocurrencies over different time frames.</li></ul><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Automated Alerts</strong></li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Set up scripts in Google Sheets to send email alerts based on specific market conditions, like a sudden increase or decrease in a cryptocurrency’s price.</li></ul></ul><h2 id="header-7" class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 iLpgJa ehzvDo"><strong>Troubleshooting Common Issues</strong></h2><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">While integrating and using the CoinMarketCap API with Google Sheets, you might encounter several common issues. Here’s how to address them:</p><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>API Limit Exceeded</strong></li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">CoinMarketCap API has rate limits. If exceeded, you may receive errors.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Optimize your script to make fewer calls or upgrade your API plan if necessary.</li></ul><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Data Parsing Errors</strong></li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Errors may occur if the format of the data returned by the API changes.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Regularly check and update your script to accommodate any changes in the API response structure.</li></ul><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Script Execution Errors</strong></li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Debugging tools in Google Apps Script can help identify and fix issues in your code.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Ensure that you handle exceptions and errors gracefully in your script.</li></ul></ul><h2 id="header-8" class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 iLpgJa ehzvDo"><strong>Best Practices for API Integration</strong></h2><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">Ensuring a smooth and efficient integration involves adhering to certain best practices. Here are key considerations to keep in mind while working with the CoinMarketCap API and Google Sheets:</p><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Data Accuracy and Integrity</strong></li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Regularly verify the accuracy of the data fetched from the API.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Implement checks within your scripts to detect and handle any anomalies or discrepancies in the data.</li></ul><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Managing API Call Limits</strong></li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Be mindful of the rate limits imposed by the CoinMarketCap API.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Efficiently structure your API calls to maximize data retrieval while staying within these limits.</li></ul><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Securing API Keys</strong></li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Keep your API key secure and avoid exposing it in shared documents or public repositories.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Use Google Apps Script's properties service to store and access API keys securely.</li></ul><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo"><strong>Optimizing Performance</strong></li><ul class="Renderer__List-mfgg8t-1 kEBbNN"><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">For large datasets, optimize your scripts to reduce loading times and improve responsiveness.</li><li class="sc-bdfBwQ Text-msjfkz-0 byJUJo">Use caching where appropriate to store and reuse data, reducing the need for frequent API calls.</li></ul></ul><h2 id="header-9" class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 iLpgJa ehzvDo"><strong>Conclusion</strong></h2><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">We’ve explored how to integrate the CoinMarketCap API with Google Sheets, from basic setup to advanced functionalities. This powerful combination opens up a world of possibilities for cryptocurrency enthusiasts, traders, and analysts. By leveraging the real-time data and extensive features of the CoinMarketCap API, you can gain deeper insights into the crypto market and make more informed decisions.</p><p class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">We encourage you to try this integration and explore the various ways it can be customized to suit your needs. Whether you’re tracking your portfolio, analyzing market trends, or setting up automated alerts, the flexibility and power of this integration are bound to enhance your cryptocurrency journey.</p><div class="sc-bdfBwQ Text-msjfkz-0 Renderer___StyledText-mfgg8t-7 kVrfYF">Get your free API key here: <a href="https://pro.coinmarketcap.com/signup" rel="noopener noreferrer" target="_blank" class="sc-bdfBwQ Text-msjfkz-0 gbfvns">https://pro.coinmarketcap.com/signup</a><br/>Got questions? Email us at <a href="mailto:api@coinmarketcap.com" class="sc-bdfBwQ Text-msjfkz-0 gbfvns">api@coinmarketcap.com</a></div></article></div></div><div class="sc-bdfBwQ gPOvAF"><button type="button" class="LikeButton__StyledButton-sc-1xl44e6-0 eTnhwi"><svg viewBox="0 0 26 23" fill="none" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 hZZWDZ"><path d="M2.75736 3.14987C0.414213 5.41675 0.414213 9.0921 2.75736 11.359L13.0001 21.2683L23.2426 11.359C25.5858 9.0921 25.5858 5.41675 23.2426 3.14987C20.8995 0.882986 17.1005 0.882986 14.7574 3.14987L13.0001 4.8501L11.2426 3.14987C8.8995 0.882986 5.10051 0.882986 2.75736 3.14987Z" stroke="currentColor" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"></path></svg></button><div class="sc-bdfBwQ Text-msjfkz-0 bFLuOX">18 people liked this article</div></div><div style="padding-top:0" class="sc-bdfBwQ Container-sc-4c5vqs-0 dCEoLC khdEkh"><div class="ArticleAuthor__AuthorSection-t18p1k-0 bKWLgX"><a class="image-link" href="/academy/author/coinmarketcap"><span style="box-sizing:border-box;display:inline-block;overflow:hidden;width:initial;height:initial;background:none;opacity:1;border:0;margin:0;padding:0;position:relative;max-width:100%"><span style="box-sizing:border-box;display:block;width:initial;height:initial;background:none;opacity:1;border:0;margin:0;padding:0;max-width:100%"><img style="display:block;max-width:100%;width:initial;height:initial;background:none;opacity:1;border:0;margin:0;padding:0" alt="" aria-hidden="true" src="data:image/svg+xml,%3csvg%20xmlns=%27http://www.w3.org/2000/svg%27%20version=%271.1%27%20width=%2772%27%20height=%2772%27/%3e"/></span><img alt="CoinMarketCap" src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" decoding="async" data-nimg="intrinsic" style="position:absolute;top:0;left:0;bottom:0;right:0;box-sizing:border-box;padding:0;border:none;margin:auto;display:block;width:0;height:0;min-width:100%;max-width:100%;min-height:100%;max-height:100%;object-fit:cover"/><noscript><img alt="CoinMarketCap" srcSet="https://academy-public.coinmarketcap.com/uploads/f261437425d54805adb1ff0313b8ce67.jpeg 1x, https://academy-public.coinmarketcap.com/uploads/f261437425d54805adb1ff0313b8ce67.jpeg 2x" src="https://academy-public.coinmarketcap.com/uploads/f261437425d54805adb1ff0313b8ce67.jpeg" decoding="async" data-nimg="intrinsic" style="position:absolute;top:0;left:0;bottom:0;right:0;box-sizing:border-box;padding:0;border:none;margin:auto;display:block;width:0;height:0;min-width:100%;max-width:100%;min-height:100%;max-height:100%;object-fit:cover" loading="lazy"/></noscript></span></a><div><a href="/academy/author/coinmarketcap"><h3>CoinMarketCap</h3></a><p>I'm CoinMarketCap — you've probably heard of me.</p></div></div></div><div class="sc-bdfBwQ dBQaiO"><div class="sc-bdfBwQ Container-sc-4c5vqs-0 kA-dzTb khdEkh"><h3 class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 bjGlIw dAnDNe">Related Articles</h3></div><div class="sc-bdfBwQ Container-sc-4c5vqs-0 kA-dzTb khdEkh sc-bdfBwQ Grid-sc-3uwl3g-0 bGWzuD ZAQjM"><a href="/academy/article/how-to-claim-season-1-hamster-kombat-hmstr-airdrop-tokens" class="sc-bdfBwQ ArticleCard__ArticleBox-sc-4ctgqh-0 iXxiMt jZHrE"><div class="sc-gsTCUz ghfBCu"><div class="sc-bdfBwQ LazyBackground__Background-sc-16pnu62-0 ftOUaZ fqZiSi"></div><div class="sc-bdfBwQ jzZbpr"><div class="ArticleCard__Category-sc-4ctgqh-1 SmqGy">Tap To Earn</div><div title="How to Claim Season 1 Hamster Kombat (HMSTR) Airdrop Tokens" class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 Title__StyledTitle-sc-6yi3ll-0 bXSEgn ffRerq gRgJsG">How to Claim Season 1 Hamster Kombat (HMSTR) Airdrop Tokens</div><div class="sc-bdfBwQ Text-msjfkz-0 hOMFgM">A simple guide to claiming HMSTR tokens in Season 1.</div></div><div class="sc-gsTCUz hoYWsg"><div class="sc-bdfBwQ Text-msjfkz-0 fDPsJm">By Decentralized Dog</div></div><div class="sc-gsTCUz gvdfNf"><span class="sc-bdfBwQ Text-msjfkz-0 fDPsJm">4mo ago</span><div class="sc-gsTCUz dSCuHF"><svg viewBox="0 0 24 24" size="12" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 hAnSfs"><path d="M11.9963 4C13.5785 4 15.1252 4.46919 16.4408 5.34824C17.7564 6.22729 18.7818 7.47672 19.3873 8.93853C19.9928 10.4003 20.1512 12.0089 19.8426 13.5607C19.5339 15.1126 18.772 16.538 17.6531 17.6569C16.5343 18.7757 15.1089 19.5376 13.557 19.8463C12.0052 20.155 10.3966 19.9965 8.93481 19.391C7.473 18.7855 6.22358 17.7602 5.34452 16.4446C4.46547 15.129 3.99628 13.5823 3.99628 12C3.99871 9.87901 4.84234 7.84559 6.34211 6.34583C7.84187 4.84606 9.87529 4.00243 11.9963 4ZM11.9963 2C10.0185 2 8.08507 2.58649 6.44058 3.6853C4.79609 4.78412 3.51436 6.3459 2.75749 8.17317C2.00061 10.0004 1.80258 12.0111 2.18843 13.9509C2.57428 15.8907 3.52669 17.6725 4.92521 19.0711C6.32374 20.4696 8.10557 21.422 10.0454 21.8079C11.9852 22.1937 13.9959 21.9957 15.8231 21.2388C17.6504 20.4819 19.2122 19.2002 20.311 17.5557C21.4098 15.9112 21.9963 13.9778 21.9963 12C21.9963 10.6868 21.7377 9.38641 21.2351 8.17315C20.7326 6.95988 19.996 5.85748 19.0674 4.92889C18.1388 4.0003 17.0364 3.26371 15.8231 2.76117C14.6099 2.25863 13.3095 1.99998 11.9963 2Z" fill="currentColor"></path><path d="M15.561 16.972L11.003 12.414V6.004H13.003V11.586L16.975 15.558L15.561 16.972Z" fill="currentColor"></path></svg><span class="sc-bdfBwQ Text-msjfkz-0 czscDz">2m</span></div></div></div></a><a href="/academy/article/democratising-dex-data-with-coinmarketcaps-new-api-service" class="sc-bdfBwQ ArticleCard__ArticleBox-sc-4ctgqh-0 iXxiMt jZHrE"><div class="sc-gsTCUz ghfBCu"><div class="sc-bdfBwQ LazyBackground__Background-sc-16pnu62-0 ftOUaZ fqZiSi"></div><div class="sc-bdfBwQ jzZbpr"><div class="ArticleCard__Category-sc-4ctgqh-1 SmqGy">How-to Guides</div><div title="Democratising DEX data with CoinMarketCap’s New API Service" class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 Title__StyledTitle-sc-6yi3ll-0 bXSEgn ffRerq gRgJsG">Democratising DEX data with CoinMarketCap’s New API Service</div><div class="sc-bdfBwQ Text-msjfkz-0 hOMFgM">Introducing a state-of-the-art DEX API service, scheduled for launch in Q1 2024.</div></div><div class="sc-gsTCUz hoYWsg"><div class="sc-bdfBwQ Text-msjfkz-0 fDPsJm">By CoinMarketCap</div></div><div class="sc-gsTCUz gvdfNf"><span class="sc-bdfBwQ Text-msjfkz-0 fDPsJm">1yr ago</span><div class="sc-gsTCUz dSCuHF"><svg viewBox="0 0 24 24" size="12" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 hAnSfs"><path d="M11.9963 4C13.5785 4 15.1252 4.46919 16.4408 5.34824C17.7564 6.22729 18.7818 7.47672 19.3873 8.93853C19.9928 10.4003 20.1512 12.0089 19.8426 13.5607C19.5339 15.1126 18.772 16.538 17.6531 17.6569C16.5343 18.7757 15.1089 19.5376 13.557 19.8463C12.0052 20.155 10.3966 19.9965 8.93481 19.391C7.473 18.7855 6.22358 17.7602 5.34452 16.4446C4.46547 15.129 3.99628 13.5823 3.99628 12C3.99871 9.87901 4.84234 7.84559 6.34211 6.34583C7.84187 4.84606 9.87529 4.00243 11.9963 4ZM11.9963 2C10.0185 2 8.08507 2.58649 6.44058 3.6853C4.79609 4.78412 3.51436 6.3459 2.75749 8.17317C2.00061 10.0004 1.80258 12.0111 2.18843 13.9509C2.57428 15.8907 3.52669 17.6725 4.92521 19.0711C6.32374 20.4696 8.10557 21.422 10.0454 21.8079C11.9852 22.1937 13.9959 21.9957 15.8231 21.2388C17.6504 20.4819 19.2122 19.2002 20.311 17.5557C21.4098 15.9112 21.9963 13.9778 21.9963 12C21.9963 10.6868 21.7377 9.38641 21.2351 8.17315C20.7326 6.95988 19.996 5.85748 19.0674 4.92889C18.1388 4.0003 17.0364 3.26371 15.8231 2.76117C14.6099 2.25863 13.3095 1.99998 11.9963 2Z" fill="currentColor"></path><path d="M15.561 16.972L11.003 12.414V6.004H13.003V11.586L16.975 15.558L15.561 16.972Z" fill="currentColor"></path></svg><span class="sc-bdfBwQ Text-msjfkz-0 czscDz">5m</span></div></div></div></a><a href="/academy/article/bybit-launches-personality-based-trading-competition-for-5th-anniversary" class="sc-bdfBwQ ArticleCard__ArticleBox-sc-4ctgqh-0 iXxiMt jZHrE"><div class="sc-gsTCUz ghfBCu"><div class="sc-bdfBwQ LazyBackground__Background-sc-16pnu62-0 ftOUaZ fqZiSi"></div><div class="sc-bdfBwQ jzZbpr"><div class="ArticleCard__Category-sc-4ctgqh-1 SmqGy">How-to Guides</div><div title="Bybit Launches Personality-Based Trading Competition for 5th Anniversary With $1M Prize Pool: How To Take Part?" class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 Title__StyledTitle-sc-6yi3ll-0 bXSEgn ffRerq gRgJsG">Bybit Launches Personality-Based Trading Competition for 5th Anniversary With $1M Prize Pool: How...</div><div class="sc-bdfBwQ Text-msjfkz-0 hOMFgM">Bybit marks its fifth year since launching with a series of exciting events for traders and users, including NFT collections and a team-based trading competition.</div></div><div class="sc-gsTCUz hoYWsg"><div class="sc-bdfBwQ Text-msjfkz-0 fDPsJm">By Decentralized Dog</div></div><div class="sc-gsTCUz gvdfNf"><span class="sc-bdfBwQ Text-msjfkz-0 fDPsJm">1yr ago</span><div class="sc-gsTCUz dSCuHF"><svg viewBox="0 0 24 24" size="12" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 hAnSfs"><path d="M11.9963 4C13.5785 4 15.1252 4.46919 16.4408 5.34824C17.7564 6.22729 18.7818 7.47672 19.3873 8.93853C19.9928 10.4003 20.1512 12.0089 19.8426 13.5607C19.5339 15.1126 18.772 16.538 17.6531 17.6569C16.5343 18.7757 15.1089 19.5376 13.557 19.8463C12.0052 20.155 10.3966 19.9965 8.93481 19.391C7.473 18.7855 6.22358 17.7602 5.34452 16.4446C4.46547 15.129 3.99628 13.5823 3.99628 12C3.99871 9.87901 4.84234 7.84559 6.34211 6.34583C7.84187 4.84606 9.87529 4.00243 11.9963 4ZM11.9963 2C10.0185 2 8.08507 2.58649 6.44058 3.6853C4.79609 4.78412 3.51436 6.3459 2.75749 8.17317C2.00061 10.0004 1.80258 12.0111 2.18843 13.9509C2.57428 15.8907 3.52669 17.6725 4.92521 19.0711C6.32374 20.4696 8.10557 21.422 10.0454 21.8079C11.9852 22.1937 13.9959 21.9957 15.8231 21.2388C17.6504 20.4819 19.2122 19.2002 20.311 17.5557C21.4098 15.9112 21.9963 13.9778 21.9963 12C21.9963 10.6868 21.7377 9.38641 21.2351 8.17315C20.7326 6.95988 19.996 5.85748 19.0674 4.92889C18.1388 4.0003 17.0364 3.26371 15.8231 2.76117C14.6099 2.25863 13.3095 1.99998 11.9963 2Z" fill="currentColor"></path><path d="M15.561 16.972L11.003 12.414V6.004H13.003V11.586L16.975 15.558L15.561 16.972Z" fill="currentColor"></path></svg><span class="sc-bdfBwQ Text-msjfkz-0 czscDz">4m</span></div></div></div></a></div><div class="sc-gsTCUz hFwcgf"><a style="height:56px" href="/academy/article" class="sc-bdfBwQ Button__StyledButton-sc-1kvh4an-0 bxNOKk">See all articles<span class="Button__EndIcon-sc-1kvh4an-1 cEbvLE"><svg viewBox="0 0 18 15" fill="currentColor" xmlns="http://www.w3.org/2000/svg" class="sc-bdfBwQ Svg-sc-17i2kvj-0 bwxocM"><path d="M10.5 15L9.1 13.6L14.2 8.5L5.68248e-07 8.5L7.43094e-07 6.5L14.2 6.5L9.1 1.4L10.5 -6.55671e-07L18 7.5L10.5 15Z"></path></svg></span></a></div></div><div class="sc-bdfBwQ Container-sc-4c5vqs-0 jKSHrp khdEkh"><div class="sc-bdfBwQ iCRjms Newsletter__NewsletterSection-tgkqos-0 pQehZ"><p class="sc-bdfBwQ Text-msjfkz-0 bFOiFL">Join the thousands already learning crypto!</p><h3 class="sc-bdfBwQ Text-msjfkz-0 Heading-juwhnu-0 epLOPA dAnDNe">Join our free newsletter for daily crypto updates!</h3><div class="form"><div class="sc-gsTCUz hFwcgf"><a href="/newsletter" class="sc-bdfBwQ Button__StyledButton-sc-1kvh4an-0 cCzBkx">Subscribe</a></div></div></div></div><div class="Footer__FooterContainer-sc-1xgrmdq-1 cgHWSS"><footer><div class="Logo__SvgContainer-hxzlkl-0 hQeyNG"><a href="/" class="logo"><svg viewBox="0 0 76.52 77.67" xmlns="http://www.w3.org/2000/svg" color="primary"><path d="M66.54 46.41a4.09 4.09 0 01-4.17.28C60.83 45.82 60 43.78 60 41v-8.52c0-4.09-1.62-7-4.33-7.79-4.58-1.34-8 4.27-9.32 6.38l-8.1 13.11v-16c-.09-3.69-1.29-5.9-3.56-6.56-1.5-.44-3.75-.26-5.94 3.08L10.64 53.77A32 32 0 017 38.83C7 21.31 21 7.06 38.25 7.06s31.3 14.25 31.3 31.77v.18c.17 3.39-.93 6.09-3 7.4zm10-7.57v-.17C76.4 17.32 59.28 0 38.25 0S0 17.42 0 38.83s17.16 38.84 38.25 38.84a37.81 37.81 0 0026-10.36 3.56 3.56 0 00.18-5 3.43 3.43 0 00-4.86-.23A30.93 30.93 0 0115 60l16.3-26.2v12.09c0 5.81 2.25 7.69 4.14 8.24s4.78.17 7.81-4.75l9-14.57c.28-.47.55-.87.79-1.22V41c0 5.43 2.18 9.77 6 11.91a11 11 0 0011.21-.45c4.2-2.73 6.49-7.67 6.25-13.62z" fill="#17181b"></path></svg></a></div><div class="social"><a target="_blank" rel="noopener noreferrer" href="https://twitter.com/CoinMarketCap"><svg class="MuiSvgIcon-root" focusable="false" viewBox="0 0 24 24" aria-hidden="true"><path d="M22.46 6c-.77.35-1.6.58-2.46.69.88-.53 1.56-1.37 1.88-2.38-.83.5-1.75.85-2.72 1.05C18.37 4.5 17.26 4 16 4c-2.35 0-4.27 1.92-4.27 4.29 0 .34.04.67.11.98C8.28 9.09 5.11 7.38 3 4.79c-.37.63-.58 1.37-.58 2.15 0 1.49.75 2.81 1.91 3.56-.71 0-1.37-.2-1.95-.5v.03c0 2.08 1.48 3.82 3.44 4.21a4.22 4.22 0 0 1-1.93.07 4.28 4.28 0 0 0 4 2.98 8.521 8.521 0 0 1-5.33 1.84c-.34 0-.68-.02-1.02-.06C3.44 20.29 5.7 21 8.12 21 16 21 20.33 14.46 20.33 8.79c0-.19 0-.37-.01-.56.84-.6 1.56-1.36 2.14-2.23z"></path></svg></a><a target="_blank" rel="noopener noreferrer" href="https://instagram.com/coinmarketcap"><svg class="MuiSvgIcon-root" focusable="false" viewBox="0 0 24 24" aria-hidden="true"><path d="M7.8 2h8.4C19.4 2 22 4.6 22 7.8v8.4a5.8 5.8 0 0 1-5.8 5.8H7.8C4.6 22 2 19.4 2 16.2V7.8A5.8 5.8 0 0 1 7.8 2m-.2 2A3.6 3.6 0 0 0 4 7.6v8.8C4 18.39 5.61 20 7.6 20h8.8a3.6 3.6 0 0 0 3.6-3.6V7.6C20 5.61 18.39 4 16.4 4H7.6m9.65 1.5a1.25 1.25 0 0 1 1.25 1.25A1.25 1.25 0 0 1 17.25 8 1.25 1.25 0 0 1 16 6.75a1.25 1.25 0 0 1 1.25-1.25M12 7a5 5 0 0 1 5 5 5 5 0 0 1-5 5 5 5 0 0 1-5-5 5 5 0 0 1 5-5m0 2a3 3 0 0 0-3 3 3 3 0 0 0 3 3 3 3 0 0 0 3-3 3 3 0 0 0-3-3z"></path></svg></a><a target="_blank" rel="noopener noreferrer" href="https://www.facebook.com/CoinMarketCap"><svg class="MuiSvgIcon-root" focusable="false" viewBox="0 0 24 24" aria-hidden="true"><path d="M5 3h14a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2V5a2 2 0 0 1 2-2m13 2h-2.5A3.5 3.5 0 0 0 12 8.5V11h-2v3h2v7h3v-7h3v-3h-3V9a1 1 0 0 1 1-1h2V5z"></path></svg></a><a target="_blank" rel="noopener noreferrer" href="https://www.linkedin.com/company/coinmarketcap/"><svg class="MuiSvgIcon-root" focusable="false" viewBox="0 0 24 24" aria-hidden="true"><path d="M19 3a2 2 0 0 1 2 2v14a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2V5a2 2 0 0 1 2-2h14m-.5 15.5v-5.3a3.26 3.26 0 0 0-3.26-3.26c-.85 0-1.84.52-2.32 1.3v-1.11h-2.79v8.37h2.79v-4.93c0-.77.62-1.4 1.39-1.4a1.4 1.4 0 0 1 1.4 1.4v4.93h2.79M6.88 8.56a1.68 1.68 0 0 0 1.68-1.68c0-.93-.75-1.69-1.68-1.69a1.69 1.69 0 0 0-1.69 1.69c0 .93.76 1.68 1.69 1.68m1.39 9.94v-8.37H5.5v8.37h2.77z"></path></svg></a><a target="_blank" rel="noopener noreferrer" href="https://www.tiktok.com/@coinmarketcap"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 3225 3225" version="1.1"><path d="M 1656.667 347.667 C 1656.300 348.033, 1655.998 734.246, 1655.996 1205.917 C 1655.993 1787.154, 1655.658 2068.011, 1654.957 2077.500 C 1653.658 2095.071, 1650.672 2116.087, 1647.356 2131 C 1623.598 2237.836, 1553.486 2327.497, 1455.500 2376.352 C 1333.675 2437.092, 1188.170 2423.163, 1078.713 2340.284 C 1033.004 2305.673, 997.452 2262.144, 971.911 2209.517 C 954.173 2172.968, 943.569 2136.945, 938.346 2095.500 C 936.158 2078.137, 935.845 2033.118, 937.797 2016.500 C 945.929 1947.257, 970.660 1885.940, 1011.710 1833.241 C 1073.742 1753.608, 1164.430 1704.059, 1264.812 1694.955 C 1283.942 1693.220, 1325.494 1694.231, 1343 1696.858 C 1359.672 1699.360, 1377.304 1703.060, 1391.343 1707.002 C 1397.216 1708.651, 1402.241 1710, 1402.511 1710 C 1402.780 1710, 1403 1611.284, 1403 1490.631 L 1403 1271.262 1394.250 1270.142 C 1336.486 1262.747, 1273.186 1261.833, 1216.500 1267.575 C 1004.825 1289.018, 811.645 1394.647, 678.041 1562 C 600.765 1658.795, 547.067 1773.146, 522.137 1894 C 506.255 1970.993, 502.021 2055.078, 510.058 2133.902 C 532.485 2353.872, 645.695 2553.167, 824.084 2686.712 C 987.252 2808.862, 1189.714 2862.691, 1393 2837.970 C 1509.978 2823.745, 1623.296 2782.623, 1723.740 2717.949 C 1771.073 2687.472, 1810.621 2655.388, 1853.079 2613.022 C 1903.041 2563.168, 1939.608 2516.680, 1974.232 2459 C 2039.821 2349.734, 2076.849 2229.561, 2084.998 2099.517 C 2085.642 2089.246, 2086 1922.568, 2086 1633.145 L 2086 1182.756 2087.869 1184.128 C 2097.391 1191.117, 2143.163 1220.976, 2157 1229.226 C 2269.843 1296.502, 2391.394 1340.776, 2520 1361.444 C 2566.408 1368.903, 2625.602 1373.982, 2666.250 1373.995 L 2683 1374 2683 1159 L 2683 944 2670.250 943.996 C 2646.831 943.988, 2613.641 940.897, 2584.464 936.006 C 2478.567 918.253, 2380.928 872.803, 2297 802.193 C 2280.460 788.277, 2240.163 747.811, 2226.604 731.500 C 2153.177 643.171, 2108.102 541.999, 2092.054 429.500 C 2089.652 412.660, 2087.341 385.409, 2086.436 363.250 L 2085.772 347 1871.553 347 C 1753.732 347, 1657.033 347.300, 1656.667 347.667" stroke="none" fill="#fffcfc" fill-rule="evenodd"></path><path d="" stroke="none" fill="#fcfcfc" fill-rule="evenodd"></path></svg></a></div><div class="copyright"><div>©2025 CoinMarketCap</div></div></footer></div></div></div><script id="__NEXT_DATA__" type="application/json">{"props":{"pageProps":{"article":{"id":"6564b5ac2f4aeb35039407b3","title":"How to integrate CoinMarketCap API with Google Sheets","slug":"how-to-integrate-coinmarketcap-api-with-google-sheets","meta":"Learn how to integrate CoinMarketCap API with Google Sheets","visible":true,"image":{"original":"uploads/23daa0764a1244b9993851f43d6bc2dd.png","optimized":"optimized-uploads/23daa0764a1244b9993851f43d6bc2dd.png","thumbnail":"thumbnail-uploads/23daa0764a1244b9993851f43d6bc2dd.png"},"content":"\u003ch2 id=\"header-0\"\u003e\u003cstrong\u003eIntroduction\u003c/strong\u003e\u003c/h2\u003e\u003cp\u003eCoinMarketCap, as a leading cryptocurrency price tracking website, offers an extensive API that provides real-time and historical data on cryptocurrencies, exchanges, and global market metrics. In this blog post, we’ll explore how to integrate the CoinMarketCap API with Google Sheets, a powerful tool for data analysis and visualization.\u003c/p\u003e\u003cp\u003eIntegrating the \u003ca href=\"https://coinmarketcap.com/api/\" target=\"_blank\"\u003eCoinMarketCap API\u003c/a\u003e with Google Sheets allows users to create dynamic spreadsheets that update automatically with the latest cryptocurrency data. This can be an invaluable asset for tracking portfolio performance, analyzing market trends, or even building custom dashboards for deeper insights into the crypto market.\u003c/p\u003e\u003cp\u003eWe\u0026#x27;ll guide you through the entire process, from setting up your API key to writing custom functions in Google Sheets. Whether you’re a seasoned developer or a beginner in programming, our step-by-step guide is designed to provide valuable insights for all skill levels.\u003c/p\u003e\u003cp\u003eStay tuned as we dive into the world of cryptocurrencies and demonstrate how you can leverage the CoinMarketCap API to bring live data right into your Google Sheets.\u003c/p\u003e\u003ch2 id=\"header-1\"\u003e\u003cstrong\u003eUnderstanding the CoinMarketCap API\u003c/strong\u003e\u003c/h2\u003e\u003cp\u003eBefore diving into the integration process, it\u0026#x27;s essential to understand what the CoinMarketCap API offers. This API is a collection of endpoints that allow you to interact with CoinMarketCap\u0026#x27;s extensive database of cryptocurrency information. It provides various data points including cryptocurrency prices, market cap rankings, volume, historical data, and more.\u003c/p\u003e\u003ch3 id=\"key-features-of-the-coinmarketcap-api\"\u003eKey Features of the CoinMarketCap API\u003c/h3\u003e\u003cul\u003e\u003cli\u003e\u003cstrong\u003e\u003ca href=\"https://coinmarketcap.com/api/documentation/v1/#tag/cryptocurrency\" target=\"_blank\"\u003eMarket Data\u003c/a\u003e\u003c/strong\u003e: Access real-time and historical market data for over 2,000 cryptocurrencies.\u003c/li\u003e\u003cli\u003e\u003cstrong\u003e\u003ca href=\"https://coinmarketcap.com/api/documentation/v1/#operation/getV2CryptocurrencyQuotesHistorical\" target=\"_blank\"\u003eCryptocurrency Details\u003c/a\u003e\u003c/strong\u003e: Retrieve detailed information about individual cryptocurrencies such as their current price, market cap, trading volume, and circulating supply.\u003c/li\u003e\u003cli\u003e\u003cstrong\u003e\u003ca href=\"https://coinmarketcap.com/api/documentation/v1/#tag/exchange\" target=\"_blank\"\u003eExchange Information\u003c/a\u003e\u003c/strong\u003e: Get data about various cryptocurrency exchanges including trading pairs, volumes, and rankings.\u003c/li\u003e\u003cli\u003e\u003cstrong\u003e\u003ca href=\"https://coinmarketcap.com/api/documentation/v1/#tag/global-metrics\" target=\"_blank\"\u003eGlobal Metrics\u003c/a\u003e\u003c/strong\u003e: Understand the broader market trends with global metrics like total market cap, Bitcoin dominance, and others.\u003c/li\u003e\u003c/ul\u003e\u003ch3 id=\"strong-why-is-it-important-in-the-crypto-market-context-strong\"\u003e\u003cstrong\u003eWhy is it important in the crypto market context?\u003c/strong\u003e\u003c/h3\u003e\u003cul\u003e\u003cli\u003e\u003cstrong\u003eTimely Information\u003c/strong\u003e: Having access to the latest data is critical for making informed decisions.\u003c/li\u003e\u003cli\u003e\u003cstrong\u003eData Reliability\u003c/strong\u003e: CoinMarketCap is known for its comprehensive and accurate data, which is essential for trust in the crypto community.\u003c/li\u003e\u003cli\u003e\u003cstrong\u003eMarket Insights\u003c/strong\u003e: The API\u0026#x27;s extensive data offerings can help users gain deeper insights into market dynamics and trends.\u003c/li\u003e\u003c/ul\u003e\u003ch2 id=\"header-2\"\u003e\u003cstrong\u003ePrerequisites for Integration\u003c/strong\u003e\u003c/h2\u003e\u003cp\u003eTo integrate the CoinMarketCap API with Google Sheets, you need:\u003c/p\u003e\u003cul\u003e\u003cli\u003e\u003cstrong\u003eA CoinMarketCap API Key\u003c/strong\u003e: \u003ca href=\"https://pro.coinmarketcap.com/signup\" target=\"_blank\"\u003eSign up\u003c/a\u003e on the CoinMarketCap website to obtain your free API key. This key is necessary to authenticate your requests.\u003c/li\u003e\u003cli\u003e\u003cstrong\u003eGoogle Sheets\u003c/strong\u003e: Basic familiarity with \u003ca href=\"https://www.google.com/sheets/about/\" target=\"_blank\"\u003eGoogle Sheets\u003c/a\u003e is required. If you\u0026#x27;re new, spend some time exploring its interface.\u003c/li\u003e\u003cli\u003e\u003cstrong\u003eGoogle Apps Script\u003c/strong\u003e: This is a \u003ca href=\"https://www.google.com/script/start/\" target=\"_blank\"\u003escripting platform developed by Google\u003c/a\u003e for light-weight application development in the Google Workspace platform. Basic understanding of JavaScript is a plus.\u003c/li\u003e\u003c/ul\u003e\u003ch2 id=\"header-3\"\u003e\u003cstrong\u003eStep-by-Step Integration Guide\u003c/strong\u003e\u003c/h2\u003e\u003cp\u003eIntegrating the CoinMarketCap API with Google Sheets requires a series of steps to ensure seamless data flow and functionality. Here’s a detailed guide to help you through the process:\u003c/p\u003e\u003cul\u003e\u003cli\u003e\u003cstrong\u003eAccessing Google Sheets and Setting Up a Script\u003c/strong\u003e\u003c/li\u003e\u003cul\u003e\u003cli\u003eOpen Google Sheets and create a new spreadsheet.\u003c/li\u003e\u003c/ul\u003e\u003c/ul\u003e\u003cfigure\u003e\u003cimg src=\"https://academy-public.coinmarketcap.com/optimized-uploads/70043d21419947aa819052d9b6e1c061.png\"/\u003e\u003c/figure\u003e\u003cp\u003e\u003c/p\u003e\u003cul\u003e\u003cul\u003e\u003cli\u003eClick on Extensions in the menu, then select Apps Script.\u003c/li\u003e\u003cli\u003eThis opens a new tab where you can write and run Google Apps Script, a JavaScript-based platform.\u003c/li\u003e\u003c/ul\u003e\u003cli\u003e\u003cstrong\u003eWriting the Script to Call the CoinMarketCap API\u003c/strong\u003e\u003c/li\u003e\u003cul\u003e\u003cli\u003eIn the Apps Script editor, start by defining a function to call the CoinMarketCap API.\u003c/li\u003e\u003cli\u003eUse the UrlFetchApp method in Google Apps Script to make HTTP requests to the API.\u003c/li\u003e\u003cli\u003eInclude your CoinMarketCap API key in the request header for authentication.\u003c/li\u003e\u003cli\u003eHere’s a basic script template for fetching the latest price of a specific cryptocurrency:\u003c/li\u003e\u003c/ul\u003e\u003c/ul\u003e\u003cp\u003e\u003c/p\u003e\u003cfigure\u003e\u003cimg src=\"https://academy-public.coinmarketcap.com/optimized-uploads/defce34f31b7482fb7fa1e24dfa7363e.png\"/\u003e\u003c/figure\u003e\u003cp\u003e\u003c/p\u003e\u003cp\u003e\u003cem\u003efunction getCryptoData() {\u003cbr/\u003e\u003cbr/\u003e var url = \u0026quot;https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest\u0026quot;;\u003cbr/\u003e var apiKey = \u0026#x27;YOUR_API_KEY\u0026#x27;; // Replace with your API key\u003cbr/\u003e var headers = {\u003cbr/\u003e \u0026quot;X-CMC_PRO_API_KEY\u0026quot;: apiKey,\u003cbr/\u003e \u0026quot;Accept\u0026quot;: \u0026quot;application/json\u0026quot;\u003cbr/\u003e };\u003c/em\u003e\u003c/p\u003e\u003cp\u003e\u003cem\u003e var response = UrlFetchApp.fetch(url, {\u0026#x27;headers\u0026#x27;: headers});\u003cbr/\u003e var json = JSON.parse(response.getContentText());\u003c/em\u003e\u003c/p\u003e\u003cp\u003e\u003cem\u003e return json.data[0].quote.USD.price; // Example: Fetches the price of the first listed cryptocurrency in USD\u003cbr/\u003e}\u003c/em\u003e\u003c/p\u003e\u003cul\u003e\u003cli\u003eThis script can be customized to fetch different types of data based on your needs.\u003c/li\u003e\u003cli\u003eImporting Data into Google Sheets\u003c/li\u003e\u003cul\u003e\u003cli\u003eOnce your script is ready, you can call the getCryptoData function from your Google Sheets.\u003c/li\u003e\u003cli\u003eUse the =getCryptoData() formula in a cell where you want the data to appear.\u003c/li\u003e\u003cli\u003eThe data returned by the script will be displayed in the selected cell.\u003c/li\u003e\u003c/ul\u003e\u003c/ul\u003e\u003cp\u003e\u003c/p\u003e\u003cfigure\u003e\u003cimg src=\"https://academy-public.coinmarketcap.com/optimized-uploads/8eacf250ff7b4c32b376ddac3f8b0f05.png\"/\u003e\u003c/figure\u003e\u003cp\u003e\u003c/p\u003e\u003cfigure\u003e\u003cimg src=\"https://academy-public.coinmarketcap.com/optimized-uploads/b2e05771b15541588c225c7b4801cdc4.png\"/\u003e\u003c/figure\u003e\u003cp\u003e\u003c/p\u003e\u003cfigure\u003e\u003cimg src=\"https://academy-public.coinmarketcap.com/optimized-uploads/6e84f16e0d0446b997a8f430400118bc.png\"/\u003e\u003c/figure\u003e\u003cp\u003e\u003c/p\u003e\u003cfigure\u003e\u003cimg src=\"https://academy-public.coinmarketcap.com/optimized-uploads/51c3747889ab4ace8c0af3b16166c845.png\"/\u003e\u003c/figure\u003e\u003cp\u003e\u003c/p\u003e\u003cul\u003e\u003cli\u003eAutomating Data Refresh\u003c/li\u003e\u003cul\u003e\u003cli\u003eTo ensure your data is always up to date, you can set triggers to refresh the data at regular intervals.\u003c/li\u003e\u003cli\u003eIn the Apps Script editor, click on the clock icon to open the Triggers page.\u003c/li\u003e\u003cli\u003eSet a time-driven trigger to run the getCryptoData function periodically (e.g., every hour).\u003c/li\u003e\u003c/ul\u003e\u003c/ul\u003e\u003ch2 id=\"header-4\"\u003e\u003cstrong\u003ePulling the Latest Bitcoin (BTC) Price\u003c/strong\u003e\u003c/h2\u003e\u003cp\u003eOne of the most common use cases for the CoinMarketCap API is retrieving the latest price of Bitcoin (BTC). This section will walk you through creating a script to fetch the latest BTC price and how to display it in Google Sheets.\u003c/p\u003e\u003cp\u003e\u003cstrong\u003e1. Setting Up the Script\u003c/strong\u003e\u003c/p\u003e\u003cp\u003eTo pull the latest BTC price, you\u0026#x27;ll primarily use the \u0026#x60;/v1/cryptocurrency/quotes/latest\u0026#x60; endpoint of the CoinMarketCap API.\u003c/p\u003e\u003cp\u003eThis endpoint allows you to retrieve the latest quote for one or more cryptocurrencies.\u003c/p\u003e\u003cp\u003e\u003cstrong\u003e2. Creating the Function in Google Apps Script\u003c/strong\u003e\u003c/p\u003e\u003cp\u003eHere’s an example function that fetches the latest price of Bitcoin:\u003c/p\u003e\u003cp\u003ef\u003cem\u003eunction getLatestBTCPrice() {\u003c/em\u003e\u003c/p\u003e\u003cp\u003e\u003cem\u003e var url = \u0026quot;https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest\u0026quot;;\u003cbr/\u003e var apiKey = \u0026#x27;YOUR_API_KEY\u0026#x27;; // Replace with your API key\u003cbr/\u003e var headers = {\u003cbr/\u003e \u0026quot;X-CMC_PRO_API_KEY\u0026quot;: apiKey,\u003cbr/\u003e \u0026quot;Accept\u0026quot;: \u0026quot;application/json\u0026quot;\u003cbr/\u003e };\u003c/em\u003e\u003c/p\u003e\u003cp\u003e\u003cem\u003e var parameters = {\u003cbr/\u003e \u0026quot;symbol\u0026quot;: \u0026quot;BTC\u0026quot;\u003cbr/\u003e };\u003c/em\u003e\u003c/p\u003e\u003cp\u003e\u003cem\u003e var response = UrlFetchApp.fetch(url + \u0026quot;?\u0026quot; + Object.keys(parameters).map(key =\u0026gt; key + \u0026#x27;=\u0026#x27; + \u003cbr/\u003e parameters[key]).join(\u0026#x27;\u0026amp;\u0026#x27;), {\u0026#x27;headers\u0026#x27;: headers});\u003cbr/\u003e var json = JSON.parse(response.getContentText());\u003cbr/\u003e var btcPrice = json.data.BTC.quote.USD.price;\u003c/em\u003e\u003c/p\u003e\u003cp\u003e\u003cem\u003e return btcPrice;\u003cbr/\u003e}\u003c/em\u003e\u003c/p\u003e\u003cp\u003eThis script makes a request to the CoinMarketCap API for the latest Bitcoin data and parses the JSON response to extract the price in USD.\u003c/p\u003e\u003cp\u003e\u003cstrong\u003e3. Implementing the Function in Google Sheets\u003c/strong\u003e\u003c/p\u003e\u003cp\u003eIn Google Sheets, simply type \u0026#x60;=getLatestBTCPrice()\u0026#x60; in a cell where you want to display the latest BTC price.The function will fetch and display the current price of Bitcoin as per the latest data available from CoinMarketCap.\u003c/p\u003e\u003cp\u003e\u003cstrong\u003e4. Updating the Price Automatically\u003c/strong\u003e\u003c/p\u003e\u003cp\u003eTo ensure the BTC price in your sheet is always current, you can set a time-driven trigger in Google Apps Script to refresh the data periodically.\u003c/p\u003e\u003ch2 id=\"header-5\"\u003e\u003cstrong\u003eAdvanced Usage and Custom Functions\u003c/strong\u003e\u003c/h2\u003e\u003cp\u003eAfter mastering the basic integration, you can enhance your Google Sheets with custom functions to perform more complex data manipulations and analyses. This involves writing more sophisticated scripts in Google Apps Script and using them in your Sheets. Here’s how to proceed:\u003c/p\u003e\u003cul\u003e\u003cli\u003e\u003cstrong\u003eCreating Advanced Scripts\u003c/strong\u003e\u003c/li\u003e\u003cul\u003e\u003cli\u003eWrite functions in Google Apps Script to perform tasks like aggregating data, filtering based on certain criteria, or converting currency values.\u003c/li\u003e\u003cli\u003eFor example, you might write a function to calculate the average price of a selection of cryptocurrencies over a given period.\u003c/li\u003e\u003cli\u003eThese scripts can utilize loops, conditionals, and other JavaScript functionalities to process the data from CoinMarketCap.\u003c/li\u003e\u003c/ul\u003e\u003cli\u003e\u003cstrong\u003eUsing Custom Functions in Sheets\u003c/strong\u003e\u003c/li\u003e\u003cul\u003e\u003cli\u003eSimilar to built-in functions in Google Sheets, your custom functions can be called directly in the cells.\u003c/li\u003e\u003cli\u003eFor instance, if you have written a function named getAveragePrice, you can use it in a cell by typing =getAveragePrice(“Bitcoin”, “30days”).\u003c/li\u003e\u003cli\u003eThis approach allows for dynamic and interactive data analysis directly within Google Sheets.\u003c/li\u003e\u003c/ul\u003e\u003cli\u003e\u003cstrong\u003eVisualizing Data\u003c/strong\u003e\u003c/li\u003e\u003cul\u003e\u003cli\u003eGoogle Sheets offers various ways to visualize your data, like charts and graphs.\u003c/li\u003e\u003cli\u003eUtilize these tools to create dynamic visualizations that update automatically as your CoinMarketCap data changes.\u003c/li\u003e\u003cli\u003eThis can be particularly useful for tracking market trends or comparing the performance of different cryptocurrencies.\u003c/li\u003e\u003c/ul\u003e\u003c/ul\u003e\u003ch2 id=\"header-6\"\u003e\u003cstrong\u003eReal-World Applications and Use Cases\u003c/strong\u003e\u003c/h2\u003e\u003cp\u003eIntegrating the CoinMarketCap API with Google Sheets has numerous practical applications. Here are some examples to illustrate its potential:\u003c/p\u003e\u003cul\u003e\u003cli\u003e\u003cstrong\u003ePortfolio Tracking\u003c/strong\u003e\u003c/li\u003e\u003cul\u003e\u003cli\u003eCreate a spreadsheet that tracks the value of your cryptocurrency portfolio in real-time.\u003c/li\u003e\u003cli\u003eAutomatically update your holdings\u0026#x27; values based on the current market prices.\u003c/li\u003e\u003c/ul\u003e\u003cli\u003e\u003cstrong\u003eMarket Analysis\u003c/strong\u003e\u003c/li\u003e\u003cul\u003e\u003cli\u003eAnalyze market trends by fetching historical data and visualizing it in Google Sheets.\u003c/li\u003e\u003cli\u003eCompare the performance of various cryptocurrencies over different time frames.\u003c/li\u003e\u003c/ul\u003e\u003cli\u003e\u003cstrong\u003eAutomated Alerts\u003c/strong\u003e\u003c/li\u003e\u003cul\u003e\u003cli\u003eSet up scripts in Google Sheets to send email alerts based on specific market conditions, like a sudden increase or decrease in a cryptocurrency’s price.\u003c/li\u003e\u003c/ul\u003e\u003c/ul\u003e\u003ch2 id=\"header-7\"\u003e\u003cstrong\u003eTroubleshooting Common Issues\u003c/strong\u003e\u003c/h2\u003e\u003cp\u003eWhile integrating and using the CoinMarketCap API with Google Sheets, you might encounter several common issues. Here’s how to address them:\u003c/p\u003e\u003cul\u003e\u003cli\u003e\u003cstrong\u003eAPI Limit Exceeded\u003c/strong\u003e\u003c/li\u003e\u003cul\u003e\u003cli\u003eCoinMarketCap API has rate limits. If exceeded, you may receive errors.\u003c/li\u003e\u003cli\u003eOptimize your script to make fewer calls or upgrade your API plan if necessary.\u003c/li\u003e\u003c/ul\u003e\u003cli\u003e\u003cstrong\u003eData Parsing Errors\u003c/strong\u003e\u003c/li\u003e\u003cul\u003e\u003cli\u003eErrors may occur if the format of the data returned by the API changes.\u003c/li\u003e\u003cli\u003eRegularly check and update your script to accommodate any changes in the API response structure.\u003c/li\u003e\u003c/ul\u003e\u003cli\u003e\u003cstrong\u003eScript Execution Errors\u003c/strong\u003e\u003c/li\u003e\u003cul\u003e\u003cli\u003eDebugging tools in Google Apps Script can help identify and fix issues in your code.\u003c/li\u003e\u003cli\u003eEnsure that you handle exceptions and errors gracefully in your script.\u003c/li\u003e\u003c/ul\u003e\u003c/ul\u003e\u003ch2 id=\"header-8\"\u003e\u003cstrong\u003eBest Practices for API Integration\u003c/strong\u003e\u003c/h2\u003e\u003cp\u003eEnsuring a smooth and efficient integration involves adhering to certain best practices. Here are key considerations to keep in mind while working with the CoinMarketCap API and Google Sheets:\u003c/p\u003e\u003cul\u003e\u003cli\u003e\u003cstrong\u003eData Accuracy and Integrity\u003c/strong\u003e\u003c/li\u003e\u003cul\u003e\u003cli\u003eRegularly verify the accuracy of the data fetched from the API.\u003c/li\u003e\u003cli\u003eImplement checks within your scripts to detect and handle any anomalies or discrepancies in the data.\u003c/li\u003e\u003c/ul\u003e\u003cli\u003e\u003cstrong\u003eManaging API Call Limits\u003c/strong\u003e\u003c/li\u003e\u003cul\u003e\u003cli\u003eBe mindful of the rate limits imposed by the CoinMarketCap API.\u003c/li\u003e\u003cli\u003eEfficiently structure your API calls to maximize data retrieval while staying within these limits.\u003c/li\u003e\u003c/ul\u003e\u003cli\u003e\u003cstrong\u003eSecuring API Keys\u003c/strong\u003e\u003c/li\u003e\u003cul\u003e\u003cli\u003eKeep your API key secure and avoid exposing it in shared documents or public repositories.\u003c/li\u003e\u003cli\u003eUse Google Apps Script\u0026#x27;s properties service to store and access API keys securely.\u003c/li\u003e\u003c/ul\u003e\u003cli\u003e\u003cstrong\u003eOptimizing Performance\u003c/strong\u003e\u003c/li\u003e\u003cul\u003e\u003cli\u003eFor large datasets, optimize your scripts to reduce loading times and improve responsiveness.\u003c/li\u003e\u003cli\u003eUse caching where appropriate to store and reuse data, reducing the need for frequent API calls.\u003c/li\u003e\u003c/ul\u003e\u003c/ul\u003e\u003ch2 id=\"header-9\"\u003e\u003cstrong\u003eConclusion\u003c/strong\u003e\u003c/h2\u003e\u003cp\u003eWe’ve explored how to integrate the CoinMarketCap API with Google Sheets, from basic setup to advanced functionalities. This powerful combination opens up a world of possibilities for cryptocurrency enthusiasts, traders, and analysts. By leveraging the real-time data and extensive features of the CoinMarketCap API, you can gain deeper insights into the crypto market and make more informed decisions.\u003c/p\u003e\u003cp\u003eWe encourage you to try this integration and explore the various ways it can be customized to suit your needs. Whether you’re tracking your portfolio, analyzing market trends, or setting up automated alerts, the flexibility and power of this integration are bound to enhance your cryptocurrency journey.\u003c/p\u003e\u003cp\u003eGet your free API key here: \u003ca href=\"https://pro.coinmarketcap.com/signup\" target=\"_blank\"\u003ehttps://pro.coinmarketcap.com/signup\u003c/a\u003e\u003cbr/\u003eGot questions? Email us at \u003ca href=\"mailto:api@coinmarketcap.com\" target=\"_blank\"\u003eapi@coinmarketcap.com\u003c/a\u003e\u003c/p\u003e","language":"en","created_at":"2023-11-27T15:28:43.735Z","updated_at":"2023-11-27T16:05:59.760Z","reading_time":403250,"likes":18,"shares":105,"srd":false,"related":[{"id":"66f4289368d8e21e0c2d3292","title":"How to Claim Season 1 Hamster Kombat (HMSTR) Airdrop Tokens","slug":"how-to-claim-season-1-hamster-kombat-hmstr-airdrop-tokens","meta":"A simple guide to claiming HMSTR tokens in Season 1.","image":{"original":"uploads/1ac53b29d2f54278b54eadc5aa8c0893.png","optimized":"optimized-uploads/1ac53b29d2f54278b54eadc5aa8c0893.png","thumbnail":"thumbnail-uploads/1ac53b29d2f54278b54eadc5aa8c0893.png"},"language":"en","created_at":"2024-09-25T15:13:22.612Z","updated_at":"2024-10-25T02:55:05.835Z","reading_time":115000,"categories":[{"id":"670fdc6be30f155be0406fd2","title":"Tap To Earn","description":"Read the latest Tap to Earn articles","language":"en","slug":"tap-to-earn","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/83b7decc47c5442689f3bcc414dc6106.png"},{"id":"63637417847d336a2db377f7","title":"How-to Guides","description":"Dealing with cryptocurrency isn’t always easy. CMC provides in-depth guides into everything from how to create a crypto address to the best way to keep your crypto safe.","language":"en","slug":"how-to-guides","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/b2645949dd5e444f91bdda7fb2f513fd.png"}],"author":{"name":"Decentralized Dog","bio_summary":"I'm just your average dog... Only decentralized; also... I'm not your average dog.","slug":"decentralized-dog","image":{"original":"uploads/41ff5d319e9149399f911359bbb574ed.jpg","optimized":"optimized-uploads/41ff5d319e9149399f911359bbb574ed.jpg","thumbnail":"thumbnail-uploads/41ff5d319e9149399f911359bbb574ed.jpg"}}},{"id":"658440f2d7577457e8cfe862","title":"Democratising DEX data with CoinMarketCap’s New API Service","slug":"democratising-dex-data-with-coinmarketcaps-new-api-service","meta":"Introducing a state-of-the-art DEX API service, scheduled for launch in Q1 2024.","image":{"original":"uploads/37af9d7792df4b12be5663a41be39676.png","optimized":"optimized-uploads/37af9d7792df4b12be5663a41be39676.png","thumbnail":"thumbnail-uploads/37af9d7792df4b12be5663a41be39676.png"},"language":"en","created_at":"2023-12-21T14:06:01.747Z","updated_at":"2024-07-30T09:04:03.708Z","reading_time":260500,"categories":[{"id":"63637417847d336a2db377f7","title":"How-to Guides","description":"Dealing with cryptocurrency isn’t always easy. CMC provides in-depth guides into everything from how to create a crypto address to the best way to keep your crypto safe.","language":"en","slug":"how-to-guides","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/b2645949dd5e444f91bdda7fb2f513fd.png"}],"author":{"name":"CoinMarketCap","bio_summary":"I'm CoinMarketCap — you've probably heard of me.","slug":"coinmarketcap","image":{"original":"uploads/f261437425d54805adb1ff0313b8ce67.jpeg","optimized":"optimized-uploads/f261437425d54805adb1ff0313b8ce67.jpeg","thumbnail":"thumbnail-uploads/f261437425d54805adb1ff0313b8ce67.jpeg"}}},{"id":"6569bf535ebe0f77258e0e12","title":"Bybit Launches Personality-Based Trading Competition for 5th Anniversary With $1M Prize Pool: How To Take Part?","slug":"bybit-launches-personality-based-trading-competition-for-5th-anniversary","meta":"Bybit marks its fifth year since launching with a series of exciting events for traders and users, including NFT collections and a team-based trading competition.","image":{"original":"uploads/96ef096969a24297bf5dbf86ced26097.jpg","optimized":"optimized-uploads/96ef096969a24297bf5dbf86ced26097.jpg","thumbnail":"thumbnail-uploads/96ef096969a24297bf5dbf86ced26097.jpg"},"language":"en","created_at":"2023-12-01T11:12:45.051Z","updated_at":"2023-12-01T11:12:45.559Z","reading_time":184000,"categories":[{"id":"63637417847d336a2db377f7","title":"How-to Guides","description":"Dealing with cryptocurrency isn’t always easy. CMC provides in-depth guides into everything from how to create a crypto address to the best way to keep your crypto safe.","language":"en","slug":"how-to-guides","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/b2645949dd5e444f91bdda7fb2f513fd.png"}],"author":{"name":"Decentralized Dog","bio_summary":"I'm just your average dog... Only decentralized; also... I'm not your average dog.","slug":"decentralized-dog","image":{"original":"uploads/41ff5d319e9149399f911359bbb574ed.jpg","optimized":"optimized-uploads/41ff5d319e9149399f911359bbb574ed.jpg","thumbnail":"thumbnail-uploads/41ff5d319e9149399f911359bbb574ed.jpg"}}}],"available_languages":["en"],"difficulty":{"level":1,"label":"Easy","slug":"beginner","language":"en"},"categories":[{"id":"63637417847d336a2db377f7","title":"How-to Guides","description":"Dealing with cryptocurrency isn’t always easy. CMC provides in-depth guides into everything from how to create a crypto address to the best way to keep your crypto safe.","language":"en","slug":"how-to-guides","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/b2645949dd5e444f91bdda7fb2f513fd.png"}],"author":{"name":"CoinMarketCap","bio_summary":"I'm CoinMarketCap — you've probably heard of me.","slug":"coinmarketcap","image":{"original":"uploads/f261437425d54805adb1ff0313b8ce67.jpeg","optimized":"optimized-uploads/f261437425d54805adb1ff0313b8ce67.jpeg","thumbnail":"thumbnail-uploads/f261437425d54805adb1ff0313b8ce67.jpeg"}},"assets":[]},"tableOfContent":[{"label":"\u003cstrong\u003eIntroduction\u003c/strong\u003e","slug":"header-0"},{"label":"\u003cstrong\u003eUnderstanding the CoinMarketCap API\u003c/strong\u003e","slug":"header-1"},{"label":"Key Features of the CoinMarketCap API","slug":"key-features-of-the-coinmarketcap-api"},{"label":"\u003cstrong\u003eWhy is it important in the crypto market context?\u003c/strong\u003e","slug":"strong-why-is-it-important-in-the-crypto-market-context-strong"},{"label":"\u003cstrong\u003ePrerequisites for Integration\u003c/strong\u003e","slug":"header-2"},{"label":"\u003cstrong\u003eStep-by-Step Integration Guide\u003c/strong\u003e","slug":"header-3"},{"label":"\u003cstrong\u003ePulling the Latest Bitcoin (BTC) Price\u003c/strong\u003e","slug":"header-4"},{"label":"\u003cstrong\u003eAdvanced Usage and Custom Functions\u003c/strong\u003e","slug":"header-5"},{"label":"\u003cstrong\u003eReal-World Applications and Use Cases\u003c/strong\u003e","slug":"header-6"},{"label":"\u003cstrong\u003eTroubleshooting Common Issues\u003c/strong\u003e","slug":"header-7"},{"label":"\u003cstrong\u003eBest Practices for API Integration\u003c/strong\u003e","slug":"header-8"},{"label":"\u003cstrong\u003eConclusion\u003c/strong\u003e","slug":"header-9"}],"chartbeatProps":{"authors":"CoinMarketCap","sections":"How-to Guides"}},"locale":"en","i18n":{"2020 has been an eventful year, from the Bitcoin halving to the “DeFi Summer Wave” to surges in Bitcoin’s price due to the large influx of “traditional\" institutional investors. Who are the most influential people in crypto in 2020? Which are the most innovative, impactful \u0026 interesting projects in 2020?":"2020 has been an eventful year, from the Bitcoin halving to the “DeFi Summer Wave” to surges in Bitcoin’s price due to the large influx of “traditional\" institutional investors. Who are the most influential people in crypto in 2020? Which are the most innovative, impactful \u0026 interesting projects in 2020?","Loading...":"Loading...","Copied!\"));":"Copied!\"));","Find what fascinates you as you explore crypto":"Find what fascinates you as you explore crypto","Learn":"Learn","Learn all there is to know about blockchain, cryptocurrency, trading, and more. Get started by exploring all the content on CoinMarketCap Alexandria.":"Learn all there is to know about blockchain, cryptocurrency, trading, and more. Get started by exploring all the content on CoinMarketCap Alexandria.","Explore our content":"Explore our content","Find out the meaning of cryptocurrency and blockchain's hidden language with the CoinMarketCap glossary of terms.":"Find out the meaning of cryptocurrency and blockchain's hidden language with the CoinMarketCap glossary of terms.","Crypto Glossary | CoinMarketCap":"Crypto Glossary | CoinMarketCap","Who is {{name}}?":"Who is {{name}}?","CoinMarketCap Alexandria will house online both content about crypto written by our own researchers and employees, as well as articles by some of the best minds in the crypto space today.‍":"CoinMarketCap Alexandria will house online both content about crypto written by our own researchers and employees, as well as articles by some of the best minds in the crypto space today.‍","About CoinMarketCap Alexandria":"About CoinMarketCap Alexandria","Crypto \u0026 Blockchain Education":"Crypto \u0026 Blockchain Education","Most Influential People \u0026 Projects in 2020":"Most Influential People \u0026 Projects in 2020","Read our profiles of the leading crypto influencers, entrepreneurs, technologists, movers and shakers, in 2020.":"Read our profiles of the leading crypto influencers, entrepreneurs, technologists, movers and shakers, in 2020.","The Leading Crypto Influencers In 2020 | CoinMarketCap":"The Leading Crypto Influencers In 2020 | CoinMarketCap","Next":"Next","writer":"writer","Authors":"Authors","Read our profiles of the leading blockchain and crypto {{name}} in 2020.":"Read our profiles of the leading blockchain and crypto {{name}} in 2020.","The leading Crypto {{name}} in 2020 | CoinMarketCap":"The leading Crypto {{name}} in 2020 | CoinMarketCap","All Categories":"All Categories","Crypto Glossary":"Crypto Glossary","Latest articles by {{author}}":"Latest articles by {{author}}","Biography":"Biography","Everything you’ve ever wanted to know about crypto and more, brought to you by the number one crypto data aggregator, CoinMarketCap.":"Everything you’ve ever wanted to know about crypto and more, brought to you by the number one crypto data aggregator, CoinMarketCap.","Learn About Cryptocurrency.":"Learn About Cryptocurrency.","Alexandria’s authors range from CoinMarketCap employees and researchers to some of the best minds and projects in the crypto space.":"Alexandria’s authors range from CoinMarketCap employees and researchers to some of the best minds and projects in the crypto space.","Meet our Authors":"Meet our Authors","Subscribe":"Subscribe","Enter your email address":"Enter your email address","Join our free newsletter for daily crypto updates!":"Join our free newsletter for daily crypto updates!","Join the thousands already learning crypto!":"Join the thousands already learning crypto!","Latest Articles":"Latest Articles","See All":"See All","See all articles":"See all articles","Related Articles":"Related Articles","By {{author}}":"By {{author}}","{{time}}m":"{{time}}m","Home":"Home","Articles":"Articles","Looking to get started with cryptocurrency? Buy Bitcoin on Binance!":"Looking to get started with cryptocurrency? Buy Bitcoin on Binance!","Buy Bitcoin":"Buy Bitcoin","Was this article useful?":"Was this article useful?","{{count}} out of {{count}} people found this article useful.":"{{count}} out of {{count}} people found this article useful.","Yes":"Yes","No":"No","No noise. Just signal.":"No noise. Just signal.","Sign up for our weekly newsletter. We promise we don't spam!":"Sign up for our weekly newsletter. We promise we don't spam!","Your email":"Your email","Sign up":"Sign up","Explore all of our content":"Explore all of our content","Related topics":"Related topics","Share":"Share","Table of Contents":"Table of Contents","Topics at Academy":"Topics at Academy","Search topics to add...":"Search topics to add...","Reading time":"Reading time","{{count}}m":"{{count}}m","Layout":"Layout","Sort by Latest":"Sort by Latest","Sort by Difficulty":"Sort by Difficulty","Latest":"Latest","Read more":"Read more","See all results for your search":"See all results for your search","{{count}} results for '{{term}}'":"{{count}} results for '{{term}}'","Topics":"Topics","Difficulty":"Difficulty","Type":"Type","Glossary entries":"Glossary entries","Courses":"Courses","Hide filters":"Hide filters","Show filters":"Show filters","Refresh results":"Refresh results","Clear all filters":"Clear all filters","Show off your crypto knowledge":"Show off your crypto knowledge","Try out Academy Quizzes":"Try out Academy Quizzes","Phishing quiz":"Phishing quiz","Glossary quiz":"Glossary quiz","Bitcoin history quiz":"Bitcoin history quiz","We're working on getting more quizzes ready.":"We're working on getting more quizzes ready.","While you're waiting, why not check out our latest content?":"While you're waiting, why not check out our latest content?","Cryptocurrencies have brought lots of exciting possibilities, but they are full of risks and dangers for the inexperienced.":"Cryptocurrencies have brought lots of exciting possibilities, but they are full of risks and dangers for the inexperienced.","How well do you know the origins of Bitcoin and its journey since inception? Take the Binance Academy Bitcoin History quiz to find out how much you know!":"How well do you know the origins of Bitcoin and its journey since inception? Take the Binance Academy Bitcoin History quiz to find out how much you know!","Think you know crypto? Take our crypto glossary quiz.":"Think you know crypto? Take our crypto glossary quiz.","Take the quiz":"Take the quiz","This quiz has {{count}} questions.":"This quiz has {{count}} questions.","I am a complete beginner and just started exploring Binance Academy. Let me test my basic knowledge":"I am a complete beginner and just started exploring Binance Academy. Let me test my basic knowledge","I am a frequent visitor of Binance Academy and am quite familiar with some terms, but still on my path to true knowledge.":"I am a frequent visitor of Binance Academy and am quite familiar with some terms, but still on my path to true knowledge.","I have learned enough at Binance Academy. My knowledge base is wide and I feel ready to be challenged.":"I have learned enough at Binance Academy. My knowledge base is wide and I feel ready to be challenged.","Select a suitable level of difficulty.":"Select a suitable level of difficulty.","Q{{count}}/{{count}}":"Q{{count}}/{{count}}","Phishing":"Phishing","Legitimate":"Legitimate","Quizzes":"Quizzes","Quiz difficulty selection":"Quiz difficulty selection","LEARN ALL ABOUT":"LEARN ALL ABOUT","Blockchain \u0026 Crypto":"Blockchain \u0026 Crypto","Your one-stop guide to all things crypto. Whether you're a rookie trying to understand mining or a veteran looking to develop a trading strategy, we've got you covered.":"Your one-stop guide to all things crypto. Whether you're a rookie trying to understand mining or a veteran looking to develop a trading strategy, we've got you covered.","Featured":"Featured","Beginner":"Beginner","Intermediate":"Intermediate","Advanced":"Advanced","{{count}} minutes":"{{count}} minutes","{{count}} minutes ago":"{{count}} minutes ago","{{count}} hours ago":"{{count}} hours ago","{{count}} days ago":"{{count}} days ago","Latest releases":"Latest releases","SEE ALL LATEST RELEASES":"SEE ALL LATEST RELEASES","Full definition":"Full definition","Glossary addition":"Glossary addition","Explore all the latest content":"Explore all the latest content","Lost in all the crypto slang?":"Lost in all the crypto slang?","Take a closer look at our blockchain \u0026 crypto glossary.":"Take a closer look at our blockchain \u0026 crypto glossary.","Check out Glossary":"Check out Glossary","Up for an adventure?":"Up for an adventure?","Learn while you test your knowledge with a range of quizzes.":"Learn while you test your knowledge with a range of quizzes.","Take a crypto quiz":"Take a crypto quiz","Trading":"Trading","SEE ALL TRADING CONTENT":"SEE ALL TRADING CONTENT","See more content about this topic":"See more content about this topic","No idea what you just scrolled through?":"No idea what you just scrolled through?","Not to worry. Our no-nonsense beginner's guide will get you up to speed.":"Not to worry. Our no-nonsense beginner's guide will get you up to speed.","Get started here":"Get started here","Essentials":"Essentials","SEE ALL ESSENTIALS CONTENT":"SEE ALL ESSENTIALS CONTENT","Blockchain":"Blockchain","SEE ALL BLOCKCHAIN CONTENT":"SEE ALL BLOCKCHAIN CONTENT","Keep an eye on Bitcoin":"Keep an eye on Bitcoin","Every four years, the Bitcoin rewards are slashed in half. Find out why on the Halving page.":"Every four years, the Bitcoin rewards are slashed in half. Find out why on the Halving page.","Bitcoin halving page":"Bitcoin halving page","Got questions?":"Got questions?","We totally understand. That's why we've built a platform to answer them.":"We totally understand. That's why we've built a platform to answer them.","Go to Ask Academy":"Go to Ask Academy","Guides":"Guides","SEE ALL GUIDES":"SEE ALL GUIDES","Weekly pick":"Weekly pick","{{count}}":"{{count}}","That's the number of terms in our glossary. How many do you know?":"That's the number of terms in our glossary. How many do you know?","Search glossary":"Search glossary","Get the latest in crypto dropped to your email, every week.":"Get the latest in crypto dropped to your email, every week.","Glossary":"Glossary","The Words of Crypto":"The Words of Crypto","Time to understand the language":"Time to understand the language","Search terms here...":"Search terms here...","Can't find what you're looking for?":"Can't find what you're looking for?","Whoops. Our bad. Please help us make our glossary better by submitting new terms.":"Whoops. Our bad. Please help us make our glossary better by submitting new terms.","Submit terms":"Submit terms","Community submission":"Community submission","Author:":"Author:","Start here":"Start here","Discover":"Discover","Log In":"Log In","Register":"Register","Search":"Search","Ask Academy":"Ask Academy","Blockchain forum and Q\u0026A":"Blockchain forum and Q\u0026A","Crypto-terms glossary":"Crypto-terms glossary","Test your knowledge":"Test your knowledge","Have a product idea or feedback?":"Have a product idea or feedback?","Contribute":"Contribute","New to Crypto?":"New to Crypto?","See our beginner content.":"See our beginner content.","Products":"Products","Exchange":"Exchange","Access":"Access","Academy":"Academy","BCF":"BCF","Card":"Card","Labs":"Labs","Launchpad":"Launchpad","Research":"Research","Trust Wallet":"Trust Wallet","Company":"Company","Terms \u0026 Conditions":"Terms \u0026 Conditions","Privacy Policy":"Privacy Policy","Disclaimer":"Disclaimer","Content Request":"Content Request","Submission Guide":"Submission Guide","Feedback":"Feedback","Bitcoin Halving Countdown":"Bitcoin Halving Countdown","Bitcoin Halving Timer":"Bitcoin Halving Timer","Days":"Days","Hours":"Hours","Minutes":"Minutes","Seconds":"Seconds","Current block height":"Current block height","Blocks until halving":"Blocks until halving","BTC Price":"BTC Price","Buy Bitcoin on Binance":"Buy Bitcoin on Binance","Detailed datasheet":"Detailed datasheet","Total BTC in circulation":"Total BTC in circulation","Total BTC to ever be produced":"Total BTC to ever be produced","Percentage of BTC mined":"Percentage of BTC mined","BTC left to mine until halving":"BTC left to mine until halving","BTC market cap (USD)":"BTC market cap (USD)","BTC generated each day":"BTC generated each day","BTC annual inflation rate":"BTC annual inflation rate","BTC daily inflation":"BTC daily inflation","Approximate block time":"Approximate block time","Mining difficulty":"Mining difficulty","Hash rate":"Hash rate","Community":"Community","{{count}}h ago":"{{count}}h ago","{{count}}d ago":"{{count}}d ago","{{count}}w ago":"{{count}}w ago","Crypto \u0026 Blockchain Education | Blockchain Course":"Crypto \u0026 Blockchain Education | Blockchain Course","Blockchain and crypto asset exchange":"Blockchain and crypto asset exchange","Blockchain and crypto education":"Blockchain and crypto education","Blockchain charity foundation":"Blockchain charity foundation","Cryptocurrency Information":"Cryptocurrency Information","Incubator for top blockchain projects":"Incubator for top blockchain projects","Institutional-grade analysis and reports":"Institutional-grade analysis and reports","Binance's official crypto wallet":"Binance's official crypto wallet","Token Launch Platform":"Token Launch Platform","Binance Academy's Blockchain and Crypto Glossary is the authoritative source for terminology and definitions of the blockchain and cryptocurrency world":"Binance Academy's Blockchain and Crypto Glossary is the authoritative source for terminology and definitions of the blockchain and cryptocurrency world","Learn about blockchain, cryptocurrency, security, technology and more with entirely free videos, articles, and online courses all on Binance Academy.":"Learn about blockchain, cryptocurrency, security, technology and more with entirely free videos, articles, and online courses all on Binance Academy.","Interested in learning about blockchain, cryptocurrency, security, technology, or following along with tutorials? Binance Academy has all that and more!":"Interested in learning about blockchain, cryptocurrency, security, technology, or following along with tutorials? Binance Academy has all that and more!","Binance Academy playlists provide content from beginner to advanced, you can follow along curated list of articles designed to make it easy to understand":"Binance Academy playlists provide content from beginner to advanced, you can follow along curated list of articles designed to make it easy to understand","The bitcoin block reward halving occurs once every 4 years on average, learn the significance of the bitcoin halving and when the next one will occur.":"The bitcoin block reward halving occurs once every 4 years on average, learn the significance of the bitcoin halving and when the next one will occur.","Want to test yourself? Check out Binance Academy Quizzes and test how much you have learned about Blockchain, Cryptocurrency, Security, and Economics.":"Want to test yourself? Check out Binance Academy Quizzes and test how much you have learned about Blockchain, Cryptocurrency, Security, and Economics.","Looks like you don't have an internet connection.":"Looks like you don't have an internet connection.","Binance Academy is currently under maintenance.":"Binance Academy is currently under maintenance.","We'll be right back!":"We'll be right back!","In the meantime, take a look at some of our videos.":"In the meantime, take a look at some of our videos.","Search results for":"Search results for","No results found.":"No results found.","Ask a new question":"Ask a new question","asked by":"asked by","Latest questions":"Latest questions","Trending":"Trending","New":"New","Solved":"Solved","All":"All","Open":"Open","Find existing answers":"Find existing answers","Title must be 10 or more characters":"Title must be 10 or more characters","You will not be able to edit your title after posting":"You will not be able to edit your title after posting","Title...":"Title...","Enter your question here":"Enter your question here","Post question":"Post question","Answers":"Answers","Enter your answer or comment here...":"Enter your answer or comment here...","academy_trending_articles":"Trending Articles","academy_whats_new_with_coinmarketcap":"What's New At CoinMarketCap?","academy_glossary_terms":"Glossary Terms","academy_our_mission":"Our Mission","academy_our_mission_description":"The core mission of CoinMarketCap Academy is to be the definitive source of cryptocurrency insights, research, and educational content.⏎⏎With our team of researchers and experts, we produce and curate high-quality content to educate and give our readers an edge in the ever-evolving cryptocurrency space.⏎⏎Whether you're new to the world of cryptocurrency or a seasoned veteran, CMC Academy aims to be your go-to resource for all things crypto.","academy_subscribe":"Subscribe","academy_all":"All","academy_glossary_terms_description":"We currently have {{number}} terms. How many do you know so far?","academy_glossary_cta":"Check Glossary","academy_navbar_learn":"Learn","academy_navbar_topics":"Topics","academy_navbar_coinmarketcap_new":"CoinMarketCap News"},"statusCode":null,"initialTheme":0,"supportedLanguages":["en","ru","id","de","vi","tr","pt","es","uk","th"],"categories":[{"id":"67a09632ebfe4424bdcf5679","slug":"airdrop-guide","created_at":"2025-02-03T10:10:58.000Z","updated_at":"2025-02-03T10:27:17.263Z","translations":[{"title":"Airdrop Guide","description":"Read the latest Airdrop Guide articles","language":"en","created_at":"2025-02-03T10:10:58.000Z","updated_at":"2025-02-03T10:27:17.262Z"}]},{"id":"679111f3bf71e02463964612","slug":"alpha-radar","created_at":"2025-01-22T15:42:43.766Z","updated_at":"2025-01-22T15:43:03.743Z","parent_slug":"learn","translations":[{"title":"Alpha Radar","description":"Read the latest Alpha Radar articles","language":"en","created_at":"2025-01-22T15:42:43.766Z","updated_at":"2025-01-22T15:43:03.743Z"},{"title":"Alpha Radar","language":"vi","created_at":"2025-01-22T15:43:03.743Z"},{"title":"Alpha Radar","language":"ru","created_at":"2025-01-22T15:43:03.743Z"},{"title":"Alpha Radar","language":"id","created_at":"2025-01-22T15:43:03.743Z"},{"title":"Alpha Radar","language":"pt","created_at":"2025-01-22T15:43:03.743Z"},{"title":"Alpha Radar","language":"es","created_at":"2025-01-22T15:43:03.743Z"},{"title":"Alpha Radar","language":"de","created_at":"2025-01-22T15:43:03.743Z"},{"title":"Alpha Radar","language":"th","created_at":"2025-01-22T15:43:03.743Z"},{"title":"Alpha Radar","language":"zh","created_at":"2025-01-22T15:43:03.743Z"},{"title":"Alpha Radar","language":"tr","created_at":"2025-01-22T15:43:03.743Z"},{"title":"Alpha Radar","language":"uk","created_at":"2025-01-22T15:43:03.743Z"}]},{"id":"63637417847d336a2db3780a","slug":"altcoins","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/fce0b02d449245cba857377f7f28c5f5.png","created_at":"2021-11-04T07:49:36.000Z","updated_at":"2022-12-07T16:20:43.548Z","parent_slug":"topics","translations":[{"title":"Altcoins","language":"de","created_at":"2022-03-02T08:13:57.000Z","updated_at":"2022-12-07T16:20:43.547Z"},{"title":"Altcoins","language":"es","created_at":"2022-03-02T08:13:57.000Z","updated_at":"2022-12-07T16:20:43.547Z"},{"title":"Altcoins","language":"id","created_at":"2022-03-02T08:13:57.000Z","updated_at":"2022-12-07T16:20:43.547Z"},{"title":"Altcoins","language":"pt","created_at":"2022-03-02T08:13:57.000Z","updated_at":"2022-12-07T16:20:43.547Z"},{"title":"Altcoins","language":"ru","created_at":"2022-03-02T08:13:57.000Z","updated_at":"2022-12-07T16:20:43.547Z"},{"title":"Altcoins","language":"th","created_at":"2022-04-14T10:49:56.000Z","updated_at":"2022-12-07T16:20:43.547Z"},{"title":"Altcoins","language":"tr","created_at":"2022-03-02T08:13:57.000Z","updated_at":"2022-12-07T16:20:43.547Z"},{"title":"Altcoins","language":"uk","created_at":"2022-04-11T14:35:26.000Z","updated_at":"2022-12-07T16:20:43.547Z"},{"title":"Altcoins","language":"vi","created_at":"2022-03-02T08:13:57.000Z","updated_at":"2022-12-07T16:20:43.547Z"},{"title":"Altcoins","description":"Get the low-down on the latest altcoin news, project deep dives and all other cryptocurrencies besides Bitcoin.","language":"en","created_at":"2021-11-04T07:49:36.000Z","updated_at":"2022-12-07T16:20:43.547Z"}]},{"id":"63637417847d336a2db377ff","slug":"announcements","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/bf0e708e80084fd5877419bd1e5eea37.png","created_at":"2021-11-03T08:24:02.000Z","updated_at":"2022-12-07T16:31:29.269Z","parent_slug":"coinmarketcap-news","translations":[{"title":"Announcements","language":"de","created_at":"2022-03-02T08:11:56.000Z","updated_at":"2022-12-07T16:31:29.269Z"},{"title":"Announcements","language":"es","created_at":"2022-03-02T08:11:56.000Z","updated_at":"2022-12-07T16:31:29.269Z"},{"title":"Announcements","language":"id","created_at":"2022-03-02T08:11:56.000Z","updated_at":"2022-12-07T16:31:29.269Z"},{"title":"Announcements","language":"pt","created_at":"2022-03-02T08:11:56.000Z","updated_at":"2022-12-07T16:31:29.269Z"},{"title":"Announcements","language":"ru","created_at":"2022-03-02T08:11:56.000Z","updated_at":"2022-12-07T16:31:29.269Z"},{"title":"Announcements","language":"th","created_at":"2022-04-14T10:50:15.000Z","updated_at":"2022-12-07T16:31:29.269Z"},{"title":"Announcements","language":"tr","created_at":"2022-03-02T08:11:56.000Z","updated_at":"2022-12-07T16:31:29.269Z"},{"title":"Announcements","language":"uk","created_at":"2022-04-11T14:35:47.000Z","updated_at":"2022-12-07T16:31:29.269Z"},{"title":"Announcements","language":"vi","created_at":"2022-03-02T08:11:56.000Z","updated_at":"2022-12-07T16:31:29.269Z"},{"title":"Announcements","description":"Don't miss important CoinMarketCap updates here!","language":"en","created_at":"2021-11-03T08:24:02.000Z","updated_at":"2022-12-07T16:31:29.269Z"}]},{"id":"63637417847d336a2db37818","slug":"announcements-g","created_at":"2021-12-22T09:07:29.000Z","updated_at":"2021-12-22T09:07:29.000Z","parent_slug":"gravity","translations":[{"title":"Announcements","language":"de","created_at":"2022-03-02T07:28:33.000Z","updated_at":"2022-04-14T10:49:48.000Z"},{"title":"Announcements","language":"en","created_at":"2021-12-22T09:07:29.000Z","updated_at":"2022-04-14T10:49:48.000Z"},{"title":"Announcements","language":"es","created_at":"2022-03-02T07:28:22.000Z","updated_at":"2022-04-14T10:49:48.000Z"},{"title":"Announcements","language":"id","created_at":"2022-02-22T08:57:33.000Z","updated_at":"2022-04-14T10:49:48.000Z"},{"title":"Announcements","language":"pt","created_at":"2022-03-02T07:28:24.000Z","updated_at":"2022-04-14T10:49:48.000Z"},{"title":"Announcements","language":"ru","created_at":"2022-02-22T08:54:38.000Z","updated_at":"2022-04-14T10:49:48.000Z"},{"title":"Announcements","language":"th","created_at":"2022-04-14T10:49:48.000Z","updated_at":"2022-04-14T10:49:48.000Z"},{"title":"Announcements","language":"tr","created_at":"2022-03-02T07:28:27.000Z","updated_at":"2022-04-14T10:49:48.000Z"},{"title":"Announcements","language":"uk","created_at":"2022-04-11T14:35:17.000Z","updated_at":"2022-04-14T10:49:48.000Z"},{"title":"Announcements","language":"vi","created_at":"2022-03-02T07:28:30.000Z","updated_at":"2022-04-14T10:49:48.000Z"}]},{"id":"63637417847d336a2db37803","slug":"bitcoin","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/bbb3be20245542e4b0a443c327bc73c1.png","created_at":"2021-11-04T07:48:21.000Z","updated_at":"2022-12-07T16:28:06.623Z","parent_slug":"topics","translations":[{"title":"Bitcoin","language":"de","created_at":"2022-03-02T08:12:16.000Z","updated_at":"2022-12-07T16:28:06.623Z"},{"title":"Bitcoin","language":"es","created_at":"2022-03-02T08:12:16.000Z","updated_at":"2022-12-07T16:28:06.623Z"},{"title":"Bitcoin","language":"id","created_at":"2022-03-02T08:12:16.000Z","updated_at":"2022-12-07T16:28:06.623Z"},{"title":"Bitcoin","language":"pt","created_at":"2022-03-02T08:12:16.000Z","updated_at":"2022-12-07T16:28:06.623Z"},{"title":"Bitcoin","language":"ru","created_at":"2022-03-02T08:12:16.000Z","updated_at":"2022-12-07T16:28:06.623Z"},{"title":"Bitcoin","language":"th","created_at":"2022-04-14T10:50:09.000Z","updated_at":"2022-12-07T16:28:06.623Z"},{"title":"Bitcoin","language":"tr","created_at":"2022-03-02T08:12:16.000Z","updated_at":"2022-12-07T16:28:06.623Z"},{"title":"Bitcoin","language":"uk","created_at":"2022-04-11T14:35:39.000Z","updated_at":"2022-12-07T16:28:06.623Z"},{"title":"Bitcoin","language":"vi","created_at":"2022-03-02T08:12:16.000Z","updated_at":"2022-12-07T16:28:06.623Z"},{"title":"Bitcoin","description":"Find the latest news on Bitcoin, a decentralized, peer-to-peer digital currency founded by the pseudonymous Satoshi Nakamoto.","language":"en","created_at":"2021-11-04T07:48:21.000Z","updated_at":"2022-12-07T16:28:06.623Z"}]},{"id":"63637417847d336a2db37805","slug":"blockchain","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/55801fca4a9c4b609104a2eccb37aaf9.png","created_at":"2021-11-04T07:48:43.000Z","updated_at":"2022-12-07T16:41:00.035Z","parent_slug":"topics","translations":[{"title":"Blockchain","language":"de","created_at":"2022-03-02T08:12:23.000Z","updated_at":"2022-12-07T16:41:00.035Z"},{"title":"Blockchain","language":"es","created_at":"2022-03-02T08:12:23.000Z","updated_at":"2022-12-07T16:41:00.035Z"},{"title":"Blockchain","language":"id","created_at":"2022-03-02T08:12:23.000Z","updated_at":"2022-12-07T16:41:00.035Z"},{"title":"Blockchain","language":"pt","created_at":"2022-03-02T08:12:23.000Z","updated_at":"2022-12-07T16:41:00.035Z"},{"title":"Blockchain","language":"ru","created_at":"2022-03-02T08:12:23.000Z","updated_at":"2022-12-07T16:41:00.035Z"},{"title":"Blockchain","language":"th","created_at":"2022-04-14T10:50:05.000Z","updated_at":"2022-12-07T16:41:00.035Z"},{"title":"Blockchain","language":"tr","created_at":"2022-03-02T08:12:23.000Z","updated_at":"2022-12-07T16:41:00.035Z"},{"title":"Blockchain","language":"uk","created_at":"2022-04-11T14:35:35.000Z","updated_at":"2022-12-07T16:41:00.035Z"},{"title":"Blockchain","language":"vi","created_at":"2022-03-02T08:12:23.000Z","updated_at":"2022-12-07T16:41:00.035Z"},{"title":"Blockchain","description":"Blockchains are distributed, immutable ledgers of transactions across a peer-to-peer network — dive into our blockchain guides, whitepapers and more.","language":"en","created_at":"2021-11-04T07:48:43.000Z","updated_at":"2022-12-07T16:41:00.035Z"}]},{"id":"63637417847d336a2db377f8","slug":"blog","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/403189d0bc3d4b22a765422a4c9f27ea.png","created_at":"2021-08-03T16:34:12.000Z","updated_at":"2021-08-03T16:34:12.000Z","parent_slug":"learn","translations":[{"title":"Blog","language":"de","created_at":"2022-03-02T07:32:02.000Z","updated_at":"2022-04-14T10:50:31.000Z"},{"title":"Blog","description":"Product updates, partnerships, and announcements from CoinMarketCap and our contributors.","language":"en","created_at":"2021-08-03T16:34:12.000Z","updated_at":"2022-04-14T10:50:31.000Z"},{"title":"Blog","language":"es","created_at":"2022-03-02T07:31:52.000Z","updated_at":"2022-04-14T10:50:31.000Z"},{"title":"Blog","language":"id","created_at":"2021-09-23T14:40:15.000Z","updated_at":"2022-04-14T10:50:31.000Z"},{"title":"Blog","language":"pt","created_at":"2022-03-02T07:31:54.000Z","updated_at":"2022-04-14T10:50:31.000Z"},{"title":"Блог","description":"Апдейты по продуктам, партнерствам и анонсы от CoinMarketCap и наших контрибьютеров.","language":"ru","created_at":"2021-08-05T19:41:16.000Z","updated_at":"2022-04-14T10:50:31.000Z"},{"title":"Blog","language":"th","created_at":"2022-04-14T10:50:31.000Z","updated_at":"2022-04-14T10:50:31.000Z"},{"title":"Blog","language":"tr","created_at":"2022-03-02T07:31:57.000Z","updated_at":"2022-04-14T10:50:31.000Z"},{"title":"Blog","language":"uk","created_at":"2022-04-11T14:36:02.000Z","updated_at":"2022-04-14T10:50:31.000Z"},{"title":"Blog","language":"vi","created_at":"2022-03-02T07:32:00.000Z","updated_at":"2022-04-14T10:50:31.000Z"}]},{"id":"63637417847d336a2db3780f","slug":"blog-g","created_at":"2021-12-22T09:04:13.000Z","updated_at":"2021-12-22T09:04:13.000Z","parent_slug":"gravity","translations":[{"title":"Blog","language":"de","created_at":"2022-02-22T10:25:20.000Z","updated_at":"2022-02-22T10:25:20.000Z"},{"title":"Blog","language":"en","created_at":"2021-12-22T09:04:13.000Z","updated_at":"2022-02-22T10:25:20.000Z"}]},{"id":"63637417847d336a2db37819","slug":"cmc-research","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/8c3d6407404e49c0a53bc747c1d0cc34.png","created_at":"2022-06-15T17:18:48.000Z","updated_at":"2023-03-28T06:47:13.098Z","parent_slug":"learn","translations":[{"title":"CMC Research","language":"de","created_at":"2022-06-21T15:40:07.000Z","updated_at":"2023-03-28T06:47:13.097Z"},{"title":"CMC Research","language":"es","created_at":"2022-06-21T15:40:07.000Z","updated_at":"2023-03-28T06:47:13.097Z"},{"title":"CMC Research","language":"id","created_at":"2022-06-21T15:40:07.000Z","updated_at":"2023-03-28T06:47:13.097Z"},{"title":"CMC Research","language":"pt","created_at":"2022-06-21T15:40:07.000Z","updated_at":"2023-03-28T06:47:13.097Z"},{"title":"CMC Research","language":"ru","created_at":"2022-06-21T15:40:07.000Z","updated_at":"2023-03-28T06:47:13.097Z"},{"title":"CMC Research","language":"th","created_at":"2022-06-21T15:40:07.000Z","updated_at":"2023-03-28T06:47:13.097Z"},{"title":"CMC Research","language":"tr","created_at":"2022-06-21T15:40:07.000Z","updated_at":"2023-03-28T06:47:13.097Z"},{"title":"CMC Research","language":"uk","created_at":"2022-06-21T15:40:07.000Z","updated_at":"2023-03-28T06:47:13.097Z"},{"title":"CMC Research","language":"vi","created_at":"2022-06-21T15:40:07.000Z","updated_at":"2023-03-28T06:47:13.097Z"},{"title":"CMC Research","description":"Institutional-grade research on cryptocurrency and digital assets like Bitcoin, Ethereum, DeFi, GameFi and more.","language":"en","created_at":"2022-06-15T17:18:48.000Z","updated_at":"2023-03-28T06:47:13.097Z"}]},{"id":"63637417847d336a2db377fe","slug":"coinmarketcap-news","created_at":"2021-11-03T08:23:36.000Z","updated_at":"2024-07-15T07:50:01.737Z","translations":[{"title":"CoinMarketCap News","language":"de","created_at":"2022-03-02T08:10:51.000Z","updated_at":"2024-07-15T07:50:01.737Z"},{"title":"CoinMarketCap News","language":"es","created_at":"2022-03-02T08:10:51.000Z","updated_at":"2024-07-15T07:50:01.737Z"},{"title":"CoinMarketCap News","language":"id","created_at":"2022-03-02T08:10:51.000Z","updated_at":"2024-07-15T07:50:01.737Z"},{"title":"CoinMarketCap News","language":"pt","created_at":"2022-03-02T08:10:51.000Z","updated_at":"2024-07-15T07:50:01.737Z"},{"title":"CoinMarketCap News","language":"ru","created_at":"2022-03-02T08:10:51.000Z","updated_at":"2024-07-15T07:50:01.737Z"},{"title":"CoinMarketCap News","language":"th","created_at":"2022-04-14T10:50:17.000Z","updated_at":"2024-07-15T07:50:01.737Z"},{"title":"CoinMarketCap News","language":"tr","created_at":"2022-03-02T08:10:51.000Z","updated_at":"2024-07-15T07:50:01.737Z"},{"title":"CoinMarketCap News","language":"uk","created_at":"2022-04-11T14:35:50.000Z","updated_at":"2024-07-15T07:50:01.737Z"},{"title":"CoinMarketCap News","language":"vi","created_at":"2022-03-02T08:10:51.000Z","updated_at":"2024-07-15T07:50:01.737Z"},{"title":"CMC Updates","language":"en","created_at":"2021-11-03T08:23:36.000Z","updated_at":"2024-07-15T07:50:01.737Z"}]},{"id":"63637417847d336a2db377fb","slug":"crypto-basics","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/64112bea3b9b4038b6cbc25a1cd86fb7.png","created_at":"2021-08-03T16:34:57.000Z","updated_at":"2021-08-03T16:34:57.000Z","parent_slug":"learn","translations":[{"title":"Crypto Basics","language":"de","created_at":"2022-02-22T08:58:06.000Z","updated_at":"2022-08-24T15:11:26.000Z"},{"title":"Crypto Basics","description":"All you need to know about the basics of cryptocurrency in one place. Learn how Bitcoin, blockchain and altcoins work, how to actually use them, and why it matters to you.","language":"en","created_at":"2021-08-03T16:34:57.000Z","updated_at":"2022-08-24T15:11:26.000Z"},{"title":"Crypto Basics","language":"es","created_at":"2022-02-22T08:58:45.000Z","updated_at":"2022-08-24T15:11:26.000Z"},{"title":"Crypto Basics","language":"id","created_at":"2021-09-23T14:40:07.000Z","updated_at":"2022-08-24T15:11:26.000Z"},{"title":"Crypto Basics","language":"pt","created_at":"2022-02-22T08:58:33.000Z","updated_at":"2022-08-24T15:11:26.000Z"},{"title":"Основы крипто","description":"Все что надо вам нужно знать про основы криптоиндустрии у вас под рукой. Узнайте как работают Bitcoin, блокчейн и альткоины, как их использовать и почему это важно.","language":"ru","created_at":"2021-08-08T13:23:53.000Z","updated_at":"2022-08-24T15:11:26.000Z"},{"title":"Crypto Basics","language":"th","created_at":"2022-04-14T10:50:24.000Z","updated_at":"2022-08-24T15:11:26.000Z"},{"title":"Crypto Basics","language":"tr","created_at":"2022-02-22T08:58:25.000Z","updated_at":"2022-08-24T15:11:26.000Z"},{"title":"Crypto Basics","language":"uk","created_at":"2022-04-11T14:35:55.000Z","updated_at":"2022-08-24T15:11:26.000Z"},{"title":"Crypto Basics","language":"vi","created_at":"2022-02-22T08:58:17.000Z","updated_at":"2022-08-24T15:11:26.000Z"},{"title":"Crypto Basics","language":"zh","created_at":"2022-08-24T15:11:26.000Z","updated_at":"2022-08-24T15:11:26.000Z"}]},{"id":"63637417847d336a2db37807","slug":"defi","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/dd0791151110497095e23ed1066a5cb4.png","created_at":"2021-11-04T07:49:03.000Z","updated_at":"2022-12-07T16:28:56.722Z","parent_slug":"topics","translations":[{"title":"DeFi","language":"de","created_at":"2022-03-02T08:13:52.000Z","updated_at":"2022-12-07T16:28:56.722Z"},{"title":"DeFi","language":"es","created_at":"2022-03-02T08:13:52.000Z","updated_at":"2022-12-07T16:28:56.722Z"},{"title":"DeFi","language":"id","created_at":"2022-03-02T08:13:52.000Z","updated_at":"2022-12-07T16:28:56.722Z"},{"title":"DeFi","language":"pt","created_at":"2022-03-02T08:13:52.000Z","updated_at":"2022-12-07T16:28:56.722Z"},{"title":"DeFi","language":"ru","created_at":"2022-03-02T08:13:52.000Z","updated_at":"2022-12-07T16:28:56.722Z"},{"title":"DeFi","language":"th","created_at":"2022-04-14T10:50:02.000Z","updated_at":"2022-12-07T16:28:56.722Z"},{"title":"DeFi","language":"tr","created_at":"2022-03-02T08:13:52.000Z","updated_at":"2022-12-07T16:28:56.722Z"},{"title":"DeFi","language":"uk","created_at":"2022-04-11T14:35:32.000Z","updated_at":"2022-12-07T16:28:56.722Z"},{"title":"DeFi","language":"vi","created_at":"2022-03-02T08:13:52.000Z","updated_at":"2022-12-07T16:28:56.722Z"},{"title":"DeFi","description":"Short for decentralized finance, DeFi refers to peer-to-peer financial services that operate permissionlessly — check out major DeFi news, deep dives into DeFi protocols and guides on how to DeFi.","language":"en","created_at":"2021-11-04T07:49:03.000Z","updated_at":"2022-12-07T16:28:56.722Z"}]},{"id":"63637417847d336a2db37812","slug":"defi-g","created_at":"2021-12-22T09:05:37.000Z","updated_at":"2021-12-22T09:05:37.000Z","parent_slug":"gravity","translations":[{"title":"DeFi","language":"en","created_at":"2021-12-22T09:05:37.000Z"}]},{"id":"63637417847d336a2db37804","slug":"ethereum","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/f31fe09cd14a4146ab6d8da166210242.png","created_at":"2021-11-04T07:48:33.000Z","updated_at":"2022-12-07T16:25:49.201Z","parent_slug":"topics","translations":[{"title":"Ethereum","language":"de","created_at":"2022-03-02T08:12:21.000Z","updated_at":"2022-12-07T16:25:49.201Z"},{"title":"Ethereum","language":"es","created_at":"2022-03-02T08:12:21.000Z","updated_at":"2022-12-07T16:25:49.201Z"},{"title":"Ethereum","language":"id","created_at":"2022-03-02T08:12:21.000Z","updated_at":"2022-12-07T16:25:49.201Z"},{"title":"Ethereum","language":"pt","created_at":"2022-03-02T08:12:21.000Z","updated_at":"2022-12-07T16:25:49.201Z"},{"title":"Ethereum","language":"ru","created_at":"2022-03-02T08:12:21.000Z","updated_at":"2022-12-07T16:25:49.201Z"},{"title":"Ethereum","language":"th","created_at":"2022-04-14T10:50:08.000Z","updated_at":"2022-12-07T16:25:49.201Z"},{"title":"Ethereum","language":"tr","created_at":"2022-03-02T08:12:21.000Z","updated_at":"2022-12-07T16:25:49.201Z"},{"title":"Ethereum","language":"uk","created_at":"2022-04-11T14:35:37.000Z","updated_at":"2022-12-07T16:25:49.201Z"},{"title":"Ethereum","language":"vi","created_at":"2022-03-02T08:12:21.000Z","updated_at":"2022-12-07T16:25:49.201Z"},{"title":"Ethereum","description":"Here we cover all you need to know about Ethereum — the decentralized, open-source computing platform with smart contract functionality.","language":"en","created_at":"2021-11-04T07:48:33.000Z","updated_at":"2022-12-07T16:25:49.201Z"}]},{"id":"63637417847d336a2db37800","slug":"feature-explorer","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/9e1fce722ad84962a5f7d3cda69afc03.png","created_at":"2021-11-03T08:24:10.000Z","updated_at":"2022-12-07T16:32:08.943Z","parent_slug":"coinmarketcap-news","translations":[{"title":"Feature Explorer","language":"de","created_at":"2022-03-02T08:12:09.000Z","updated_at":"2022-12-07T16:32:08.943Z"},{"title":"Feature Explorer","language":"es","created_at":"2022-03-02T08:12:09.000Z","updated_at":"2022-12-07T16:32:08.943Z"},{"title":"Feature Explorer","language":"id","created_at":"2022-03-02T08:12:09.000Z","updated_at":"2022-12-07T16:32:08.943Z"},{"title":"Feature Explorer","language":"pt","created_at":"2022-03-02T08:12:09.000Z","updated_at":"2022-12-07T16:32:08.943Z"},{"title":"Feature Explorer","language":"ru","created_at":"2022-03-02T08:12:09.000Z","updated_at":"2022-12-07T16:32:08.943Z"},{"title":"Feature Explorer","language":"th","created_at":"2022-07-26T12:21:12.000Z","updated_at":"2022-12-07T16:32:08.943Z"},{"title":"Feature Explorer","language":"tr","created_at":"2022-03-02T08:12:09.000Z","updated_at":"2022-12-07T16:32:08.943Z"},{"title":"Feature Explorer","language":"uk","created_at":"2022-04-11T14:35:45.000Z","updated_at":"2022-12-07T16:32:08.943Z"},{"title":"Feature Explorer","language":"vi","created_at":"2022-03-02T08:12:09.000Z","updated_at":"2022-12-07T16:32:08.943Z"},{"title":"Feature Explorer","description":"Don't get left behind — understand our features and updates better here!","language":"en","created_at":"2021-11-03T08:24:10.000Z","updated_at":"2022-12-07T16:32:08.943Z"}]},{"id":"63637417847d336a2db37817","slug":"feature-explorer-g","created_at":"2021-12-22T09:07:17.000Z","updated_at":"2021-12-22T09:07:17.000Z","parent_slug":"gravity","translations":[{"title":"Feature Explorer","language":"de","created_at":"2022-03-02T07:29:28.000Z","updated_at":"2022-04-14T10:49:50.000Z"},{"title":"Feature Explorer","language":"en","created_at":"2021-12-22T09:07:17.000Z","updated_at":"2022-04-14T10:49:50.000Z"},{"title":"Feature Explorer","language":"es","created_at":"2022-03-02T07:29:18.000Z","updated_at":"2022-04-14T10:49:50.000Z"},{"title":"Feature Explorer","language":"id","created_at":"2022-03-02T07:29:30.000Z","updated_at":"2022-04-14T10:49:50.000Z"},{"title":"Feature Explorer","language":"pt","created_at":"2022-03-02T07:29:20.000Z","updated_at":"2022-04-14T10:49:50.000Z"},{"title":"Feature Explorer","language":"ru","created_at":"2022-03-02T07:29:33.000Z","updated_at":"2022-04-14T10:49:50.000Z"},{"title":"Feature Explorer","language":"th","created_at":"2022-04-14T10:49:50.000Z","updated_at":"2022-04-14T10:49:50.000Z"},{"title":"Feature Explorer","language":"tr","created_at":"2022-03-02T07:29:23.000Z","updated_at":"2022-04-14T10:49:50.000Z"},{"title":"Feature Explorer","language":"uk","created_at":"2022-04-11T14:35:21.000Z","updated_at":"2022-04-14T10:49:50.000Z"},{"title":"Feature Explorer","language":"vi","created_at":"2022-03-02T07:29:25.000Z","updated_at":"2022-04-14T10:49:50.000Z"}]},{"id":"63637417847d336a2db37809","slug":"gamefi","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/61bb7bebf2e14b8a82874c8947af06bf.png","created_at":"2021-11-04T07:49:26.000Z","updated_at":"2022-12-07T16:29:33.029Z","parent_slug":"topics","translations":[{"title":"GameFi","language":"de","created_at":"2022-03-02T08:13:56.000Z","updated_at":"2022-12-07T16:29:33.029Z"},{"title":"GameFi","language":"es","created_at":"2022-03-02T08:13:56.000Z","updated_at":"2022-12-07T16:29:33.029Z"},{"title":"GameFi","language":"id","created_at":"2022-03-02T08:13:56.000Z","updated_at":"2022-12-07T16:29:33.029Z"},{"title":"GameFi","language":"pt","created_at":"2022-03-02T08:13:56.000Z","updated_at":"2022-12-07T16:29:33.029Z"},{"title":"GameFi","language":"ru","created_at":"2022-03-02T08:13:56.000Z","updated_at":"2022-12-07T16:29:33.029Z"},{"title":"GameFi","language":"th","created_at":"2022-04-14T10:49:57.000Z","updated_at":"2022-12-07T16:29:33.029Z"},{"title":"GameFi","language":"tr","created_at":"2022-03-02T08:13:56.000Z","updated_at":"2022-12-07T16:29:33.029Z"},{"title":"GameFi","language":"uk","created_at":"2022-04-11T14:35:27.000Z","updated_at":"2022-12-07T16:29:33.029Z"},{"title":"GameFi","language":"vi","created_at":"2022-03-02T08:13:56.000Z","updated_at":"2022-12-07T16:29:33.029Z"},{"title":"GameFi","description":"Discover GameFi projects and industry reports that will only make you an expert on Web3 and blockchain gaming.","language":"en","created_at":"2021-11-04T07:49:26.000Z","updated_at":"2022-12-07T16:29:33.029Z"}]},{"id":"63637417847d336a2db37813","slug":"gamefi-g","created_at":"2021-12-22T09:05:56.000Z","updated_at":"2021-12-22T09:05:56.000Z","parent_slug":"gravity","translations":[{"title":"GameFi","language":"en","created_at":"2021-12-22T09:05:56.000Z"}]},{"id":"63637417847d336a2db3780c","slug":"gravity","created_at":"2021-12-22T06:38:33.000Z","updated_at":"2021-12-22T06:38:33.000Z","translations":[{"title":"Gravity","language":"en","created_at":"2021-12-22T06:38:33.000Z"}]},{"id":"63637417847d336a2db3780d","slug":"how-to-guide","created_at":"2021-12-22T09:03:38.000Z","updated_at":"2021-12-22T09:03:38.000Z","parent_slug":"gravity","translations":[{"title":"How-to Guides","language":"de","created_at":"2022-02-22T10:24:50.000Z","updated_at":"2022-02-22T10:24:50.000Z"},{"title":"How-to Guides","language":"en","created_at":"2021-12-22T09:03:38.000Z","updated_at":"2022-02-22T10:24:50.000Z"}]},{"id":"63637417847d336a2db377f7","slug":"how-to-guides","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/b2645949dd5e444f91bdda7fb2f513fd.png","created_at":"2021-08-03T14:18:47.000Z","updated_at":"2021-08-03T14:18:47.000Z","parent_slug":"learn","translations":[{"title":"How-to Guides","language":"de","created_at":"2022-03-02T07:31:26.000Z","updated_at":"2022-04-14T10:50:34.000Z"},{"title":"How-to Guides","description":"Dealing with cryptocurrency isn’t always easy. CMC provides in-depth guides into everything from how to create a crypto address to the best way to keep your crypto safe.","language":"en","created_at":"2021-08-03T14:18:47.000Z","updated_at":"2022-04-14T10:50:34.000Z"},{"title":"How-to Guides","language":"es","created_at":"2022-03-02T07:31:16.000Z","updated_at":"2022-04-14T10:50:34.000Z"},{"title":"How-to Guides","language":"id","created_at":"2021-09-23T14:40:23.000Z","updated_at":"2022-04-14T10:50:34.000Z"},{"title":"How-to Guides","language":"pt","created_at":"2022-03-02T07:31:18.000Z","updated_at":"2022-04-14T10:50:34.000Z"},{"title":"Практические руководства","description":"Не всегда легко разобраться с криптовалютами. CoinMarketCap предоставляет детальные руководства обо всех нюансах от создания крипто адреса до лучших способов безопасно хранить ваши криптовалюты.","language":"ru","created_at":"2021-08-20T13:49:10.000Z","updated_at":"2022-04-14T10:50:34.000Z"},{"title":"How-to Guides","language":"th","created_at":"2022-04-14T10:50:34.000Z","updated_at":"2022-04-14T10:50:34.000Z"},{"title":"How-to Guides","language":"tr","created_at":"2022-03-02T07:31:21.000Z","updated_at":"2022-04-14T10:50:34.000Z"},{"title":"How-to Guides","language":"uk","created_at":"2022-04-11T14:36:05.000Z","updated_at":"2022-04-14T10:50:34.000Z"},{"title":"How-to Guides","language":"vi","created_at":"2022-03-02T07:31:24.000Z","updated_at":"2022-04-14T10:50:34.000Z"}]},{"id":"63637417847d336a2db377fc","slug":"learn","created_at":"2021-10-23T11:45:27.000Z","updated_at":"2021-10-23T11:45:27.000Z","translations":[{"title":"Learn","language":"de","created_at":"2022-03-02T07:34:38.000Z","updated_at":"2022-04-14T10:50:22.000Z"},{"title":"Learn","language":"en","created_at":"2021-10-23T11:45:27.000Z","updated_at":"2022-04-14T10:50:22.000Z"},{"title":"Learn","language":"es","created_at":"2022-03-02T07:34:28.000Z","updated_at":"2022-04-14T10:50:22.000Z"},{"title":"Learn","language":"id","created_at":"2022-03-02T07:34:40.000Z","updated_at":"2022-04-14T10:50:22.000Z"},{"title":"Learn","language":"pt","created_at":"2022-03-02T07:34:30.000Z","updated_at":"2022-04-14T10:50:22.000Z"},{"title":"Learn","language":"ru","created_at":"2022-03-02T07:34:43.000Z","updated_at":"2022-04-14T10:50:22.000Z"},{"title":"Learn","language":"th","created_at":"2022-04-14T10:50:22.000Z","updated_at":"2022-04-14T10:50:22.000Z"},{"title":"Learn","language":"tr","created_at":"2022-03-02T07:34:33.000Z","updated_at":"2022-04-14T10:50:22.000Z"},{"title":"Learn","language":"uk","created_at":"2022-04-11T14:35:53.000Z","updated_at":"2022-04-14T10:50:22.000Z"},{"title":"Learn","language":"vi","created_at":"2022-03-02T07:34:35.000Z","updated_at":"2022-04-14T10:50:22.000Z"}]},{"id":"63637417847d336a2db377f9","slug":"market-musing","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/33d76d0d4aab45b9b02ebab17820373f.png","created_at":"2021-08-03T16:34:25.000Z","updated_at":"2024-07-15T08:12:22.321Z","parent_slug":"learn","translations":[{"title":"Market Musings","language":"de","created_at":"2022-03-02T07:33:01.000Z","updated_at":"2024-07-15T08:12:22.321Z"},{"title":"Market Musings","language":"es","created_at":"2022-03-02T07:32:53.000Z","updated_at":"2024-07-15T08:12:22.321Z"},{"title":"Crypto Basics","language":"id","created_at":"2021-09-23T14:40:11.000Z","updated_at":"2024-07-15T08:12:22.321Z"},{"title":"Market Musings","language":"pt","created_at":"2022-03-02T07:32:51.000Z","updated_at":"2024-07-15T08:12:22.321Z"},{"title":"Поразмышляем о рынках","description":"Узнайте важные инсайты от лидеров в сфере блокчейна и крипто, чтобы лучше ориентироваться в криптоиндустрии.","language":"ru","created_at":"2021-08-09T15:04:16.000Z","updated_at":"2024-07-15T08:12:22.321Z"},{"title":"Market Musings","language":"th","created_at":"2022-04-14T10:50:29.000Z","updated_at":"2024-07-15T08:12:22.321Z"},{"title":"Market Musings","language":"tr","created_at":"2022-03-02T07:32:55.000Z","updated_at":"2024-07-15T08:12:22.321Z"},{"title":"Market Musings","language":"uk","created_at":"2022-04-11T14:36:00.000Z","updated_at":"2024-07-15T08:12:22.321Z"},{"title":"Market Musings","language":"vi","created_at":"2022-03-02T07:32:58.000Z","updated_at":"2024-07-15T08:12:22.321Z"},{"title":"Crypto News","description":"Read crypto news and discover knowledgeable insights from leaders in the blockchain and cryptocurrency sectors.","language":"en","created_at":"2021-08-03T16:34:25.000Z","updated_at":"2024-07-15T08:12:22.321Z"}]},{"id":"669e17805ae2e073dad9e1f3","slug":"market-musing-g","created_at":"2024-07-22T08:25:36.481Z","updated_at":"2024-07-22T08:25:44.755Z","translations":[{"title":"Market Musing-g","language":"en","created_at":"2024-07-22T08:25:36.481Z","updated_at":"2024-07-22T08:25:44.754Z"},{"title":"Market Musing-g","language":"vi","created_at":"2024-07-22T08:25:44.755Z"},{"title":"Market Musing-g","language":"ru","created_at":"2024-07-22T08:25:44.755Z"},{"title":"Market Musing-g","language":"id","created_at":"2024-07-22T08:25:44.755Z"},{"title":"Market Musing-g","language":"pt","created_at":"2024-07-22T08:25:44.755Z"},{"title":"Market Musing-g","language":"es","created_at":"2024-07-22T08:25:44.755Z"},{"title":"Market Musing-g","language":"de","created_at":"2024-07-22T08:25:44.755Z"},{"title":"Market Musing-g","language":"th","created_at":"2024-07-22T08:25:44.755Z"},{"title":"Market Musing-g","language":"zh","created_at":"2024-07-22T08:25:44.755Z"},{"title":"Market Musing-g","language":"tr","created_at":"2024-07-22T08:25:44.755Z"},{"title":"Market Musing-g","language":"uk","created_at":"2024-07-22T08:25:44.755Z"}]},{"id":"63637417847d336a2db37801","slug":"marketing","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/44b2da07a2fa456583ce192cb07ea631.png","created_at":"2021-11-03T08:24:22.000Z","updated_at":"2022-12-07T16:30:43.318Z","parent_slug":"coinmarketcap-news","translations":[{"title":"Marketing","language":"de","created_at":"2022-03-02T08:12:11.000Z","updated_at":"2022-12-07T16:30:43.318Z"},{"title":"Marketing","language":"es","created_at":"2022-03-02T08:12:11.000Z","updated_at":"2022-12-07T16:30:43.318Z"},{"title":"Marketing","language":"id","created_at":"2022-03-02T08:12:11.000Z","updated_at":"2022-12-07T16:30:43.318Z"},{"title":"Marketing","language":"pt","created_at":"2022-03-02T08:12:11.000Z","updated_at":"2022-12-07T16:30:43.318Z"},{"title":"Marketing","language":"ru","created_at":"2022-03-02T08:12:11.000Z","updated_at":"2022-12-07T16:30:43.318Z"},{"title":"Marketing","language":"th","created_at":"2022-04-14T10:50:13.000Z","updated_at":"2022-12-07T16:30:43.318Z"},{"title":"Marketing","language":"tr","created_at":"2022-03-02T08:12:11.000Z","updated_at":"2022-12-07T16:30:43.318Z"},{"title":"Marketing","language":"uk","created_at":"2022-04-11T14:35:43.000Z","updated_at":"2022-12-07T16:30:43.318Z"},{"title":"Marketing","language":"vi","created_at":"2022-03-02T08:12:11.000Z","updated_at":"2022-12-07T16:30:43.318Z"},{"title":"Marketing","description":"Get the latest updates on our Airdrop campaigns, Diamonds reward program and more!","language":"en","created_at":"2021-11-03T08:24:22.000Z","updated_at":"2022-12-07T16:30:43.318Z"}]},{"id":"63637417847d336a2db37816","slug":"marketing-g","created_at":"2021-12-22T09:06:36.000Z","updated_at":"2021-12-22T09:06:36.000Z","parent_slug":"gravity","translations":[{"title":"Marketing","language":"en","created_at":"2021-12-22T09:06:36.000Z"}]},{"id":"63637417847d336a2db3780b","slug":"metaverse","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/3494386ba97d4985bde6c79f778375d2.png","created_at":"2021-11-04T07:49:59.000Z","updated_at":"2022-12-07T16:26:47.166Z","parent_slug":"topics","translations":[{"title":"Metaverse","language":"de","created_at":"2022-03-02T08:13:59.000Z","updated_at":"2022-12-07T16:26:47.166Z"},{"title":"Metaverse","language":"es","created_at":"2022-03-02T08:13:59.000Z","updated_at":"2022-12-07T16:26:47.166Z"},{"title":"Metaverse","language":"id","created_at":"2022-03-02T08:13:59.000Z","updated_at":"2022-12-07T16:26:47.166Z"},{"title":"Metaverse","language":"pt","created_at":"2022-03-02T08:13:59.000Z","updated_at":"2022-12-07T16:26:47.166Z"},{"title":"Metaverse","language":"ru","created_at":"2022-03-02T08:13:59.000Z","updated_at":"2022-12-07T16:26:47.166Z"},{"title":"Metaverse","language":"th","created_at":"2022-04-14T10:49:53.000Z","updated_at":"2022-12-07T16:26:47.166Z"},{"title":"Metaverse","language":"tr","created_at":"2022-03-02T08:13:59.000Z","updated_at":"2022-12-07T16:26:47.166Z"},{"title":"Metaverse","language":"uk","created_at":"2022-04-11T14:35:25.000Z","updated_at":"2022-12-07T16:26:47.166Z"},{"title":"Metaverse","language":"vi","created_at":"2022-03-02T08:13:59.000Z","updated_at":"2022-12-07T16:26:47.166Z"},{"title":"Metaverse","description":"Follow the latest developments on the metaverse space and get lost in all types of immersive virtual worlds.","language":"en","created_at":"2021-11-04T07:49:59.000Z","updated_at":"2022-12-07T16:26:47.166Z"}]},{"id":"63637417847d336a2db37811","slug":"metaverse-g","created_at":"2021-12-22T09:05:19.000Z","updated_at":"2021-12-22T09:05:19.000Z","parent_slug":"gravity","translations":[{"title":"Metaverse","language":"en","created_at":"2021-12-22T09:05:19.000Z"}]},{"id":"63637417847d336a2db37814","slug":"nft","created_at":"2021-12-22T09:06:08.000Z","updated_at":"2021-12-22T09:06:08.000Z","parent_slug":"gravity","translations":[{"title":"NFTs","language":"en","created_at":"2021-12-22T09:06:08.000Z"}]},{"id":"63637417847d336a2db37808","slug":"nfts","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/b2e38aa2f89c493a9eb877563d9a6125.png","created_at":"2021-11-04T07:49:17.000Z","updated_at":"2022-12-07T16:30:02.742Z","parent_slug":"topics","translations":[{"title":"NFTs","language":"de","created_at":"2022-03-02T08:13:54.000Z","updated_at":"2022-12-07T16:30:02.742Z"},{"title":"NFTs","language":"es","created_at":"2022-03-02T08:13:54.000Z","updated_at":"2022-12-07T16:30:02.742Z"},{"title":"NFTs","language":"id","created_at":"2022-03-02T08:13:54.000Z","updated_at":"2022-12-07T16:30:02.742Z"},{"title":"NFTs","language":"pt","created_at":"2022-03-02T08:13:54.000Z","updated_at":"2022-12-07T16:30:02.742Z"},{"title":"NFTs","language":"ru","created_at":"2022-03-02T08:13:54.000Z","updated_at":"2022-12-07T16:30:02.742Z"},{"title":"NFTs","language":"th","created_at":"2022-04-14T10:49:59.000Z","updated_at":"2022-12-07T16:30:02.742Z"},{"title":"NFTs","language":"tr","created_at":"2022-03-02T08:13:54.000Z","updated_at":"2022-12-07T16:30:02.742Z"},{"title":"NFTs","language":"uk","created_at":"2022-04-11T14:35:30.000Z","updated_at":"2022-12-07T16:30:02.742Z"},{"title":"NFTs","language":"vi","created_at":"2022-03-02T08:13:54.000Z","updated_at":"2022-12-07T16:30:02.742Z"},{"title":"NFTs","description":"Keep up with the latest in the non-fungible token space, learning more about digital ownership on the blockchain.","language":"en","created_at":"2021-11-04T07:49:17.000Z","updated_at":"2022-12-07T16:30:02.742Z"}]},{"id":"670fdc6be30f155be0406fd2","slug":"tap-to-earn","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/83b7decc47c5442689f3bcc414dc6106.png","created_at":"2024-10-16T15:31:55.719Z","updated_at":"2025-02-03T10:27:24.355Z","translations":[{"title":"Tap To Earn","description":"Read the latest Tap to Earn articles","language":"en","created_at":"2024-10-16T15:31:55.719Z","updated_at":"2025-02-03T10:27:24.355Z"}]},{"id":"63637417847d336a2db377fa","slug":"tech-deep-dives","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/c4d4081206a54bc29287837d9ad6facf.png","created_at":"2021-08-03T16:34:45.000Z","updated_at":"2021-08-03T16:34:45.000Z","parent_slug":"learn","translations":[{"title":"Tech Deep Dives","language":"de","created_at":"2022-02-22T10:23:57.000Z","updated_at":"2022-04-14T10:50:28.000Z"},{"title":"Tech Deep Dives","description":"The crypto industry is rapidly changing — that’s what makes it so much fun, but it can become easy to get lost in the whirl of new technologies. CMC’s tech deep dives are here to help.","language":"en","created_at":"2021-08-03T16:34:45.000Z","updated_at":"2022-04-14T10:50:28.000Z"},{"title":"Tech Deep Dives","language":"es","created_at":"2022-03-02T07:33:50.000Z","updated_at":"2022-04-14T10:50:28.000Z"},{"title":"Tech Deep Dives","language":"id","created_at":"2021-09-23T14:04:47.000Z","updated_at":"2022-04-14T10:50:28.000Z"},{"title":"Tech Deep Dives","language":"pt","created_at":"2022-03-02T07:33:47.000Z","updated_at":"2022-04-14T10:50:28.000Z"},{"title":"Глубокое погружение в технологии","description":"Криптоиндустрия развивается очень быстро — и именно поэтому она такая захватывающая! Но становится очень легко потеряться в вихре новых технологии. Глубокое погружение в технологии с CoinMarketCap поможет вам лучше разобраться.","language":"ru","created_at":"2021-08-20T13:47:21.000Z","updated_at":"2022-04-14T10:50:28.000Z"},{"title":"Tech Deep Dives","language":"th","created_at":"2022-04-14T10:50:28.000Z","updated_at":"2022-04-14T10:50:28.000Z"},{"title":"Tech Deep Dives","language":"tr","created_at":"2022-03-02T07:33:43.000Z","updated_at":"2022-04-14T10:50:28.000Z"},{"title":"Tech Deep Dives","language":"uk","created_at":"2022-04-11T14:35:58.000Z","updated_at":"2022-04-14T10:50:28.000Z"},{"title":"Tech Deep Dives","language":"vi","created_at":"2022-03-02T07:33:41.000Z","updated_at":"2022-04-14T10:50:28.000Z"}]},{"id":"63637417847d336a2db37810","slug":"tech-deep-dives-g","created_at":"2021-12-22T09:04:25.000Z","updated_at":"2021-12-22T09:04:25.000Z","parent_slug":"gravity","translations":[{"title":"Tech Deep Dives","language":"en","created_at":"2021-12-22T09:04:25.000Z","updated_at":"2021-12-22T09:05:04.000Z"}]},{"id":"63637417847d336a2db37802","slug":"topics","created_at":"2021-11-04T07:47:20.000Z","updated_at":"2021-11-04T07:47:20.000Z","translations":[{"title":"Topics","language":"de","created_at":"2022-03-02T08:12:14.000Z","updated_at":"2022-04-14T10:50:11.000Z"},{"title":"Topics","language":"en","created_at":"2021-11-04T07:47:20.000Z","updated_at":"2022-04-14T10:50:11.000Z"},{"title":"Topics","language":"es","created_at":"2022-03-02T08:12:14.000Z","updated_at":"2022-04-14T10:50:11.000Z"},{"title":"Topics","language":"id","created_at":"2022-03-02T08:12:14.000Z","updated_at":"2022-04-14T10:50:11.000Z"},{"title":"Topics","language":"pt","created_at":"2022-03-02T08:12:14.000Z","updated_at":"2022-04-14T10:50:11.000Z"},{"title":"Topics","language":"ru","created_at":"2022-03-02T07:36:54.000Z","updated_at":"2022-04-14T10:50:11.000Z"},{"title":"Topics","language":"th","created_at":"2022-04-14T10:50:11.000Z","updated_at":"2022-04-14T10:50:11.000Z"},{"title":"Topics","language":"tr","created_at":"2022-03-02T08:12:14.000Z","updated_at":"2022-04-14T10:50:11.000Z"},{"title":"Topics","language":"uk","created_at":"2022-04-11T14:35:40.000Z","updated_at":"2022-04-14T10:50:11.000Z"},{"title":"Topics","language":"vi","created_at":"2022-03-02T08:12:14.000Z","updated_at":"2022-04-14T10:50:11.000Z"}]},{"id":"63637417847d336a2db37806","slug":"trading","created_at":"2021-11-04T07:48:52.000Z","updated_at":"2022-12-07T16:27:28.514Z","parent_slug":"topics","translations":[{"title":"Trading","language":"de","created_at":"2022-03-02T08:13:49.000Z","updated_at":"2022-12-07T16:27:28.514Z"},{"title":"Trading","language":"es","created_at":"2022-03-02T08:13:49.000Z","updated_at":"2022-12-07T16:27:28.514Z"},{"title":"Trading","language":"id","created_at":"2022-03-02T08:13:49.000Z","updated_at":"2022-12-07T16:27:28.514Z"},{"title":"Trading","language":"pt","created_at":"2022-03-02T08:13:49.000Z","updated_at":"2022-12-07T16:27:28.514Z"},{"title":"Trading","language":"ru","created_at":"2022-03-02T08:13:49.000Z","updated_at":"2022-12-07T16:27:28.514Z"},{"title":"Trading","language":"th","created_at":"2022-04-14T10:50:03.000Z","updated_at":"2022-12-07T16:27:28.514Z"},{"title":"Trading","language":"tr","created_at":"2022-03-02T08:13:49.000Z","updated_at":"2022-12-07T16:27:28.514Z"},{"title":"Trading","language":"uk","created_at":"2022-04-11T14:35:33.000Z","updated_at":"2022-12-07T16:27:28.514Z"},{"title":"Trading","language":"vi","created_at":"2022-03-02T08:13:49.000Z","updated_at":"2022-12-07T16:27:28.514Z"},{"title":"Trading","description":"Find out the latest stories and research into cryptocurrency trading here.","language":"en","created_at":"2021-11-04T07:48:52.000Z","updated_at":"2022-12-07T16:27:28.514Z"}]},{"id":"63637417847d336a2db3780e","slug":"trading-analysi","created_at":"2021-12-22T09:03:49.000Z","updated_at":"2021-12-22T09:03:49.000Z","parent_slug":"gravity","translations":[{"title":"Trading Analysis","language":"en","created_at":"2021-12-22T09:03:49.000Z","updated_at":"2021-12-22T09:04:52.000Z"}]},{"id":"63637417847d336a2db377fd","slug":"trading-analysis","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/93d795b5dd014057bff78c053d54ef4f.png","created_at":"2021-10-28T13:11:44.000Z","updated_at":"2022-12-07T16:22:22.514Z","parent_slug":"learn","translations":[{"title":"Trading Analysis","language":"de","created_at":"2022-03-02T07:35:48.000Z","updated_at":"2022-12-07T16:22:22.513Z"},{"title":"Trading Analysis","language":"es","created_at":"2022-03-02T07:35:38.000Z","updated_at":"2022-12-07T16:22:22.513Z"},{"title":"Trading Analysis","language":"id","created_at":"2022-03-02T07:35:51.000Z","updated_at":"2022-12-07T16:22:22.513Z"},{"title":"Trading Analysis","language":"pt","created_at":"2022-03-02T07:35:41.000Z","updated_at":"2022-12-07T16:22:22.513Z"},{"title":"Trading Analysis","language":"ru","created_at":"2022-03-02T07:35:53.000Z","updated_at":"2022-12-07T16:22:22.513Z"},{"title":"Trading Analysis","language":"th","created_at":"2022-04-14T10:50:19.000Z","updated_at":"2022-12-07T16:22:22.513Z"},{"title":"Trading Analysis","language":"tr","created_at":"2022-03-02T07:35:43.000Z","updated_at":"2022-12-07T16:22:22.513Z"},{"title":"Trading Analysis","language":"uk","created_at":"2022-04-11T14:35:51.000Z","updated_at":"2022-12-07T16:22:22.513Z"},{"title":"Trading Analysis","language":"vi","created_at":"2022-03-02T07:35:46.000Z","updated_at":"2022-12-07T16:22:22.513Z"},{"title":"Trading Analysis","description":"Use our weekly technical analysis on trending coins and practical techniques to trade cryptocurrencies and digital assets like Bitcoin, Ethereum and Dogecoin.","language":"en","created_at":"2021-10-28T13:11:44.000Z","updated_at":"2022-12-07T16:22:22.513Z"}]},{"id":"63637417847d336a2db37815","slug":"trading-g","created_at":"2021-12-22T09:06:20.000Z","updated_at":"2021-12-22T09:06:20.000Z","parent_slug":"gravity","translations":[{"title":"Trading","language":"en","created_at":"2021-12-22T09:06:20.000Z","updated_at":"2021-12-22T09:07:06.000Z"}]}],"categoriesCount":[{"id":"63637417847d336a2db377f9","slug":"market-musing","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/33d76d0d4aab45b9b02ebab17820373f.png","created_at":"2021-08-03T16:34:25.000Z","updated_at":"2024-07-15T08:12:22.321Z","parent_id":"63637417847d336a2db377fc","articles":6270},{"id":"63637417847d336a2db377f7","slug":"how-to-guides","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/b2645949dd5e444f91bdda7fb2f513fd.png","created_at":"2021-08-03T14:18:47.000Z","updated_at":"2021-08-03T14:18:47.000Z","parent_id":"63637417847d336a2db377fc","articles":135},{"id":"63637417847d336a2db37801","slug":"marketing","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/44b2da07a2fa456583ce192cb07ea631.png","created_at":"2021-11-03T08:24:22.000Z","updated_at":"2022-12-07T16:30:43.318Z","parent_id":"63637417847d336a2db377fe","articles":154},{"id":"63637417847d336a2db377fa","slug":"tech-deep-dives","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/c4d4081206a54bc29287837d9ad6facf.png","created_at":"2021-08-03T16:34:45.000Z","updated_at":"2021-08-03T16:34:45.000Z","parent_id":"63637417847d336a2db377fc","articles":592},{"id":"63637417847d336a2db377fc","slug":"learn","created_at":"2021-10-23T11:45:27.000Z","updated_at":"2021-10-23T11:45:27.000Z","articles":37},{"id":"63637417847d336a2db377fd","slug":"trading-analysis","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/93d795b5dd014057bff78c053d54ef4f.png","created_at":"2021-10-28T13:11:44.000Z","updated_at":"2022-12-07T16:22:22.514Z","parent_id":"63637417847d336a2db377fc","articles":320},{"id":"63637417847d336a2db377fe","slug":"coinmarketcap-news","created_at":"2021-11-03T08:23:36.000Z","updated_at":"2024-07-15T07:50:01.737Z","articles":56},{"id":"63637417847d336a2db37800","slug":"feature-explorer","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/9e1fce722ad84962a5f7d3cda69afc03.png","created_at":"2021-11-03T08:24:10.000Z","updated_at":"2022-12-07T16:32:08.943Z","parent_id":"63637417847d336a2db377fe","articles":45},{"id":"63637417847d336a2db37808","slug":"nfts","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/b2e38aa2f89c493a9eb877563d9a6125.png","created_at":"2021-11-04T07:49:17.000Z","updated_at":"2022-12-07T16:30:02.742Z","parent_id":"63637417847d336a2db37802","articles":403},{"id":"63637417847d336a2db37804","slug":"ethereum","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/f31fe09cd14a4146ab6d8da166210242.png","created_at":"2021-11-04T07:48:33.000Z","updated_at":"2022-12-07T16:25:49.201Z","parent_id":"63637417847d336a2db37802","articles":262},{"id":"63637417847d336a2db37806","slug":"trading","created_at":"2021-11-04T07:48:52.000Z","updated_at":"2022-12-07T16:27:28.514Z","parent_id":"63637417847d336a2db37802","articles":432},{"id":"63637417847d336a2db3780a","slug":"altcoins","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/fce0b02d449245cba857377f7f28c5f5.png","created_at":"2021-11-04T07:49:36.000Z","updated_at":"2022-12-07T16:20:43.548Z","parent_id":"63637417847d336a2db37802","articles":389},{"id":"63637417847d336a2db3780b","slug":"metaverse","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/3494386ba97d4985bde6c79f778375d2.png","created_at":"2021-11-04T07:49:59.000Z","updated_at":"2022-12-07T16:26:47.166Z","parent_id":"63637417847d336a2db37802","articles":175},{"id":"63637417847d336a2db37819","slug":"cmc-research","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/8c3d6407404e49c0a53bc747c1d0cc34.png","created_at":"2022-06-15T17:18:48.000Z","updated_at":"2023-03-28T06:47:13.098Z","parent_id":"63637417847d336a2db377fc","articles":144},{"id":"63637417847d336a2db377f8","slug":"blog","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/403189d0bc3d4b22a765422a4c9f27ea.png","created_at":"2021-08-03T16:34:12.000Z","updated_at":"2021-08-03T16:34:12.000Z","parent_id":"63637417847d336a2db377fc","articles":351},{"id":"63637417847d336a2db377ff","slug":"announcements","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/bf0e708e80084fd5877419bd1e5eea37.png","created_at":"2021-11-03T08:24:02.000Z","updated_at":"2022-12-07T16:31:29.269Z","parent_id":"63637417847d336a2db377fe","articles":77},{"id":"63637417847d336a2db37807","slug":"defi","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/dd0791151110497095e23ed1066a5cb4.png","created_at":"2021-11-04T07:49:03.000Z","updated_at":"2022-12-07T16:28:56.722Z","parent_id":"63637417847d336a2db37802","articles":191},{"id":"63637417847d336a2db37809","slug":"gamefi","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/61bb7bebf2e14b8a82874c8947af06bf.png","created_at":"2021-11-04T07:49:26.000Z","updated_at":"2022-12-07T16:29:33.029Z","parent_id":"63637417847d336a2db37802","articles":71},{"id":"63637417847d336a2db377fb","slug":"crypto-basics","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/64112bea3b9b4038b6cbc25a1cd86fb7.png","created_at":"2021-08-03T16:34:57.000Z","updated_at":"2021-08-03T16:34:57.000Z","parent_id":"63637417847d336a2db377fc","articles":797},{"id":"63637417847d336a2db37803","slug":"bitcoin","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/bbb3be20245542e4b0a443c327bc73c1.png","created_at":"2021-11-04T07:48:21.000Z","updated_at":"2022-12-07T16:28:06.623Z","parent_id":"63637417847d336a2db37802","articles":736},{"id":"63637417847d336a2db37805","slug":"blockchain","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/55801fca4a9c4b609104a2eccb37aaf9.png","created_at":"2021-11-04T07:48:43.000Z","updated_at":"2022-12-07T16:41:00.035Z","parent_id":"63637417847d336a2db37802","articles":252},{"id":"670fdc6be30f155be0406fd2","slug":"tap-to-earn","icon":"https://academy-public.coinmarketcap.com/optimized-uploads/83b7decc47c5442689f3bcc414dc6106.png","created_at":"2024-10-16T15:31:55.719Z","updated_at":"2025-02-03T10:27:24.355Z","articles":199},{"id":"679111f3bf71e02463964612","slug":"alpha-radar","created_at":"2025-01-22T15:42:43.766Z","updated_at":"2025-01-22T15:43:03.743Z","parent_id":"63637417847d336a2db377fc","articles":116},{"id":"67a09632ebfe4424bdcf5679","slug":"airdrop-guide","created_at":"2025-02-03T10:10:58.000Z","updated_at":"2025-02-03T10:27:17.263Z","articles":39}],"userABGroup":"navBar-A_controlTest2-A_controlTest-B","__N_SSP":true},"page":"/article/[slug]","query":{"slug":"how-to-integrate-coinmarketcap-api-with-google-sheets"},"buildId":"oHakgmGhbYgYmk5auBHHF","assetPrefix":"/academy","isFallback":false,"gssp":true,"appGip":true,"locale":"en","locales":["en","ar","bg","cs","da","de","el","es","fi","fr","hi","hu","id","it","ja","ko","nl","no","pl","pt","ro","ru","sk","sv","th","tr","uk","ur","vi","zt","zh"],"defaultLocale":"en","scriptLoader":[]}</script></body></html>