Update Crypto Values

Update Crypto Values automates the hourly retrieval of cryptocurrency prices from CoinGecko and updates your Airtable portfolio with the latest values. This workflow ensures your portfolio reflects real-time market data, helping you track your investments accurately and make informed decisions.

7/8/2025
8 nodes
Medium
schedulemediumcoingeckoairtableautomationcodecustom
Categories:
Manual TriggeredSimple WorkflowData Processing & AnalysisBusiness Process AutomationComplex WorkflowFinancial & AccountingSchedule TriggeredMedium Workflow
Integrations:
CoinGeckoAirtable

Target Audience

Target Audience


- Crypto Investors: Individuals managing a portfolio of cryptocurrencies who want to track real-time prices and portfolio values.
- Financial Analysts: Professionals requiring automated updates of cryptocurrency values for analysis and reporting.
- Developers: Those looking to integrate CoinGecko and Airtable for automated financial workflows.
- Small Business Owners: Entrepreneurs involved in cryptocurrency who need to monitor their investments efficiently.

Problem Solved

Problem Solved


This workflow addresses the challenge of manually tracking cryptocurrency prices and portfolio values. It automates the process of fetching real-time prices from CoinGecko and updating the respective values in Airtable, ensuring that investors have access to the most current information without the need for manual input. This reduces the risk of errors and saves time, allowing users to focus on strategic decisions.

Workflow Steps

Workflow Steps


1. Scheduled Trigger: The workflow is triggered every hour to ensure timely updates.
2. Get Portfolio: Retrieves the list of cryptocurrencies from the Airtable Portfolio table, specifically fetching the Symbol of each asset.
3. Fetch Prices: For each cryptocurrency symbol, the workflow calls CoinGecko to get the current market data, including the current price in USD.
4. Set Values: The workflow sets the fetched Present Price and the corresponding Id for each cryptocurrency.
5. Update Values: The current prices are updated back to the Airtable Portfolio table based on the Ids retrieved earlier.
6. Get Portfolio Values: The workflow retrieves the existing Present Value of the portfolio from Airtable.
7. Determine Total Value: A function node calculates the total portfolio value by summing up all the Present Value entries.
8. Append Portfolio Value: Finally, the total portfolio value is appended to the Airtable Portfolio Value table, allowing for historical tracking of the portfolio's worth.

Customization Guide

Customization Guide


- Change Trigger Frequency: Adjust the schedule in the Run Top of Hour node to run at different intervals (e.g., every 15 minutes or daily).
- Modify Portfolio Table: Update the Get Portfolio and Update Values nodes to point to a different table or fields if your Airtable structure changes.
- Add Additional Data: Enhance the Set node to include more data points from CoinGecko, such as market cap or trading volume, by modifying the parameters in the CoinGecko node.
- Custom Calculations: Modify the Determine Total Value function to include other calculations, such as average price or percentage changes, to suit your analysis needs.