Tracking your crypto portfolio in Airtable
Needs changesNeeds changes. This template uses 2 thing(s) that n8n 3.0 removes: Cron, Function (legacy). 2 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 8 nodes and runs on a schedule (legacy Cron node). Along the way it connects CoinGecko and Airtable.
How it runs
Trigger: On a schedule (legacy Cron node).
- Get Portfolio (Airtable): list
- CoinGecko: get
- Set (Edit Fields (Set)): sets or maps fields
- Update Values (Airtable): update
- Get Portfolio Values (Airtable): list
- Determine Total Value (Function): runs custom JavaScript (legacy Function node)
- Append Portfolio Value (Airtable): append
Services it uses
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Cron in Run Top of Hour: replace with Schedule Trigger.
- Function (legacy) in Determine Total Value: replace with Code node, mode 'Run Once for All Items'.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Run Top of Hour | Schedule Trigger |
| Function (legacy) Determine Total Value | Code node, mode 'Run Once for All Items' |
Nodes used (5)
- CoinGecko
n8n-nodes-base.coinGecko - Airtable
n8n-nodes-base.airtable - Edit Fields (Set)
n8n-nodes-base.set - Cron
n8n-nodes-base.cron - Function
n8n-nodes-base.function
From the author
If you have made some investments in cryptocurrency, this workflow will allow you to create an Airtable base that will update the value of your portfolio every hour. You can then track how well your investments are doing. You can check out my Airtable base to…