{
  "name": "Sync multi-bank balance data to BigQuery using Plaid",
  "nodes": [
    {
      "id": "b975d014-c7f8-4f0a-af75-183ca678af46",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -272,
        560
      ]
    },
    {
      "id": "b33dba80-b6d0-4415-b90b-ba16f0e132f9",
      "name": "Fetch RBC Balances (Plaid)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -48,
        272
      ]
    },
    {
      "id": "f020756b-f0d5-48d3-83a4-f85d00f530e5",
      "name": "Fetch Amex Balances (Plaid)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -48,
        464
      ]
    },
    {
      "id": "f69faba1-668e-4aa9-9f97-2081749ebccb",
      "name": "Fetch Wise Balances (Plaid)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -48,
        656
      ]
    },
    {
      "id": "77e3e769-a9e2-469f-b7bd-35d02e39e2c0",
      "name": "Fetch PayPal Balances (Plaid)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -48,
        848
      ]
    },
    {
      "id": "316fd7af-d711-40fe-9891-b64d9b9b1d13",
      "name": "Split RBC Accounts",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        176,
        272
      ]
    },
    {
      "id": "08f9605e-0fb6-441d-8ddc-285b6c63fcc8",
      "name": "Split Amex Accounts",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        176,
        464
      ]
    },
    {
      "id": "2c41813c-4cc7-4d51-8b96-5cf740eda48b",
      "name": "Split Wise Accounts",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        176,
        656
      ]
    },
    {
      "id": "80167b88-42ed-461a-9f4e-53fa6c905105",
      "name": "Split PayPal Accounts",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        176,
        848
      ]
    },
    {
      "id": "9ed9eb63-0de6-4e3b-97ab-a493f8abc432",
      "name": "Map RBC Accounts to QBO",
      "type": "n8n-nodes-base.code",
      "position": [
        400,
        272
      ]
    },
    {
      "id": "07232bb2-7c4a-49fc-96fc-be84b08d622e",
      "name": "Map Amex Accounts to QBO",
      "type": "n8n-nodes-base.code",
      "position": [
        400,
        464
      ]
    },
    {
      "id": "56d32edb-7b52-4531-8492-da072e23d561",
      "name": "Map Wise Accounts to QBO",
      "type": "n8n-nodes-base.code",
      "position": [
        400,
        656
      ]
    },
    {
      "id": "0fb19a66-3bc2-4f86-8424-cefc2efcd4fb",
      "name": "Map PayPal Accounts to QBO",
      "type": "n8n-nodes-base.code",
      "position": [
        400,
        848
      ]
    },
    {
      "id": "c881c2f6-2169-4a4f-86fa-3a56bb62b0c4",
      "name": "Combine All Accounts",
      "type": "n8n-nodes-base.merge",
      "position": [
        624,
        528
      ]
    },
    {
      "id": "f11d0cb6-4d43-43fd-ad8d-e445b0baddbf",
      "name": "Structure Account Records",
      "type": "n8n-nodes-base.code",
      "position": [
        848,
        560
      ]
    },
    {
      "id": "49d5cc52-d430-428d-8c68-bff8e68601ee",
      "name": "Prepare BigQuery Insert",
      "type": "n8n-nodes-base.code",
      "position": [
        1072,
        560
      ]
    },
    {
      "id": "894c3083-f95a-4621-aace-1a1df6d23b08",
      "name": "Load Accounts into BigQuery",
      "type": "n8n-nodes-base.googleBigQuery",
      "position": [
        1264,
        560
      ]
    },
    {
      "id": "28abdae4-e605-482e-9c37-f3a6c86b0cc4",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1168,
        112
      ],
      "parameters": {
        "width": 768,
        "height": 656,
        "content": "## Automated Multi-Bank Balance Sync to BigQuery\n\nThis workflow automatically fetches balances from multiple financial institutions (RBC, Amex, Wise, PayPal) using Plaid, maps them to QuickBooks accou"
      }
    }
  ],
  "connections": {
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Fetch RBC Balances (Plaid)",
            "type": "main",
            "index": 0
          },
          {
            "node": "Fetch Amex Balances (Plaid)",
            "type": "main",
            "index": 0
          },
          {
            "node": "Fetch Wise Balances (Plaid)",
            "type": "main",
            "index": 0
          },
          {
            "node": "Fetch PayPal Balances (Plaid)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split RBC Accounts": {
      "main": [
        [
          {
            "node": "Map RBC Accounts to QBO",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Amex Accounts": {
      "main": [
        [
          {
            "node": "Map Amex Accounts to QBO",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Wise Accounts": {
      "main": [
        [
          {
            "node": "Map Wise Accounts to QBO",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Combine All Accounts": {
      "main": [
        [
          {
            "node": "Structure Account Records",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split PayPal Accounts": {
      "main": [
        [
          {
            "node": "Map PayPal Accounts to QBO",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Map RBC Accounts to QBO": {
      "main": [
        [
          {
            "node": "Combine All Accounts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare BigQuery Insert": {
      "main": [
        [
          {
            "node": "Load Accounts into BigQuery",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Map Amex Accounts to QBO": {
      "main": [
        [
          {
            "node": "Combine All Accounts",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Map Wise Accounts to QBO": {
      "main": [
        [
          {
            "node": "Combine All Accounts",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Structure Account Records": {
      "main": [
        [
          {
            "node": "Prepare BigQuery Insert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch RBC Balances (Plaid)": {
      "main": [
        [
          {
            "node": "Split RBC Accounts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Map PayPal Accounts to QBO": {
      "main": [
        [
          {
            "node": "Combine All Accounts",
            "type": "main",
            "index": 3
          }
        ]
      ]
    },
    "Fetch Amex Balances (Plaid)": {
      "main": [
        [
          {
            "node": "Split Amex Accounts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Wise Balances (Plaid)": {
      "main": [
        [
          {
            "node": "Split Wise Accounts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch PayPal Balances (Plaid)": {
      "main": [
        [
          {
            "node": "Split PayPal Accounts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}