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).