Auto-build crypto coin research dossiers in Notion from Airtable

Whenever a new row is added to my Airtable Research Queue table, build a research dossier for the coin in that row and save it as a new page in my Notion Crypto Research database. Use the Airtable new record poll trigger so this runs automatically each time I drop a coin into the queue.

The new Airtable row has a column with the coin name and/or symbol. Take that value and resolve it to a CoinGecko coin id. Use CoinGecko Search first, and fall back to Coins Markets (which accepts names and symbols directly) if Search is ambiguous. If there is no confident top match, do not invent one.

Once you have the coin id, pull the data you need:

1. CoinGecko Get Coin by ID for project metadata, market cap rank, categories, top exchanges/tickers, developer activity, and community stats.

2. CoinGecko Market Chart for the last 90 days to characterise trend and volatility. Use that series to compute 24h, 7d, 30d, and 90d returns and to spot notable moves.

Then draft an analyst-style dossier with these sections:

- What this coin is: project description, categories, chains/contract addresses where relevant.

- Market position: market cap, rank, circulating supply, all-time-high and all-time-low context.

- Price behaviour: 24h, 7d, 30d, and 90d returns, volatility, and any standout moves in the 90d window.

- Exchange and liquidity coverage: top exchanges, trust scores, pair concentration.

- Developer and community signal: GitHub activity, social followers, sentiment indicators.

- What to watch next: a single forward-looking paragraph. No price predictions.

Write the dossier as a new page in my Notion Crypto Research database using Create a Page (set the page title to the coin name and symbol), then fill the body using Update Page Content as Markdown.

Finally, use Airtable Update Record on the original row to set a Notion URL field to the new Notion page link and a Status field to Research complete, so I can see at a glance which queue items have been processed.

If the coin cannot be resolved confidently (ambiguous symbol with no clear top match, or no CoinGecko coverage), do not create a Notion page. Instead, update the Airtable row's Status to Needs review with a short note explaining why.

Ask me up front for: the Airtable base id, the Research Queue table name, the names of the coin and status columns, the Notion Crypto Research database id, and which CoinGecko plan I am on (Demo vs Pro).

Additional information

What does this prompt do?

Watches your Airtable research queue. The moment you add a new coin, it kicks off automatically.
Pulls live market data, project background, exchange coverage, developer activity, and 90 days of price history for the coin.
Drafts an analyst-style dossier in Notion with sections for what the coin is, how it trades, and what to watch next.
Marks the original Airtable row as researched and links back to the finished Notion page.

What do I need to use this?

An Airtable base with a Research Queue table that has a coin name or symbol column and a status column
A CoinGecko API key (the free Demo plan works for everything this workflow needs)
A Notion workspace with a Crypto Research database connected to General Input

How can I customize it?

Change the lookback window from 90 days to 30, 7, or whatever range you care about for trend analysis.
Adjust the dossier sections. Add a competitors section, strip out developer stats, or insert your own scoring rubric.
Point at a different Airtable table or a different Notion database if you already have a research setup.

Frequently asked questions

Do I need a paid CoinGecko plan to run this?

No. The free Demo API key covers every piece of data this workflow uses, including coin metadata, exchanges, developer stats, and 90 days of price history.

What happens if the coin name in Airtable is ambiguous?

The agent resolves the name or symbol against CoinGecko's coin list. If there is no clear top match, it leaves a Needs review note on the Airtable row instead of guessing.

Will it ever research the same coin twice?

No. It only runs on newly added rows, and once it has marked a row Research complete, it leaves it alone on subsequent runs.

Can I use this for stocks or other assets?

Not directly. The workflow is built around CoinGecko, which only covers cryptocurrencies. For stocks you would swap in a different data source.

Can I change where the dossier is saved in Notion?

Yes. Point the agent at any Notion database that is shared with your General Input connection, and it will create new dossier pages there instead.