💰 使用Google表格和ExchangeRate API自动更新发票汇率
中级
这是一个Other, Building Blocks领域的自动化工作流，包含 9 个节点。主要使用 Set, Code, Merge, HttpRequest, GoogleSheets 等节点。 💰 使用Google表格和ExchangeRate API自动更新发票中的汇率
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": ""
},
"nodes": [
{
"id": "9ede57d1-57de-44d5-bf64-38632e54dd73",
"name": "筛选字段",
"type": "n8n-nodes-base.set",
"position": [
580,
80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d492ffce-8ece-443d-9fc3-caa9a7a90744",
"name": "base_currency",
"type": "string",
"value": "={{ $json.base_code }}"
},
{
"id": "33e67974-8cee-4d1f-b144-c4c07b149bab",
"name": "time_last_update_utc",
"type": "string",
"value": "={{ new Date($json[\"time_last_update_utc\"]).toLocaleDateString('en-US', { year: 'numeric', month: 'long', day: 'numeric', timeZone: 'UTC' }) + ' at ' + new Date($json[\"time_last_update_utc\"]).toISOString().substring(11, 16) + ' UTC' }}\n"
}
]
}
},
"notesInFlow": true,
"retryOnFail": true,
"typeVersion": 3.4
},
{
"id": "7bb820ce-b6aa-46b6-9546-0a3d7f30fa54",
"name": "最终输出",
"type": "n8n-nodes-base.merge",
"position": [
860,
180
],
"parameters": {
"mode": "combineBySql"
},
"notesInFlow": true,
"typeVersion": 3
},
{
"id": "4eb99392-7b5c-4ec8-8eeb-56b01d5778f6",
"name": "美元查询",
"type": "n8n-nodes-base.httpRequest",
"position": [
300,
180
],
"parameters": {
"url": "https://v6.exchangerate-api.com/v6/<YOUR_API_KEY>/latest/USD",
"options": {}
},
"notesInFlow": true,
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "bc33414a-36db-41d3-881f-870d40bb929e",
"name": "更新汇率表",
"type": "n8n-nodes-base.googleSheets",
"position": [
1080,
240
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "base_currency",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "base_currency",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "time_last_update_utc",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "time_last_update_utc",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "USD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "USD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AED",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "AED",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AFN",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "AFN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ALL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ALL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AMD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "AMD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ANG",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ANG",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AOA",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "AOA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ARS",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ARS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AUD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "AUD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AWG",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "AWG",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AZN",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "AZN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BAM",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BAM",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BBD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BBD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BDT",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BDT",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BGN",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BGN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BHD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BHD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BIF",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BIF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BMD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BMD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BND",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BND",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BOB",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BOB",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BRL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BRL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BSD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BSD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BTN",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BTN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BWP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BWP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BYN",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BYN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BZD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BZD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CAD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CAD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CDF",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CDF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CHF",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CHF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CLP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CLP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CNY",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CNY",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "COP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "COP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CRC",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CRC",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CUP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CUP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CVE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CVE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CZK",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "CZK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "DJF",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "DJF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "DKK",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "DKK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "DOP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "DOP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "DZD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "DZD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EGP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "EGP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ERN",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ERN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ETB",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ETB",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EUR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "EUR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "FJD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "FJD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "FKP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "FKP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "FOK",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "FOK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GBP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "GBP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GEL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "GEL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GGP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "GGP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GHS",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "GHS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GIP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "GIP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GMD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "GMD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GNF",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "GNF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GTQ",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "GTQ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GYD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "GYD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "HKD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "HKD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "HNL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "HNL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "HRK",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "HRK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "HTG",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "HTG",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "HUF",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "HUF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "IDR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "IDR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ILS",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ILS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "IMP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "IMP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "INR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "INR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "IQD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "IQD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "IRR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "IRR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ISK",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ISK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "JEP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "JEP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "JMD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "JMD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "JOD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "JOD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "JPY",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "JPY",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KES",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "KES",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KGS",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "KGS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KHR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "KHR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "KID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KMF",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "KMF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KRW",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "KRW",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KWD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "KWD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KYD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "KYD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KZT",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "KZT",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LAK",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "LAK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LBP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "LBP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LKR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "LKR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LRD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "LRD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LSL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "LSL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LYD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "LYD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MAD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "MAD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MDL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "MDL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MGA",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "MGA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MKD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "MKD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MMK",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "MMK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MNT",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "MNT",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MOP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "MOP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MRU",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "MRU",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MUR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "MUR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MVR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "MVR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MWK",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "MWK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MXN",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "MXN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MYR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "MYR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MZN",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "MZN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NAD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "NAD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NGN",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "NGN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NIO",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "NIO",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NOK",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "NOK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NPR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "NPR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NZD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "NZD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "OMR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "OMR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PAB",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PAB",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PEN",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PEN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PGK",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PGK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PHP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PHP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PKR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PKR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PLN",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PLN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PYG",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PYG",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "QAR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "QAR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "RON",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "RON",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "RSD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "RSD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "RUB",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "RUB",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "RWF",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "RWF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SAR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SAR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SBD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SBD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SCR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SCR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SDG",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SDG",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SEK",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SEK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SGD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SGD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SHP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SHP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SLE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SLE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SLL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SLL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SOS",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SOS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SRD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SRD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SSP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SSP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "STN",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "STN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SYP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SYP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SZL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "SZL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "THB",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "THB",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TJS",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TJS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TMT",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TMT",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TND",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TND",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TOP",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TOP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TRY",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TRY",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TTD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TTD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TVD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TVD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TWD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TWD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TZS",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "TZS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "UAH",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "UAH",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "UGX",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "UGX",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "UYU",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "UYU",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "UZS",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "UZS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "VES",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "VES",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "VND",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "VND",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "VUV",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "VUV",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "WST",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "WST",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "XAF",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "XAF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "XCD",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "XCD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "XCG",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "XCG",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "XDR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "XDR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "XOF",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "XOF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "XPF",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "XPF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "YER",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "YER",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ZAR",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ZAR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ZMW",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ZMW",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ZWL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "ZWL",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"base_currency"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "=",
"value": "gid=0",
"cachedResultUrl": "=",
"cachedResultName": "="
},
"documentId": {
"__rl": true,
"mode": "=",
"value": "=",
"cachedResultUrl": "=",
"cachedResultName": "="
}
},
"notesInFlow": true,
"typeVersion": 4.5
},
{
"id": "51c05637-b9c0-4fa5-9942-42b5abb870db",
"name": "归档汇率",
"type": "n8n-nodes-base.googleSheets",
"position": [
1080,
100
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "base_currency",
"type": "string",
"display": true,
"required": false,
"displayName": "base_currency",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "time_last_update_utc",
"type": "string",
"display": true,
"required": false,
"displayName": "time_last_update_utc",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "USD",
"type": "string",
"display": true,
"required": false,
"displayName": "USD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AED",
"type": "string",
"display": true,
"required": false,
"displayName": "AED",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AFN",
"type": "string",
"display": true,
"required": false,
"displayName": "AFN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ALL",
"type": "string",
"display": true,
"required": false,
"displayName": "ALL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AMD",
"type": "string",
"display": true,
"required": false,
"displayName": "AMD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ANG",
"type": "string",
"display": true,
"required": false,
"displayName": "ANG",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AOA",
"type": "string",
"display": true,
"required": false,
"displayName": "AOA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ARS",
"type": "string",
"display": true,
"required": false,
"displayName": "ARS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AUD",
"type": "string",
"display": true,
"required": false,
"displayName": "AUD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AWG",
"type": "string",
"display": true,
"required": false,
"displayName": "AWG",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AZN",
"type": "string",
"display": true,
"required": false,
"displayName": "AZN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BAM",
"type": "string",
"display": true,
"required": false,
"displayName": "BAM",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BBD",
"type": "string",
"display": true,
"required": false,
"displayName": "BBD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BDT",
"type": "string",
"display": true,
"required": false,
"displayName": "BDT",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BGN",
"type": "string",
"display": true,
"required": false,
"displayName": "BGN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BHD",
"type": "string",
"display": true,
"required": false,
"displayName": "BHD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BIF",
"type": "string",
"display": true,
"required": false,
"displayName": "BIF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BMD",
"type": "string",
"display": true,
"required": false,
"displayName": "BMD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BND",
"type": "string",
"display": true,
"required": false,
"displayName": "BND",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BOB",
"type": "string",
"display": true,
"required": false,
"displayName": "BOB",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BRL",
"type": "string",
"display": true,
"required": false,
"displayName": "BRL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BSD",
"type": "string",
"display": true,
"required": false,
"displayName": "BSD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BTN",
"type": "string",
"display": true,
"required": false,
"displayName": "BTN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BWP",
"type": "string",
"display": true,
"required": false,
"displayName": "BWP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BYN",
"type": "string",
"display": true,
"required": false,
"displayName": "BYN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BZD",
"type": "string",
"display": true,
"required": false,
"displayName": "BZD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CAD",
"type": "string",
"display": true,
"required": false,
"displayName": "CAD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CDF",
"type": "string",
"display": true,
"required": false,
"displayName": "CDF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CHF",
"type": "string",
"display": true,
"required": false,
"displayName": "CHF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CLP",
"type": "string",
"display": true,
"required": false,
"displayName": "CLP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CNY",
"type": "string",
"display": true,
"required": false,
"displayName": "CNY",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "COP",
"type": "string",
"display": true,
"required": false,
"displayName": "COP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CRC",
"type": "string",
"display": true,
"required": false,
"displayName": "CRC",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CUP",
"type": "string",
"display": true,
"required": false,
"displayName": "CUP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CVE",
"type": "string",
"display": true,
"required": false,
"displayName": "CVE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CZK",
"type": "string",
"display": true,
"required": false,
"displayName": "CZK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "DJF",
"type": "string",
"display": true,
"required": false,
"displayName": "DJF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "DKK",
"type": "string",
"display": true,
"required": false,
"displayName": "DKK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "DOP",
"type": "string",
"display": true,
"required": false,
"displayName": "DOP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "DZD",
"type": "string",
"display": true,
"required": false,
"displayName": "DZD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EGP",
"type": "string",
"display": true,
"required": false,
"displayName": "EGP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ERN",
"type": "string",
"display": true,
"required": false,
"displayName": "ERN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ETB",
"type": "string",
"display": true,
"required": false,
"displayName": "ETB",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EUR",
"type": "string",
"display": true,
"required": false,
"displayName": "EUR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "FJD",
"type": "string",
"display": true,
"required": false,
"displayName": "FJD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "FKP",
"type": "string",
"display": true,
"required": false,
"displayName": "FKP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "FOK",
"type": "string",
"display": true,
"required": false,
"displayName": "FOK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GBP",
"type": "string",
"display": true,
"required": false,
"displayName": "GBP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GEL",
"type": "string",
"display": true,
"required": false,
"displayName": "GEL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GGP",
"type": "string",
"display": true,
"required": false,
"displayName": "GGP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GHS",
"type": "string",
"display": true,
"required": false,
"displayName": "GHS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GIP",
"type": "string",
"display": true,
"required": false,
"displayName": "GIP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GMD",
"type": "string",
"display": true,
"required": false,
"displayName": "GMD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GNF",
"type": "string",
"display": true,
"required": false,
"displayName": "GNF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GTQ",
"type": "string",
"display": true,
"required": false,
"displayName": "GTQ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GYD",
"type": "string",
"display": true,
"required": false,
"displayName": "GYD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "HKD",
"type": "string",
"display": true,
"required": false,
"displayName": "HKD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "HNL",
"type": "string",
"display": true,
"required": false,
"displayName": "HNL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "HRK",
"type": "string",
"display": true,
"required": false,
"displayName": "HRK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "HTG",
"type": "string",
"display": true,
"required": false,
"displayName": "HTG",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "HUF",
"type": "string",
"display": true,
"required": false,
"displayName": "HUF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "IDR",
"type": "string",
"display": true,
"required": false,
"displayName": "IDR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ILS",
"type": "string",
"display": true,
"required": false,
"displayName": "ILS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "IMP",
"type": "string",
"display": true,
"required": false,
"displayName": "IMP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "INR",
"type": "string",
"display": true,
"required": false,
"displayName": "INR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "IQD",
"type": "string",
"display": true,
"required": false,
"displayName": "IQD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "IRR",
"type": "string",
"display": true,
"required": false,
"displayName": "IRR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ISK",
"type": "string",
"display": true,
"required": false,
"displayName": "ISK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "JEP",
"type": "string",
"display": true,
"required": false,
"displayName": "JEP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "JMD",
"type": "string",
"display": true,
"required": false,
"displayName": "JMD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "JOD",
"type": "string",
"display": true,
"required": false,
"displayName": "JOD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "JPY",
"type": "string",
"display": true,
"required": false,
"displayName": "JPY",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KES",
"type": "string",
"display": true,
"required": false,
"displayName": "KES",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KGS",
"type": "string",
"display": true,
"required": false,
"displayName": "KGS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KHR",
"type": "string",
"display": true,
"required": false,
"displayName": "KHR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KID",
"type": "string",
"display": true,
"required": false,
"displayName": "KID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KMF",
"type": "string",
"display": true,
"required": false,
"displayName": "KMF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KRW",
"type": "string",
"display": true,
"required": false,
"displayName": "KRW",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KWD",
"type": "string",
"display": true,
"required": false,
"displayName": "KWD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KYD",
"type": "string",
"display": true,
"required": false,
"displayName": "KYD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "KZT",
"type": "string",
"display": true,
"required": false,
"displayName": "KZT",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LAK",
"type": "string",
"display": true,
"required": false,
"displayName": "LAK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LBP",
"type": "string",
"display": true,
"required": false,
"displayName": "LBP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LKR",
"type": "string",
"display": true,
"required": false,
"displayName": "LKR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LRD",
"type": "string",
"display": true,
"required": false,
"displayName": "LRD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LSL",
"type": "string",
"display": true,
"required": false,
"displayName": "LSL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LYD",
"type": "string",
"display": true,
"required": false,
"displayName": "LYD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MAD",
"type": "string",
"display": true,
"required": false,
"displayName": "MAD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MDL",
"type": "string",
"display": true,
"required": false,
"displayName": "MDL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MGA",
"type": "string",
"display": true,
"required": false,
"displayName": "MGA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MKD",
"type": "string",
"display": true,
"required": false,
"displayName": "MKD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MMK",
"type": "string",
"display": true,
"required": false,
"displayName": "MMK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MNT",
"type": "string",
"display": true,
"required": false,
"displayName": "MNT",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MOP",
"type": "string",
"display": true,
"required": false,
"displayName": "MOP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MRU",
"type": "string",
"display": true,
"required": false,
"displayName": "MRU",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MUR",
"type": "string",
"display": true,
"required": false,
"displayName": "MUR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MVR",
"type": "string",
"display": true,
"required": false,
"displayName": "MVR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MWK",
"type": "string",
"display": true,
"required": false,
"displayName": "MWK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MXN",
"type": "string",
"display": true,
"required": false,
"displayName": "MXN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MYR",
"type": "string",
"display": true,
"required": false,
"displayName": "MYR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MZN",
"type": "string",
"display": true,
"required": false,
"displayName": "MZN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NAD",
"type": "string",
"display": true,
"required": false,
"displayName": "NAD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NGN",
"type": "string",
"display": true,
"required": false,
"displayName": "NGN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NIO",
"type": "string",
"display": true,
"required": false,
"displayName": "NIO",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NOK",
"type": "string",
"display": true,
"required": false,
"displayName": "NOK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NPR",
"type": "string",
"display": true,
"required": false,
"displayName": "NPR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "NZD",
"type": "string",
"display": true,
"required": false,
"displayName": "NZD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "OMR",
"type": "string",
"display": true,
"required": false,
"displayName": "OMR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PAB",
"type": "string",
"display": true,
"required": false,
"displayName": "PAB",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PEN",
"type": "string",
"display": true,
"required": false,
"displayName": "PEN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PGK",
"type": "string",
"display": true,
"required": false,
"displayName": "PGK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PHP",
"type": "string",
"display": true,
"required": false,
"displayName": "PHP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PKR",
"type": "string",
"display": true,
"required": false,
"displayName": "PKR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PLN",
"type": "string",
"display": true,
"required": false,
"displayName": "PLN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PYG",
"type": "string",
"display": true,
"required": false,
"displayName": "PYG",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "QAR",
"type": "string",
"display": true,
"required": false,
"displayName": "QAR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "RON",
"type": "string",
"display": true,
"required": false,
"displayName": "RON",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "RSD",
"type": "string",
"display": true,
"required": false,
"displayName": "RSD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "RUB",
"type": "string",
"display": true,
"required": false,
"displayName": "RUB",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "RWF",
"type": "string",
"display": true,
"required": false,
"displayName": "RWF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SAR",
"type": "string",
"display": true,
"required": false,
"displayName": "SAR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SBD",
"type": "string",
"display": true,
"required": false,
"displayName": "SBD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SCR",
"type": "string",
"display": true,
"required": false,
"displayName": "SCR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SDG",
"type": "string",
"display": true,
"required": false,
"displayName": "SDG",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SEK",
"type": "string",
"display": true,
"required": false,
"displayName": "SEK",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SGD",
"type": "string",
"display": true,
"required": false,
"displayName": "SGD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SHP",
"type": "string",
"display": true,
"required": false,
"displayName": "SHP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SLE",
"type": "string",
"display": true,
"required": false,
"displayName": "SLE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SLL",
"type": "string",
"display": true,
"required": false,
"displayName": "SLL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SOS",
"type": "string",
"display": true,
"required": false,
"displayName": "SOS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SRD",
"type": "string",
"display": true,
"required": false,
"displayName": "SRD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SSP",
"type": "string",
"display": true,
"required": false,
"displayName": "SSP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "STN",
"type": "string",
"display": true,
"required": false,
"displayName": "STN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SYP",
"type": "string",
"display": true,
"required": false,
"displayName": "SYP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SZL",
"type": "string",
"display": true,
"required": false,
"displayName": "SZL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "THB",
"type": "string",
"display": true,
"required": false,
"displayName": "THB",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TJS",
"type": "string",
"display": true,
"required": false,
"displayName": "TJS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TMT",
"type": "string",
"display": true,
"required": false,
"displayName": "TMT",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TND",
"type": "string",
"display": true,
"required": false,
"displayName": "TND",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TOP",
"type": "string",
"display": true,
"required": false,
"displayName": "TOP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TRY",
"type": "string",
"display": true,
"required": false,
"displayName": "TRY",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TTD",
"type": "string",
"display": true,
"required": false,
"displayName": "TTD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TVD",
"type": "string",
"display": true,
"required": false,
"displayName": "TVD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TWD",
"type": "string",
"display": true,
"required": false,
"displayName": "TWD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "TZS",
"type": "string",
"display": true,
"required": false,
"displayName": "TZS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "UAH",
"type": "string",
"display": true,
"required": false,
"displayName": "UAH",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "UGX",
"type": "string",
"display": true,
"required": false,
"displayName": "UGX",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "UYU",
"type": "string",
"display": true,
"required": false,
"displayName": "UYU",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "UZS",
"type": "string",
"display": true,
"required": false,
"displayName": "UZS",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "VES",
"type": "string",
"display": true,
"required": false,
"displayName": "VES",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "VND",
"type": "string",
"display": true,
"required": false,
"displayName": "VND",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "VUV",
"type": "string",
"display": true,
"required": false,
"displayName": "VUV",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "WST",
"type": "string",
"display": true,
"required": false,
"displayName": "WST",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "XAF",
"type": "string",
"display": true,
"required": false,
"displayName": "XAF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "XCD",
"type": "string",
"display": true,
"required": false,
"displayName": "XCD",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "XCG",
"type": "string",
"display": true,
"required": false,
"displayName": "XCG",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "XDR",
"type": "string",
"display": true,
"required": false,
"displayName": "XDR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "XOF",
"type": "string",
"display": true,
"required": false,
"displayName": "XOF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "XPF",
"type": "string",
"display": true,
"required": false,
"displayName": "XPF",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "YER",
"type": "string",
"display": true,
"required": false,
"displayName": "YER",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ZAR",
"type": "string",
"display": true,
"required": false,
"displayName": "ZAR",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ZMW",
"type": "string",
"display": true,
"required": false,
"displayName": "ZMW",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ZWL",
"type": "string",
"display": true,
"required": false,
"displayName": "ZWL",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 249536536,
"cachedResultUrl": "=",
"cachedResultName": "Archives"
},
"documentId": {
"__rl": true,
"mode": "=",
"value": "=",
"cachedResultUrl": "=",
"cachedResultName": "="
}
},
"notesInFlow": true,
"typeVersion": 4.5
},
{
"id": "7e27ded4-f201-4c45-9221-23a4dbdaada1",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
740,
-280
],
"parameters": {
"color": 7,
"width": 540,
"height": 680,
"content": "### 2. 更新汇率并记录数据"
},
"typeVersion": 1
},
{
"id": "062fc991-7c1d-4aee-a85a-7b961e310c33",
"name": "格式化输出为JSON",
"type": "n8n-nodes-base.code",
"position": [
580,
280
],
"parameters": {
"jsCode": "const rates = items[0].json.conversion_rates;\n\nreturn [\n {\n json: rates\n }\n];\n"
},
"typeVersion": 2
},
{
"id": "2379c1ca-2348-4d19-b47e-8cbe5955e759",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
-280
],
"parameters": {
"color": 7,
"width": 480,
"height": 640,
"content": "### 1. 设置触发器和汇率API调用"
},
"typeVersion": 1
},
{
"id": "f383eca8-bc1f-40f7-a450-7dbbbcec4c49",
"name": "触发器 - 上午08:00",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
100,
180
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 7
}
]
}
},
"typeVersion": 1.2
},
{
"id": "64cd2e3b-2ca3-4df5-b855-b4d37912d643",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1300,
-280
],
"parameters": {
"width": 780,
"height": 540,
"content": "### 3. 需要更多详细信息？"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"USD Query": {
"main": [
[
{
"node": "Format Output to JSON",
"type": "main",
"index": 0
},
{
"node": "Filter Fields",
"type": "main",
"index": 0
}
]
]
},
"Filter Fields": {
"main": [
[
{
"node": "Final Outputs",
"type": "main",
"index": 0
}
]
]
},
"Final Outputs": {
"main": [
[
{
"node": "Update Rate Sheet",
"type": "main",
"index": 0
},
{
"node": "Archive Rates",
"type": "main",
"index": 0
}
]
]
},
"Trigger - 08:00 am": {
"main": [
[
{
"node": "USD Query",
"type": "main",
"index": 0
}
]
]
},
"Format Output to JSON": {
"main": [
[
{
"node": "Final Outputs",
"type": "main",
"index": 1
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 其他, 构建模块
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
🏤 欧盟事件抓取与 Google Sheets
🏤 使用 Google Sheets 抓取欧盟事件
If
Set
Code
+8
20 节点Samir Saci
人工智能
🗞️ AI驱动的可持续性营销简报（使用Gmail、GPT-4o）
🗞️ AI驱动的可持续性营销简报（使用Gmail、GPT-4o）
If
Set
Code
+12
21 节点Samir Saci
人工智能
🉑 使用Google Translate和GPT-4o生成语言学习Anki闪卡
🉑 使用Google Translate和GPT-4o生成语言学习Anki闪卡
If
Set
Merge
+10
21 节点Samir Saci
其他
🌳 欧盟绿色法规追踪器（GPT-4o、Google Sheets 和任务）
🌳 使用 GPT-4o、Google Sheets 和任务功能的欧盟绿色法规追踪器
If
Set
Html
+8
17 节点Samir Saci
其他
📦 使用Gmail和Google表格解析EDI消息
📦 使用Gmail和Google表格解析电子数据交换(EDI)消息
If
Set
Code
+6
17 节点Samir Saci
其他
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
工作流信息
难度等级
中级
节点数量9
分类2
节点类型7
作者
Samir Saci
@samirsaciAutomation, AI and Analytics for Supply Chain & Business Optimization Helping businesses streamline operations using n8n, AI agents, and data science to enhance efficiency and sustainability. Linkedin: www.linkedin.com/in/samir-saci
外部链接
在 n8n.io 查看 →
分享此工作流