Sync Coingecko API with Google Sheets to aid in live price monitoring for auctions

Set up Coingecko API with Google Sheets so that live prices can be updated within a cell.

Some docs for reference:
https://blog.coingecko.com/import-coingecko-cryptocurrency-data-into-google-sheets/

Grant Size: 1 Lightning OG

2 Likes

Please find the requested sheet attached. Let me know if you have any questions

Screen Shot 2022-04-20 at 6.07.07 PM
This is sweet. See NAs currently

Weird was working before. After looking into its a known issue with Coin Gecko API and Google Sheets.

Refactored to not use their API but rather import html on their pages.

Looks great. Please dm me wallet addy on discord and I will send the OG!

DM’d! Thank you very much! :slight_smile: