Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi all,

I’ve been managing my cryptocurrency portfolio in Google Sheets and using APIs (like CoinpediaMarkets, CoinMarketCap) to fetch historic price data. However, I’ve encountered reliability issues with these APIs, especially since free tiers have very limited quotas and paid plans are quite expensive.

A more consistent approach for me has been manually downloading CSV files from CoinpediaMarkets to get Bitcoin Cash’s historical price data and then importing it into my Google Sheets. I use a VLOOKUP formula to match the data with my portfolio.

The issue is, I track Bitcoin Cash along with other coins, and manually downloading and uploading CSV files for each coin is becoming too tedious.

Does anyone know a way to automate this process using tools like Zapier or any other method? For example, I download the Bitcoin Cash historical data from this link on CoinpediaMarkets:  https://markets.coinpedia.org/bitcoin-cash/ click the “Export As” button, and select CSV.

 

Any ideas for automating this would be greatly appreciated!

Hi ​@Coinpedia Ninja,

 

Welcome to the Community. 

 

Zapier doesn’t support automating file downloads directly from the website. Still, you can use a web scraping tool to download CSV files and then automate uploading them to Google Sheets via Zapier.

 

I hope this helps. Let me know if you have any other questions.

Hey there ​@Coinpedia Ninja! 👋

Just checking in to see how things are progressing—did Jammer’s suggestion work for you, or did you find a different solution?

If you need any further assistance, just let us know! 

Reply


Terms & Conditions