Developer & DevOps
Fetch cryptocurrency prices and update Airtable automatically
8 nodes
295
138
Scheduled trigger
Workflow Description
Scheduled automation that retrieves live cryptocurrency prices from CoinGecko at set intervals and automatically updates Airtable tables with new data. Maintains continuous currency data without manual intervention or repetitive tasks.
How it works
- 1.Trigger the scheduled task at the specified time using Cron
- 2.Call CoinGecko API to fetch current cryptocurrency prices
- 3.Process and format the data for Airtable compatibility
- 4.Update Airtable records with the latest price information
Use cases
- Monitor cryptocurrency prices and build historical records in centralized tables
- Update price tracking dashboards without manual updates
- Create historical price datasets for crypto analysis and reporting
Requirements
- Active Airtable account with pre-configured database and tables
- Airtable API key with documentation of your tables and field names
- CoinGecko API access (free tier is sufficient)
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Coin Gecko
Airtable
Schedule
Details
Trigger
Scheduled trigger
Nodes
8
Apps
3
Views
295
Downloads
138
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (8)
CoinGecko
Coin Gecko
Get Portfolio
Airtable
Set
Set
Run Top of Hour
Cron
Get Portfolio Values
Airtable
Determine Total Value
Function
Update Values
Airtable
Append Portfolio Value
Airtable