![]() ![]() If you’re that isn’t an option for you based on your time/knowledge, you can hire a Zapier expert to develop one for you.įinally, we do have an internal list of apps that have been requested by users, and CoinGecko is on there. All in all, it sounds like your best bet would be to make your own CoinGecko custom integration using the Zapier developer platform. It looks like the data you’d get back from those requests would be in a json format, so you’d need to convert that into something that the Google Sheet could read (eg a csv format). For example, if you copy the 'MULTICASH' Port, the program creates a new CSV Port with the 'MULTICASH (COPY)' code. Copy: When you select this function, the system creates an identical copy of the active CSV Ports with the addition (COPY). I took a look at the CoinGecko API, and there is a Get request that allows you to pull historical data for markets. Import CSV-Ports: This function imports the master data of CSV ports from a file. Hi there’s no coingecko Zapier integration, there isn’t a simple way to do this, but if you’re familiar with webhooks and/or APIs you could do this. I currently get the CSV from going to the coin on CoinGecko (let’s take Stellar/XLM for example): and clicking the “Export As” link on the right and selecting CSV. The problem is, I am trying to monitor around 50 or so coins and this is very tedious to keep downloading CSVs, and uploading them.Ĭould anyone think of a way to automatically do this using Zapier (or other methods)? However, these APIs are less and less reliable usually due to the low quotas they offer for free (and extortionate pricing for their paid API plans).Ī far more reliable method for me is to download a CSV file manually from CoinGecko containing historic price data and then import into Google Sheets and use a VLOOKUP to match the date and price from a master sheet. I’ve been relying on APIs (CoinGecko/CoinMarketCap and others) for historic price information of specific cryptocurrencies so I can see my portfolio’s value over time. I have a cryptocurrency portfolio tracker that I’ve created in Google Sheets.
0 Comments
Leave a Reply. |