Tracking Your Crypto Portfolio in Airtable

This workflow enables seamless tracking of your cryptocurrency investments by automatically fetching current market prices from CoinGecko every hour and updating your Airtable base. It starts with a cron trigger at the top of each hour, retrieves your portfolio symbols from an Airtable 'Portfolio' table, queries CoinGecko for each coin's USD price, and then updates the records with the latest values including a 'Present Price' field.

Key benefits include real-time portfolio monitoring without manual intervention, reducing time spent on price checks and data entry. It provides a clear view of investment performance over time, with options to visualize gains/losses in Airtable views or dashboards. Users can copy the provided Airtable base template to get started quickly.

Ideal use cases: Personal investors managing crypto holdings, financial enthusiasts building dashboards, or teams tracking digital assets. Customize by adding more fields like market cap or historical data. Requires Airtable credentials and points to your base/application ID for easy setup.