{"meta":{"instanceId":"workflow-7d86a52c","versionId":"1.0.0","createdAt":"2025-09-29T07:07:42.961175","updatedAt":"2025-09-29T07:07:42.961185","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"nodes":[{"id":"9ede57d1-57de-44d5-bf64-38632e54dd73","name":"Filter Fields","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,"notes":"This set node performs automated tasks as part of the workflow."},{"id":"7bb820ce-b6aa-46b6-9546-0a3d7f30fa54","name":"Final Outputs","type":"n8n-nodes-base.merge","position":[860,180],"parameters":{"mode":"combineBySql"},"notesInFlow":true,"typeVersion":3,"notes":"This merge node performs automated tasks as part of the workflow."},{"id":"4eb99392-7b5c-4ec8-8eeb-56b01d5778f6","name":"USD Query","type":"n8n-nodes-base.httpRequest","position":[300,180],"parameters":{"url":"{{ $env.API_BASE_URL }}<YOUR_API_KEY>/latest/USD","options":{}},"notesInFlow":true,"retryOnFail":true,"typeVersion":4.2,"notes":"This httpRequest node performs automated tasks as part of the workflow."},{"id":"bc33414a-36db-41d3-881f-870d40bb929e","name":"Update Rate Sheet","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":"{{ $env.BASE_URL }}","cachedResultName":"="},"documentId":{"__rl":true,"mode":"=","value":"=","cachedResultUrl":"{{ $env.BASE_URL }}","cachedResultName":"="}},"notesInFlow":true,"typeVersion":4.5,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"id":"51c05637-b9c0-4fa5-9942-42b5abb870db","name":"Archive Rates","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":"{{ $env.BASE_URL }}","cachedResultName":"Archives"},"documentId":{"__rl":true,"mode":"=","value":"=","cachedResultUrl":"{{ $env.BASE_URL }}","cachedResultName":"="}},"notesInFlow":true,"typeVersion":4.5,"notes":"This googleSheets node performs automated tasks as part of the workflow."},{"id":"7e27ded4-f201-4c45-9221-23a4dbdaada1","name":"Sticky Note4","type":"n8n-nodes-base.stickyNote","position":[740,-280],"parameters":{"color":7,"width":540,"height":680,"content":"### 2. Update Rates and Record Data\nThe results are recorded in two sheets\n- The invoice template sheet with the exchange rate and the update date\n- A record sheet that includes all the conversions from the base currency to any target currency\n\n#### How to setup?\n- **Update Results in Google Sheets**:\n 0. Copy and paste the template of Google Sheet: [Template Sheet]({{ $env.WEBHOOK_URL }}\n   1. Add your Google Sheet API credentials to access the Google Sheet file\n   2. Select the file using the list, an URL or an ID\n   3. Select the sheet in which the vocabulary list is stored\n  [Learn more about the Google Sheet Node]({{ $env.WEBHOOK_URL }}"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"062fc991-7c1d-4aee-a85a-7b961e310c33","name":"Format Output to 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,"notes":"This code node performs automated tasks as part of the workflow."},{"id":"2379c1ca-2348-4d19-b47e-8cbe5955e759","name":"Sticky Note","type":"n8n-nodes-base.stickyNote","position":[20,-280],"parameters":{"color":7,"width":480,"height":640,"content":"### 1. Setup the Trigger and Exchange API Call\nThe scheduler will trigger the workflow every morning at 08:00. It starts with an API call to collect the exchange rate of USD to all currency.\n\n#### How to setup?\n- **Put your API Key for exchange rate**:\n   1. Sign up for a free tier and get your API key: [API Documentation]({{ $env.API_BASE_URL }}\n   2. Replace the placeholder in the HTTP request node <YOUR_API_KEY> with your key"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."},{"id":"f383eca8-bc1f-40f7-a450-7dbbbcec4c49","name":"Trigger - 08:00 am","type":"n8n-nodes-base.scheduleTrigger","position":[100,180],"parameters":{"rule":{"interval":[{"triggerAtHour":7}]}},"typeVersion":1.2,"notes":"This scheduleTrigger node performs automated tasks as part of the workflow."},{"id":"64cd2e3b-2ca3-4df5-b855-b4d37912d643","name":"Sticky Note3","type":"n8n-nodes-base.stickyNote","position":[1300,-280],"parameters":{"width":780,"height":540,"content":"### 3. Do you need more details?\nFind a step-by-step guide in this tutorial\n![Guide]({{ $env.WEBHOOK_URL }}\n[🎥 Watch My Tutorial]({{ $env.WEBHOOK_URL }}"},"typeVersion":1,"notes":"This stickyNote node performs automated tasks as part of the workflow."}],"connections":{"USD Query":{"main":[[],[],[],[],[]]},"Update Rate Sheet":{"main":[[]]},"Archive Rates":{"main":[[]]}},"name":"Set Workflow","settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"description":"Automated workflow: Set Workflow. This workflow integrates 8 different services: stickyNote, httpRequest, code, scheduleTrigger, merge. It contains 14 nodes and follows best practices for error handling and security.","notes":"Excellent quality workflow: Set Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}