{
  "name": "💰 Automate currency rates update in invoices with Google Sheet, ExchangeRate API",
  "nodes": [
    {
      "id": "9ede57d1-57de-44d5-bf64-38632e54dd73",
      "name": "Filter Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        580,
        80
      ]
    },
    {
      "id": "7bb820ce-b6aa-46b6-9546-0a3d7f30fa54",
      "name": "Final Outputs",
      "type": "n8n-nodes-base.merge",
      "position": [
        860,
        180
      ]
    },
    {
      "id": "4eb99392-7b5c-4ec8-8eeb-56b01d5778f6",
      "name": "USD Query",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        300,
        180
      ]
    },
    {
      "id": "bc33414a-36db-41d3-881f-870d40bb929e",
      "name": "Update Rate Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1080,
        240
      ]
    },
    {
      "id": "51c05637-b9c0-4fa5-9942-42b5abb870db",
      "name": "Archive Rates",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1080,
        100
      ]
    },
    {
      "id": "7e27ded4-f201-4c45-9221-23a4dbdaada1",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        740,
        -280
      ],
      "parameters": {
        "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 fr"
      }
    },
    {
      "id": "062fc991-7c1d-4aee-a85a-7b961e310c33",
      "name": "Format Output to JSON",
      "type": "n8n-nodes-base.code",
      "position": [
        580,
        280
      ]
    },
    {
      "id": "2379c1ca-2348-4d19-b47e-8cbe5955e759",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        20,
        -280
      ],
      "parameters": {
        "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"
      }
    },
    {
      "id": "f383eca8-bc1f-40f7-a450-7dbbbcec4c49",
      "name": "Trigger - 08:00 am",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        100,
        180
      ]
    },
    {
      "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](https://www.samirsaci.com/content/images/2025/04/temp-6.png)\n[🎥 Watch My Tutorial](https://www.youtube.com/watch?v="
      }
    }
  ],
  "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
          }
        ]
      ]
    }
  }
}