Update Crypto Values

Name: Update Crypto Values
Rating: 5.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

36 views

0 downloads

Data ManagementAirtableCoinGeckoautomationcryptocurrencyportfolio

Fetches current cryptocurrency prices from CoinGecko and updates portfolio values in Airtable.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow automates the process of updating cryptocurrency prices. It retrieves cryptocurrency symbols from an Airtable base, fetches their current prices using the CoinGecko API, and then updates these prices within the Airtable portfolio. Finally, it calculates and appends the total portfolio value to a separate Airtable table.

Key Features

Scheduled execution using Cron.
Dynamic retrieval of coin symbols from Airtable.
Real-time price fetching via CoinGecko API.
Updating individual crypto prices in Airtable.
Calculating and logging total portfolio value.
Error handling for workflow execution.

How To Use

Import the workflow: Save the JSON and import it into your n8n instance.
Configure Airtable credentials: Ensure your Airtable API key and Application ID are correctly set up in n8n.
Set Cron schedule: Adjust the Run Top of Hour node to your desired execution frequency.
Verify Airtable tables: Make sure the Portfolio and Portfolio Value tables exist in your Airtable base with the expected fields (Symbol, Present Price, Present Value, Portfolio Value (US$)).

Apps Used

Airtable

CoinGecko

automation

cryptocurrency

portfolio

Workflow JSON

{
  "id": "27345bdc-36a8-41ce-b3e6-f41085de5a49",
  "name": "Update Crypto Values",
  "nodes": 0,
  "category": "Data Management",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.