バイナンス API と Airtable を用いて暗号資産のファンダイングレートを自動追跡
上級
これはFinance分野の自動化ワークフローで、31個のノードを含みます。主にIf, Set, Crypto, Airtable, SplitOutなどのノードを使用。 ビンアンスAPIとAirtableを使ってコインの資金费率を自動追跡
前提条件
- •Airtable API Key
- •ターゲットAPIの認証情報が必要な場合あり
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "6a2a7715680b8313f7cb4676321c5baa46680adfb913072f089f2766f42e43bd",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "a3ff8cdd-1dc7-4e0a-96af-ab07ee318ddb",
"name": "Crypto2",
"type": "n8n-nodes-base.crypto",
"position": [
940,
-60
],
"parameters": {
"type": "SHA256",
"value": "=recvWindow={{20000}}×tamp={{ $json.timestamp }}",
"action": "hmac",
"secret": "pTFNHpnsm4gjz2au6nTCeu9UYgCfFNI1vgVOHLyHQAKUDKwdlVrYuCWXmrAcurYs",
"dataPropertyName": "secretKey"
},
"typeVersion": 1
},
{
"id": "860de117-0305-4c73-917b-f62be016ea4c",
"name": "フィールドを編集1",
"type": "n8n-nodes-base.set",
"position": [
760,
-60
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "19bd2a16-442e-416a-a28a-63d4050f4559",
"name": "timestamp",
"type": "string",
"value": "={{$now.format('x')}}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "dd682d40-aa6a-4177-8c2a-2f7075e2a43e",
"name": "フィールドを編集2",
"type": "n8n-nodes-base.set",
"position": [
1820,
-60
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "918722a0-4a14-4ed4-b18a-b37c401807ec",
"name": "data",
"type": "array",
"value": "={{ \n $('Aggregate Fees').item.json.data.map(fee => {\n const position = $('Aggregate Positions').item.json.data.find(pos => pos.symbol === fee.symbol) || {};\n const token = $('Aggregate Tokens').last().json.data.find(tok => tok.name === fee.symbol) || {};\n\n return {\n symbol: fee.symbol,\n income: fee.income,\n asset: fee.asset,\n time: fee.time,\n tranId: fee.tranId,\n positionAmt: position.positionAmt || \"0\",\n markPrice: position.markPrice || \"0.00000000\",\n liquidationPrice: position.liquidationPrice || \"0\",\n tokenId: token.id || null // Get ID from Get Tokens, or null if not found\n };\n })\n}}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "4c6d65ae-1174-495e-8052-f4b998ee001d",
"name": "Split Out",
"type": "n8n-nodes-base.splitOut",
"position": [
2020,
-60
],
"parameters": {
"options": {},
"fieldToSplitOut": "data"
},
"typeVersion": 1
},
{
"id": "a5dd73dc-18fe-400b-beaf-21a83211899f",
"name": "ポジションを取得",
"type": "n8n-nodes-base.httpRequest",
"position": [
1120,
-60
],
"parameters": {
"url": "https://fapi.binance.com/fapi/v2/positionRisk",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "recvWindow",
"value": "={{20000}}"
},
{
"name": "timestamp",
"value": "={{ $('Edit Fields1').item.json.timestamp }}"
},
{
"name": "signature",
"value": "={{ $json.secretKey }}"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "nHwfIXHEwCxK80VF",
"name": "Snezar Loxo"
}
},
"typeVersion": 4.2
},
{
"id": "491841fe-c173-4644-bf02-d43425f3b10e",
"name": "ポジションを集計",
"type": "n8n-nodes-base.aggregate",
"position": [
1320,
-60
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "90a1818d-a933-4770-997d-2a0692141192",
"name": "手数料を集計",
"type": "n8n-nodes-base.aggregate",
"position": [
580,
-60
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "39ee87a4-18eb-43f4-8489-ae16797492d6",
"name": "トークンを取得",
"type": "n8n-nodes-base.airtable",
"position": [
1480,
-60
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "app2uc5OOFJdg2weo",
"cachedResultUrl": "https://airtable.com/app2uc5OOFJdg2weo",
"cachedResultName": "Binance demo"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbl8SLbJIGFe12VOR",
"cachedResultUrl": "https://airtable.com/app2uc5OOFJdg2weo/tbl8SLbJIGFe12VOR",
"cachedResultName": "Tokens"
},
"options": {},
"operation": "search"
},
"credentials": {
"airtableTokenApi": {
"id": "xZwG0YpqsxpWrzVM",
"name": "Mark Airtable account"
}
},
"typeVersion": 2.1
},
{
"id": "368b3bac-d0c1-435f-af34-377a893ba0b5",
"name": "トークンを集計",
"type": "n8n-nodes-base.aggregate",
"position": [
1660,
-60
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "e2af8b4d-901f-4115-8704-55ba26e32a3c",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"disabled": true,
"position": [
-180,
-60
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "3 1,9,17 * * *"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "0795a6bc-1c4a-4a42-a446-8a4b57e8d7d9",
"name": "Crypto",
"type": "n8n-nodes-base.crypto",
"position": [
40,
-440
],
"parameters": {
"type": "SHA256",
"value": "=symbol=LTCBTC&side=BUY&type=LIMIT&timeInForce=GTC&quantity=1&price=0.1&recvWindow=5000×tamp=1499827319559",
"action": "hmac",
"secret": "NhqPtmdSJYdKjVHjA7PZj4Mge3R5YNiP1e3UZjInClVN65XAbvqqM6A7H5fATj0j",
"dataPropertyName": "signature"
},
"typeVersion": 1
},
{
"id": "006b141f-f27f-4099-ba9f-78f6d02a74c6",
"name": "Schedule Trigger1",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-200,
440
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 4
}
]
}
},
"typeVersion": 1.2
},
{
"id": "721dfce3-d076-415d-b69c-982e633e4f86",
"name": "トークンを取得1",
"type": "n8n-nodes-base.airtable",
"position": [
0,
440
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "app2uc5OOFJdg2weo",
"cachedResultUrl": "https://airtable.com/app2uc5OOFJdg2weo",
"cachedResultName": "Binance demo"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbl8SLbJIGFe12VOR",
"cachedResultUrl": "https://airtable.com/app2uc5OOFJdg2weo/tbl8SLbJIGFe12VOR",
"cachedResultName": "Tokens"
},
"options": {},
"operation": "search"
},
"credentials": {
"airtableTokenApi": {
"id": "xZwG0YpqsxpWrzVM",
"name": "Mark Airtable account"
}
},
"typeVersion": 2.1
},
{
"id": "edfc1dd2-4ce3-4b42-8abc-6bfe50fc38ec",
"name": "Update Token Prices1",
"type": "n8n-nodes-base.airtable",
"position": [
460,
420
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "app2uc5OOFJdg2weo",
"cachedResultUrl": "https://airtable.com/app2uc5OOFJdg2weo",
"cachedResultName": "Binance demo"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbl8SLbJIGFe12VOR",
"cachedResultUrl": "https://airtable.com/app2uc5OOFJdg2weo/tbl8SLbJIGFe12VOR",
"cachedResultName": "Tokens"
},
"columns": {
"value": {
"id": "={{ $('Get Tokens1').item.json.id }}",
"price": "={{ $json.price }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "price",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "price",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Funding Statement",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Funding Statement",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"id": "xZwG0YpqsxpWrzVM",
"name": "Mark Airtable account"
}
},
"typeVersion": 2.1
},
{
"id": "4f1d25cc-b79c-407e-a62c-92e4019ef974",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-260,
300
],
"parameters": {
"width": 1000,
"height": 340,
"content": "### Scenario 2 - update tokens price"
},
"typeVersion": 1
},
{
"id": "ba0bc917-c61f-42cd-ac53-1c9028554910",
"name": "価格を取得",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
220,
440
],
"parameters": {
"url": "=https://api.binance.com/api/v3/ticker/price?symbol={{ $json.name }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "0dbf2475-0012-4c4c-9b33-900ae3ab8285",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-260,
-200
],
"parameters": {
"width": 3080,
"height": 420,
"content": "### Scenario 1 - Add funding fees"
},
"typeVersion": 1
},
{
"id": "28415862-ff31-4b23-83ab-3af1f35b4435",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
2200,
-60
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "46231f93-5e8a-4f8f-8dab-18c70f3d22a2",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.tokenId }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "a54f5d41-d240-49dd-8827-8cbe125ec828",
"name": "トークンを作成",
"type": "n8n-nodes-base.airtable",
"position": [
2380,
40
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "app2uc5OOFJdg2weo",
"cachedResultUrl": "https://airtable.com/app2uc5OOFJdg2weo",
"cachedResultName": "Binance demo"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbl8SLbJIGFe12VOR",
"cachedResultUrl": "https://airtable.com/app2uc5OOFJdg2weo/tbl8SLbJIGFe12VOR",
"cachedResultName": "Tokens"
},
"columns": {
"value": {
"name": "={{ $json.symbol }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "price",
"type": "number",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "price",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Funding Statement",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Funding Statement",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "xZwG0YpqsxpWrzVM",
"name": "Mark Airtable account"
}
},
"typeVersion": 2.1
},
{
"id": "4f4e1eb4-23ea-4f98-8b31-2b2136da15dc",
"name": "ステートメントを作成",
"type": "n8n-nodes-base.airtable",
"position": [
2440,
-120
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "app2uc5OOFJdg2weo",
"cachedResultUrl": "https://airtable.com/app2uc5OOFJdg2weo",
"cachedResultName": "Binance demo"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblrHB0L42whQF6HM",
"cachedResultUrl": "https://airtable.com/app2uc5OOFJdg2weo/tblrHB0L42whQF6HM",
"cachedResultName": "Funding Statement"
},
"columns": {
"value": {
"time": "={{ $json.time.toDateTime('ms') }}",
"asset": "={{ $json.asset }}",
"token": "={{ [$json.tokenId]}}",
"amount": "={{ $json.income }}",
"markPrice": "={{ $json.markPrice }}",
"positionSize": "={{ $json.positionAmt }}",
"liquidationPrice": "={{ $json.liquidationPrice }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "time",
"type": "dateTime",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "token",
"type": "array",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "token",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "asset",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "asset",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "amount",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "amount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "positionSize",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "positionSize",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "annualizedYield",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "annualizedYield",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "liquidationPrice",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "liquidationPrice",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "markPrice",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "markPrice",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "xZwG0YpqsxpWrzVM",
"name": "Mark Airtable account"
}
},
"typeVersion": 2.1
},
{
"id": "ea7f6c61-065f-41a0-87e5-46575612c815",
"name": "ステートメントを作成1",
"type": "n8n-nodes-base.airtable",
"position": [
2560,
40
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "app2uc5OOFJdg2weo",
"cachedResultUrl": "https://airtable.com/app2uc5OOFJdg2weo",
"cachedResultName": "Binance demo"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblrHB0L42whQF6HM",
"cachedResultUrl": "https://airtable.com/app2uc5OOFJdg2weo/tblrHB0L42whQF6HM",
"cachedResultName": "Funding Statement"
},
"columns": {
"value": {
"time": "={{ $('If').item.json.time.toDateTime('ms') }}",
"asset": "={{ $('If').item.json.asset }}",
"token": "={{ [$json.id]}}",
"amount": "={{ $('If').item.json.income }}",
"markPrice": "={{ $('If').item.json.markPrice }}",
"positionSize": "={{ $('If').item.json.positionAmt }}",
"liquidationPrice": "={{ $('If').item.json.liquidationPrice }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "time",
"type": "dateTime",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "token",
"type": "array",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "token",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "asset",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "asset",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "amount",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "amount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "positionSize",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "positionSize",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "annualizedYield",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "annualizedYield",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "liquidationPrice",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "liquidationPrice",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "markPrice",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "markPrice",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "xZwG0YpqsxpWrzVM",
"name": "Mark Airtable account"
}
},
"typeVersion": 2.1
},
{
"id": "c63b2d49-8421-41d4-94d3-331775d15436",
"name": "Crypto3",
"type": "n8n-nodes-base.crypto",
"position": [
220,
-60
],
"parameters": {
"type": "SHA256",
"value": "=recvWindow={{20000}}×tamp={{ $json.timestamp }}&incomeType=FUNDING_FEE&startTime={{ $json.startTime }}",
"action": "hmac",
"secret": "pTFNHpnsm4gjz2au6nTCeu9UYgCfFNI1vgVOHLyHQAKUDKwdlVrYuCWXmrAcurYs",
"dataPropertyName": "secretKey"
},
"typeVersion": 1
},
{
"id": "501feb0f-231e-4ac6-872e-3b07861a4b45",
"name": "フィールドを編集4",
"type": "n8n-nodes-base.set",
"position": [
40,
-60
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "19bd2a16-442e-416a-a28a-63d4050f4559",
"name": "timestamp",
"type": "string",
"value": "={{$now.format('x')}}"
},
{
"id": "8766d7bb-63d7-4c9f-8319-bf5a1083781f",
"name": "startTime",
"type": "string",
"value": "={{ $now.minus(8,'hours').format('x') }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "eb371433-5c67-4be2-bf61-c819c085afcf",
"name": "手数料を取得2",
"type": "n8n-nodes-base.httpRequest",
"position": [
400,
-60
],
"parameters": {
"url": "https://fapi.binance.com/fapi/v1/income",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "recvWindow",
"value": "={{20000}}"
},
{
"name": "timestamp",
"value": "={{ $('Edit Fields4').item.json.timestamp }}"
},
{
"name": "signature",
"value": "={{ $json.secretKey }}"
},
{
"name": "incomeType",
"value": "FUNDING_FEE"
},
{
"name": "startTime",
"value": "={{ $('Edit Fields4').item.json.startTime }}"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "nHwfIXHEwCxK80VF",
"name": "Snezar Loxo"
}
},
"typeVersion": 4.2
},
{
"id": "833d6652-4d44-4a39-8e72-e3fa9a7b5cc8",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
360,
-180
],
"parameters": {
"color": 5,
"width": 200,
"height": 80,
"content": "### Replace Header Auth\nX-MBX-APIKEY=<your_api_key>"
},
"typeVersion": 1
},
{
"id": "989a1208-2457-4a85-a409-f00442b629a2",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
120
],
"parameters": {
"color": 5,
"width": 160,
"height": 80,
"content": "### Replace Secret"
},
"typeVersion": 1
},
{
"id": "3c187a46-0760-400a-affa-2e3f1f9499e3",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
900,
120
],
"parameters": {
"color": 5,
"width": 160,
"height": 80,
"content": "### Replace Secret"
},
"typeVersion": 1
},
{
"id": "626481c1-f4a4-44ca-a7f0-32da29dfc0c9",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1080,
-180
],
"parameters": {
"color": 5,
"width": 200,
"height": 80,
"content": "### Replace Header Auth\nX-MBX-APIKEY=<your_api_key>"
},
"typeVersion": 1
},
{
"id": "a1c7b2df-c5bd-493a-b63e-6ecad817c7cd",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-260,
-560
],
"parameters": {
"width": 780,
"height": 320,
"content": "### Example"
},
"typeVersion": 1
},
{
"id": "8ca604f7-214a-40fa-9d9a-4b93a2643d09",
"name": "Binance - Get Fees",
"type": "n8n-nodes-base.httpRequest",
"position": [
240,
-440
],
"parameters": {
"url": "https://api.binance.com/api/v3/order",
"method": "POST",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "symbol",
"value": "=LTCBTC"
},
{
"name": "side",
"value": "=BUY"
},
{
"name": "signature",
"value": "={{ $json.signature }}"
},
{
"name": "type",
"value": "LIMIT"
},
{
"name": "timeInForce",
"value": "=GTC"
},
{
"name": "quantity",
"value": "1"
},
{
"name": "price",
"value": "0.1"
},
{
"name": "recvWindow",
"value": "5000"
},
{
"name": "timestamp",
"value": "1499827319559"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "X-MBX-APIKEY",
"value": "vmPUZE6mv9SD5VNHk4HlWFsOr6aKE2zvsw0MuIgwCIPy6utIco14y7Ju91duEh8A"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "nHwfIXHEwCxK80VF",
"name": "Snezar Loxo"
}
},
"typeVersion": 4.2
},
{
"id": "4ca9b631-24e3-4235-b2d2-ccfde43c6e72",
"name": "Set Variables",
"type": "n8n-nodes-base.set",
"position": [
-140,
-440
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "19bd2a16-442e-416a-a28a-63d4050f4559",
"name": "timestamp",
"type": "string",
"value": "={{$now.format('x')}}"
}
]
}
},
"typeVersion": 3.4
}
],
"pinData": {
"Get Fees2": [
{
"info": "FUNDING_FEE",
"time": 1747353601000,
"asset": "USDT",
"income": "0.62124647",
"symbol": "SOLUSDT",
"tranId": 755481401373412200,
"tradeId": "",
"incomeType": "FUNDING_FEE"
}
],
"Get Positions": [
{
"symbol": "SNTUSDT",
"isolated": false,
"leverage": "5",
"notional": "0",
"markPrice": "0.00000000",
"entryPrice": "0.0",
"marginType": "cross",
"updateTime": 0,
"adlQuantile": 0,
"positionAmt": "0",
"positionSide": "BOTH",
"breakEvenPrice": "0.0",
"isolatedMargin": "0.00000000",
"isolatedWallet": "0",
"isAutoAddMargin": "false",
"liquidationPrice": "0",
"maxNotionalValue": "200000",
"unRealizedProfit": "0.00000000"
},
{
"symbol": "SUSHIUSDT",
"isolated": false,
"leverage": "5",
"notional": "0",
"markPrice": "0.00000000",
"entryPrice": "0.0",
"marginType": "cross",
"updateTime": 0,
"adlQuantile": 0,
"positionAmt": "0",
"positionSide": "BOTH",
"breakEvenPrice": "0.0",
"isolatedMargin": "0.00000000",
"isolatedWallet": "0",
"isAutoAddMargin": "false",
"liquidationPrice": "0",
"maxNotionalValue": "1600000",
"unRealizedProfit": "0.00000000"
},
{
"symbol": "CGPTUSDT",
"isolated": false,
"leverage": "5",
"notional": "0",
"markPrice": "0.00000000",
"entryPrice": "0.0",
"marginType": "cross",
"updateTime": 0,
"adlQuantile": 0,
"positionAmt": "0",
"positionSide": "BOTH",
"breakEvenPrice": "0.0",
"isolatedMargin": "0.00000000",
"isolatedWallet": "0",
"isAutoAddMargin": "false",
"liquidationPrice": "0",
"maxNotionalValue": "250000",
"unRealizedProfit": "0.00000000"
},
{
"symbol": "SOLUSDT",
"isolated": true,
"leverage": "5",
"notional": "41118.75",
"markPrice": "182.75",
"entryPrice": "176.20",
"marginType": "isolated",
"updateTime": 1747353601416,
"adlQuantile": 3,
"positionAmt": "225.00",
"positionSide": "BOTH",
"breakEvenPrice": "176.25",
"isolatedMargin": "13688.00",
"isolatedWallet": "12950.75",
"isAutoAddMargin": "false",
"liquidationPrice": "142.98",
"maxNotionalValue": "80000000",
"unRealizedProfit": "1471.25"
}
]
},
"connections": {
"28415862-ff31-4b23-83ab-3af1f35b4435": {
"main": [
[
{
"node": "4f4e1eb4-23ea-4f98-8b31-2b2136da15dc",
"type": "main",
"index": 0
}
],
[
{
"node": "a54f5d41-d240-49dd-8827-8cbe125ec828",
"type": "main",
"index": 0
}
]
]
},
"0795a6bc-1c4a-4a42-a446-8a4b57e8d7d9": {
"main": [
[
{
"node": "8ca604f7-214a-40fa-9d9a-4b93a2643d09",
"type": "main",
"index": 0
}
]
]
},
"a3ff8cdd-1dc7-4e0a-96af-ab07ee318ddb": {
"main": [
[
{
"node": "a5dd73dc-18fe-400b-beaf-21a83211899f",
"type": "main",
"index": 0
}
]
]
},
"c63b2d49-8421-41d4-94d3-331775d15436": {
"main": [
[
{
"node": "eb371433-5c67-4be2-bf61-c819c085afcf",
"type": "main",
"index": 0
}
]
]
},
"eb371433-5c67-4be2-bf61-c819c085afcf": {
"main": [
[
{
"node": "90a1818d-a933-4770-997d-2a0692141192",
"type": "main",
"index": 0
}
]
]
},
"ba0bc917-c61f-42cd-ac53-1c9028554910": {
"main": [
[
{
"node": "edfc1dd2-4ce3-4b42-8abc-6bfe50fc38ec",
"type": "main",
"index": 0
}
]
]
},
"4c6d65ae-1174-495e-8052-f4b998ee001d": {
"main": [
[
{
"node": "28415862-ff31-4b23-83ab-3af1f35b4435",
"type": "main",
"index": 0
}
]
]
},
"39ee87a4-18eb-43f4-8489-ae16797492d6": {
"main": [
[
{
"node": "368b3bac-d0c1-435f-af34-377a893ba0b5",
"type": "main",
"index": 0
}
]
]
},
"721dfce3-d076-415d-b69c-982e633e4f86": {
"main": [
[
{
"node": "ba0bc917-c61f-42cd-ac53-1c9028554910",
"type": "main",
"index": 0
}
]
]
},
"a54f5d41-d240-49dd-8827-8cbe125ec828": {
"main": [
[
{
"node": "ea7f6c61-065f-41a0-87e5-46575612c815",
"type": "main",
"index": 0
}
]
]
},
"860de117-0305-4c73-917b-f62be016ea4c": {
"main": [
[
{
"node": "a3ff8cdd-1dc7-4e0a-96af-ab07ee318ddb",
"type": "main",
"index": 0
}
]
]
},
"dd682d40-aa6a-4177-8c2a-2f7075e2a43e": {
"main": [
[
{
"node": "4c6d65ae-1174-495e-8052-f4b998ee001d",
"type": "main",
"index": 0
}
]
]
},
"501feb0f-231e-4ac6-872e-3b07861a4b45": {
"main": [
[
{
"node": "c63b2d49-8421-41d4-94d3-331775d15436",
"type": "main",
"index": 0
}
]
]
},
"a5dd73dc-18fe-400b-beaf-21a83211899f": {
"main": [
[
{
"node": "491841fe-c173-4644-bf02-d43425f3b10e",
"type": "main",
"index": 0
}
]
]
},
"4ca9b631-24e3-4235-b2d2-ccfde43c6e72": {
"main": [
[
{
"node": "0795a6bc-1c4a-4a42-a446-8a4b57e8d7d9",
"type": "main",
"index": 0
}
]
]
},
"90a1818d-a933-4770-997d-2a0692141192": {
"main": [
[
{
"node": "860de117-0305-4c73-917b-f62be016ea4c",
"type": "main",
"index": 0
}
]
]
},
"368b3bac-d0c1-435f-af34-377a893ba0b5": {
"main": [
[
{
"node": "dd682d40-aa6a-4177-8c2a-2f7075e2a43e",
"type": "main",
"index": 0
}
]
]
},
"e2af8b4d-901f-4115-8704-55ba26e32a3c": {
"main": [
[
{
"node": "501feb0f-231e-4ac6-872e-3b07861a4b45",
"type": "main",
"index": 0
}
]
]
},
"006b141f-f27f-4099-ba9f-78f6d02a74c6": {
"main": [
[
{
"node": "721dfce3-d076-415d-b69c-982e633e4f86",
"type": "main",
"index": 0
}
]
]
},
"491841fe-c173-4644-bf02-d43425f3b10e": {
"main": [
[
{
"node": "39ee87a4-18eb-43f4-8489-ae16797492d6",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 財務
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
ChatGPTとAirtableの対話やデータ分析のAIアシスタント
Airtableと対話しながらデータを分析するAIアシスタント
If
Set
Merge
+
If
Set
Merge
41 ノードMark Shcherbakov
エンジニアリング
コンテンツジェネレーター v3
AI驱动ブログ自動化：使用GPT-4生成并公開SEO記事至WordPressとTwitter
If
Set
Code
+
If
Set
Code
144 ノードJay Emp0
コンテンツ作成
Airtable、OpenAI、Unipile を使用した LinkedIn リード生成と自動ダイレクトメッセージングの自動化
Airtable、OpenAI、Unipileを使用した自動LinkedInリード生成とInMail投稿
If
Set
Code
+
If
Set
Code
143 ノードRuben AI
リードナーチャリング
コンテンツジェネレータ v4
コンテンツファームv4 - ChatGPT 5とGeminiを使用したWordPressブログの自動化
If
Set
Code
+
If
Set
Code
168 ノードJay Emp0
ペットショップ 4
ペットショップ予約AIエージェント
If
Set
Code
+
If
Set
Code
187 ノードBruno Dias
人工知能
デリバリー ハンバーガーショップ MVP
🤖 レストランと配送の自動化を支援するAI駆動型WhatsAppアシスタント
If
Set
Code
+
If
Set
Code
152 ノードBruno Dias
ワークフロー情報
難易度
上級
ノード数31
カテゴリー1
ノードタイプ9
作成者
Mark Shcherbakov
@lowcodingdevI am a business analyst with a development background, dedicated to helping small businesses and entrepreneurs leverage cloud services for increased efficiency. My expertise lies in automating manual workflows, integrating data from multiple cloud service providers, creating insightful dashboards, and building custom CRM systems. https://www.linkedin.com/in/marklowcoding/
外部リンク
n8n.ioで表示 →
このワークフローを共有