[FREE] Get Top100 Coins Data (price,1h,24h,7d, volume) from Coingecko in Google Sheets

theRevolt

Jr Vip
Jr. VIP
Joined
Jul 29, 2009
Messages
2,918
Reaction score
2,090
Someone had asked that and figured just do a quick version. I used coingecko as their data is loaded via HTML, not JS so works just fine with Google Sheets, without needing to set up APIs etc.

I may do another API sheet or explain more about how to do this in Google Sheet.

For now, enjoy, just click here and make your own copy of the sheet. Need to manually reload the sheet, again this is a super basic version but figured might still be of use to some.

LINK


1620836262767.png
 

theRevolt

Jr Vip
Jr. VIP
Joined
Jul 29, 2009
Messages
2,918
Reaction score
2,090
Thank you very much! Will be very useful for me!
Welcome, it's super simple so if it does not work just refresh. If there are errors it can be
- Blocked IP , although less likely as it will vary which IP google uses
- The site structure changed and then need to update this.
 

Digitly

Jr. VIP
Jr. VIP
Joined
Dec 1, 2008
Messages
688
Reaction score
421
Thanks, very useful share.

@theRevolt Is there a way to be notified via email of the change of crypto position?
 
Last edited:

sony1

Junior Member
Joined
Jun 25, 2011
Messages
156
Reaction score
271
Someone had asked that and figured just do a quick version. I used coingecko as their data is loaded via HTML, not JS so works just fine with Google Sheets, without needing to set up APIs etc.

I may do another API sheet or explain more about how to do this in Google Sheet.

For now, enjoy, just click here and make your own copy of the sheet. Need to manually reload the sheet, again this is a super basic version but figured might still be of use to some.

LINK


View attachment 172423


Could you please explain how to create this in Google sheet?

I'll add some more data related to some other coins in such a sheet.

Thanks
 
Top