Optionally select other parameters, e.g.In the parameters section, select auxiliary fields to retrieve.We’ll start with /v1/cryptocurrency/listings/latest, which is the endpoint for fetching the latest market data. Under Authorization, enter your API key. Select CoinMarketCap from the drop-down list of applications.In Sheets, open API Connector and create a new request ( Extensions > API Connector > Open > Create request).The easiest way to get started with the CoinMarketCap API is through API Connector’s built-in integration. Part 2: Pull Data from CoinMarketCap into Sheets Hover over the API Key box in the top left and copy the key to your clipboard. Congrats! You now have access to the CoinMarketCap API. Click on the email to verify your account, and you'll be redirected into your new CoinMarketCap dashboard. A moment later you'll receive an email.Fill out your details and click Create My Account.If you haven't already, navigate to and click Get Your API Key Now.Appendix: CoinMarketCap Crypto Portfolio TemplateĬlick here to install the API Connector add-on from the Google Marketplace.Part 2: Pull Data from CoinMarketCap into Sheets.We'll first get an API key from CoinMarketCap, and then set up a request to pull in crypto data to your spreadsheet. In this guide, we’ll walk through how to pull cryptocurrency data from the CoinMarketCap API directly into Google Sheets, using the API Connector add-on for Sheets. Show all articles ( 143 ) Collapse Articles.Scrape Google Maps Places into Google Sheets (Outscraper).Import Zoho Data to Google Sheets (Any Application).Import YouTube Public Data to Google Sheets.Import YouTube Analytics Data to Google Sheets.Import Yahoo Finance Data to Google Sheets.Import Yahoo Fantasy Sports Data to Google Sheets.Import WooCommerce Data to Google Sheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |