n8n templatesn8n templates

Update Crypto Values

This workflow automates the retrieval and updating of the latest market prices for cryptocurrency portfolios, calculates the total value, and saves the data to Airtable. It runs automatically every hour, ensuring that users stay updated on asset dynamics in real time, while reducing the errors and burden associated with manual updates. By calling the CoinGecko API, the workflow effectively addresses the challenges posed by cryptocurrency price volatility, making it suitable for investors, financial analysts, and any teams or individuals managing crypto assets, thereby enhancing the efficiency and accuracy of data maintenance.

Workflow Diagram
Update Crypto Values Workflow diagram

Workflow Name

Update Crypto Values

Key Features and Highlights

This workflow automates the retrieval and updating of the latest market prices for each cryptocurrency in an investment portfolio, calculates the total portfolio value, and saves the data into an Airtable database. It is triggered on a schedule to run automatically every hour, ensuring that portfolio data is real-time and accurate, helping users conveniently and quickly monitor their asset dynamics.

Core Problems Addressed

Cryptocurrency prices fluctuate frequently, and manually updating portfolio prices is time-consuming and prone to errors. This workflow solves the issues of untimely data updates and heavy manual maintenance by automatically calling the CoinGecko market data API to fetch real-time prices and updating the portfolio information in Airtable accordingly.

Use Cases

  • Cryptocurrency investors and asset managers who need to track portfolio value in real time
  • Financial analysts automating the aggregation and analysis of digital asset data
  • Automated asset management platforms that require periodic market data refresh
  • Any teams or individuals managing cryptocurrency holdings data in Airtable

Main Workflow Steps

  1. Scheduled Trigger (Run Top of Hour): Automatically starts the workflow every hour.
  2. Get Portfolio: Retrieves the cryptocurrency symbols held from the “Portfolio” table in Airtable.
  3. Query Market Prices (CoinGecko): Calls the CoinGecko API using the crypto symbols to obtain current USD prices.
  4. Set Update Data: Constructs data containing the current prices and record IDs.
  5. Update Holdings Prices: Writes the latest prices back to the corresponding portfolio records in Airtable.
  6. Get Updated Portfolio Values: Reads the updated holding value fields from Airtable.
  7. Calculate Total Asset Value: Uses a custom function node to sum all holding values.
  8. Save Total Value: Appends the calculated total asset value to the “Portfolio Value” table in Airtable, creating a historical record.

Systems and Services Involved

  • CoinGecko API: Provides real-time market price data for cryptocurrencies
  • Airtable: Serves as the database for portfolio and asset value storage, maintaining holding details and update results
  • n8n Scheduled Trigger: Enables automatic hourly execution to ensure data timeliness

Target Users and Value

  • Cryptocurrency investors and asset managers, helping them monitor asset price fluctuations in real time and optimize investment decisions
  • Finance teams and analysts, automating digital asset data collection and aggregation to improve work efficiency
  • Any users relying on Airtable for managing crypto asset data, simplifying data maintenance and reducing human errors
  • Automation enthusiasts leveraging n8n to integrate multiple systems for intelligent asset data updating and management

This workflow automates complex market data fetching, updating, and aggregation, enabling intelligent management of cryptocurrency portfolios. It saves users significant time while enhancing the accuracy and efficiency of asset monitoring.