{
  "name": "Google Sheets and QuickBooks expenses automation template",
  "nodes": [
    {
      "id": "4678f902-8b59-42f2-adab-f123ca1f637f",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -16,
        192
      ]
    },
    {
      "id": "5b68c737-5caa-4d36-b957-5b4458c759a8",
      "name": "Get Active Vendors in QuickBooks",
      "type": "n8n-nodes-base.quickbooks",
      "position": [
        880,
        0
      ]
    },
    {
      "id": "5f464de5-83b7-4fd2-9068-93422b2356bf",
      "name": "Get Chart of Accounts",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        432,
        192
      ]
    },
    {
      "id": "0b295195-8e3b-4d64-b1ef-ca4dbfca84c9",
      "name": "Split Out Accounts",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        656,
        192
      ]
    },
    {
      "id": "aaaa6cf5-8e29-42d1-a182-b4506dd73583",
      "name": "Add Accounts to Google Sheet Template",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        880,
        192
      ]
    },
    {
      "id": "a37448d0-6c95-4bf0-8504-3519abda9d49",
      "name": "Add an Expense to QBO",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        880,
        384
      ]
    },
    {
      "id": "b1ed3c64-f832-4822-ae8a-2bf04cd7dd01",
      "name": "Get New Vendors from Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        208,
        0
      ]
    },
    {
      "id": "5ed5cff9-7c9a-48c0-90f7-fdb158e10983",
      "name": "Refresh Vendors in Google Sheet Template",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1104,
        0
      ]
    },
    {
      "id": "6de704e8-7007-4802-ac84-10f81ca21af3",
      "name": "Get New Expense Transactions",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        432,
        384
      ]
    },
    {
      "id": "17d09d9c-028a-4ccd-b2d7-1fc269e7fcca",
      "name": "Remove Duplicates",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        432,
        0
      ]
    },
    {
      "id": "ff8d137b-b491-49e4-b656-81896a6bed0e",
      "name": "Remove Empties",
      "type": "n8n-nodes-base.if",
      "position": [
        656,
        384
      ]
    },
    {
      "id": "da89ac36-ba2b-431f-b2ff-345951d90a45",
      "name": "Record Txn ID in Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1104,
        288
      ]
    },
    {
      "id": "fb36bbce-7b08-4ec1-aeaf-4fbc409a3f4c",
      "name": "Create New Vendors in QuickBooks",
      "type": "n8n-nodes-base.quickbooks",
      "position": [
        656,
        0
      ]
    },
    {
      "id": "615ced03-6162-494f-9006-7aef2b8f10b6",
      "name": "Set Realm ID for Custom API Call",
      "type": "n8n-nodes-base.set",
      "position": [
        208,
        288
      ]
    },
    {
      "id": "cd56254b-d062-40f0-87dc-f3c6d1bca8c3",
      "name": "Record Error Message",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1104,
        480
      ]
    },
    {
      "id": "cc3c8c70-63c7-4c48-bcd2-3c8321f7f489",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -800,
        -448
      ],
      "parameters": {
        "width": 660,
        "height": 2192,
        "content": "## Automatically Upload Expenses to QuickBooks from Google Sheets\n\n## What It Does\nThis n8n workflow template automates the process of uploading categorized expenses from Google Sheets into QuickBooks"
      }
    }
  ],
  "connections": {
    "Remove Empties": {
      "main": [
        [
          {
            "node": "Add an Expense to QBO",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Remove Duplicates": {
      "main": [
        [
          {
            "node": "Create New Vendors in QuickBooks",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Accounts": {
      "main": [
        [
          {
            "node": "Add Accounts to Google Sheet Template",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add an Expense to QBO": {
      "main": [
        [
          {
            "node": "Record Txn ID in Google Sheets",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Record Error Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Chart of Accounts": {
      "main": [
        [
          {
            "node": "Split Out Accounts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get New Expense Transactions": {
      "main": [
        [
          {
            "node": "Remove Empties",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create New Vendors in QuickBooks": {
      "main": [
        [
          {
            "node": "Get Active Vendors in QuickBooks",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "Get Active Vendors in QuickBooks": {
      "main": [
        [
          {
            "node": "Refresh Vendors in Google Sheet Template",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Realm ID for Custom API Call": {
      "main": [
        [
          {
            "node": "Get Chart of Accounts",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get New Expense Transactions",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get New Vendors from Google Sheets": {
      "main": [
        [
          {
            "node": "Remove Duplicates",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get New Vendors from Google Sheets",
            "type": "main",
            "index": 0
          },
          {
            "node": "Set Realm ID for Custom API Call",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Accounts to Google Sheet Template": {
      "main": [
        []
      ]
    },
    "Refresh Vendors in Google Sheet Template": {
      "main": [
        []
      ]
    }
  }
}