Coingecko Price Sync Demo

Prices Sync Table

Explore

How To Use

API Setup

Setup Coingecko API Account

Go to

https://www.coingecko.com/en/developers/dashboard⁠

⁠

If your not signed in - sign in to or create a coingecko account then follow the link again.

If you haven’t set up the API before you’ll get re-directed to the pricing page.

Click “Create Free Account” at the bottom.

⁠

Screenshot 2024-12-31 at 11.10.56 PM.png

⁠

Create API Key

After you create you’re account you’ll see your Coingecko

Developer Dashboard⁠

⁠

Click “Add New Key” and give it a name

⁠

Screenshot 2024-12-31 at 11.13.49 PM.png

⁠

Copy your API-Key for later (this one is deleted)

⁠

Screenshot 2024-12-31 at 11.16.34 PM.png

⁠

Price Sync Setup

1. Add the Sync Table to Your Doc

Click “Insert” at the top right of your Coda Doc

⁠

Screenshot 2024-12-31 at 11.21.26 PM.png

⁠

Navigate to the Packs tab

⁠

Screenshot 2024-12-31 at 11.22.13 PM.png

⁠

Open the Coingecko Cryptocurrency Price Sync pack under “Installed Packs”

⁠

Screenshot 2024-12-31 at 11.23.10 PM.png

⁠

Under the “Building Blocks” tab, drag and drop the “Token_ prices” table onto a page in your Coda Doc

⁠

Screenshot 2024-12-31 at 11.24.43 PM.png

⁠

2. Hook up the API to the Table

Click on “Connect an account” on your table OR go to the pack settings tab and click “Add a shared account”

⁠

Screenshot 2024-12-31 at 11.25.41 PM.png

⁠

Screenshot 2024-12-31 at 11.27.15 PM.png

⁠

Put your API key in to the box that pops up

⁠

Token List Setup

1. Create a Tokens Table

This will tell your price sync table what cryptocurrencies to get

Example Tokens Table

Example Tokens Table

Token

Coingecko Id

BTC

bitcoin

ETH

ethereum

SOL

solana

DOGE

dogecoin

There are no rows in this table

⁠

2. Open Settings to Link your Table to the Sync Table

Open the sync table settings or click “Choose what to sync” on the sync table

⁠

Screenshot 2024-12-31 at 11.35.03 PM.png

⁠

Screenshot 2024-12-31 at 11.34.29 PM.png

⁠

3. Populate the Fields in Settings

In the Tickers field, press = to start entering a formula

The formula should be myTokenTable.tokenColumn

⁠

Screenshot 2024-12-31 at 11.38.20 PM.png

⁠

In the Ids field, press = to start entering a formula

The formula should be myTokenTable.CoingeckoIdsColumn

⁠

Screenshot 2024-12-31 at 11.38.25 PM.png

⁠

4. Your Done - Just Click Refresh on the Table

5. Bonus - Add More Buttons to Sync

Right click this button to see details

⁠

Refresh Pack table

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.