⚡ Only 300 spots remaining • Closes in 2d 14h 32m
⚡ Only 300 spots remaining • Closes in 2d 14h 32m
This comprehensive workflow automation helps you streamline Update Crypto Values processes. By using this blueprint, you can eliminate manual data entry and ensure seamless integration between your favorite platforms.
This workflow is pre-configured and ready for deployment. Simply import the JSON template into your n8n instance and configure your credentials.
This is an exclusive blueprint. Copy the JSON below to use it.
PRO TIP
Always test your workflow in a development environment before pushing to production.
{
"id": "14",
"name": "Update Crypto Values",
"nodes": [
{
"name": "CoinGecko",
"type": "n8n-nodes-base.coinGecko",
"position": [
670,
400
],
"parameters": {
"coinId": "={{$json[\"fields\"][\"Symbol\"]}}",
"options": {
"market_data": true,
"localization": false
},
"operation": "get"
},
"typeVersion": 1
},
{
"name": "Get Portfolio",
"type": "n8n-nodes-base.airtable",
"position": [
450,
400
],
"parameters": {
"table": "Portfolio",
"operation": "list",
"application": "appT7eX4iZcZVRIdq",
"additionalOptions": {
"fields": [
"Symbol"
]
}
},
"credentials": {
"airtableApi": "Airtable"
},
"typeVersion": 1
},
{
"name": "Set",
"type": "n8n-nodes-base.set",
"position": [
870,
400
],
"parameters": {
"values": {
"string": [
{
"name": "Present Price",
"value": "={{$json[\"market_data\"][\"current_price\"][\"usd\"]}}"
},
{
"name": "Id",
"value": "={{$node[\"Get Portfolio\"].json[\"id\"]}}"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 1
},
{
"name": "Run Top of Hour",
"type": "n8n-nodes-base.cron",
"position": [
240,
400
],
"parameters": {
"triggerTimes": {
"item": [
{
"mode": "everyHour"
}
]
}
},
"typeVersion": 1
},
{
"name": "Get Portfolio Values",
"type": "n8n-nodes-base.airtable",
"position": [
1260,
400
],
"parameters": {
"table": "Portfolio",
"operation": "list",
"application": "appT7eX4iZcZVRIdq",
"additionalOptions": {
"fields": [
"Present Value"
]
}
},
"credentials": {
"airtableApi": "Airtable"
},
"typeVersion": 1
},
{
"name": "Determine Total Value",
"type": "n8n-nodes-base.function",
"position": [
1460,
400
],
"parameters": {
"functionCode": "var totalValues = 0;\n\nitems.forEach(sumValues);\n\nfunction sumValues(value, index, array) {\n totalValues = totalValues + value.json.fields['Present Value'];\n}\n\nitems = [{\"json\": {}}];\n\n\nitems[0].json['Portfolio Value (US$)'] = totalValues;\n\nreturn items;"
},
"typeVersion": 1
},
{
"name": "Update Values",
"type": "n8n-nodes-base.airtable",
"position": [
1070,
400
],
"parameters": {
"id": "={{$node[\"SplitInBatches\"].json[\"id\"]}}",
"table": "Portfolio",
"fields": [
"Present Price"
],
"options": {},
"operation": "update",
"application": "appT7eX4iZcZVRIdq",
"updateAllFields": false
},
"credentials": {
"airtableApi": "Airtable"
},
"typeVersion": 1
},
{
"name": "Append Portfolio Value",
"type": "n8n-nodes-base.airtable",
"position": [
1660,
400
],
"parameters": {
"table": "Portfolio Value",
"fields": [
"Portfolio Value (US$)"
],
"options": {},
"operation": "append",
"application": "appT7eX4iZcZVRIdq",
"addAllFields": false
},
"credentials": {
"airtableApi": "Airtable"
},
"typeVersion": 1
}
],
"active": false,
"settings": {},
"connections": {
"Set": {
"main": [
[
{
"node": "Update Values",
"type": "main",
"index": 0
}
]
]
},
"CoinGecko": {
"main": [
[
{
"node": "Set",
"type": "main",
"index": 0
}
]
]
},
"Get Portfolio": {
"main": [
[
{
"node": "CoinGecko",
"type": "main",
"index": 0
}
]
]
},
"Update Values": {
"main": [
[
{
"node": "Get Portfolio Values",
"type": "main",
"index": 0
}
]
]
},
"Run Top of Hour": {
"main": [
[
{
"node": "Get Portfolio",
"type": "main",
"index": 0
}
]
]
},
"Get Portfolio Values": {
"main": [
[
{
"node": "Determine Total Value",
"type": "main",
"index": 0
}
]
]
},
"Determine Total Value": {
"main": [
[
{
"node": "Append Portfolio Value",
"type": "main",
"index": 0
}
]
]
}
}
}To use this, copy the JSON above and paste it directly onto your n8n canvas.
Join the elite marketers who have offloaded their entire backend to n8n. Get direct support and custom builds in our private forum.