{
  "name": "Validate and create LEDGERS contacts from Google Sheets with error handling",
  "nodes": [
    {
      "id": "5286306a-9e2c-4e3c-9f3c-9d4ef7820c0c",
      "name": "Google Sheets Trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        0,
        0
      ]
    },
    {
      "id": "40bd5635-03d9-40fa-9f14-c8a724838c7f",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        900,
        -120
      ]
    },
    {
      "id": "ff50f240-ed69-4561-9831-a08fca231788",
      "name": "Replace Me",
      "type": "n8n-nodes-base.noOp",
      "position": [
        920,
        140
      ]
    },
    {
      "id": "dd49af1e-0bc6-4667-a59a-ff43c2adfc84",
      "name": "LEDGERS",
      "type": "@ledgers/n8n-nodes-ledgers-cloud.ledgers",
      "position": [
        1340,
        -140
      ]
    },
    {
      "id": "08263687-a6f4-4008-95ef-b625119d475d",
      "name": "Contact Name Error Mail Trigger",
      "type": "n8n-nodes-base.gmail",
      "position": [
        0,
        220
      ]
    },
    {
      "id": "8d02c452-50d4-4626-ac4e-38db7796e15c",
      "name": "Contact Name Validation",
      "type": "n8n-nodes-base.if",
      "position": [
        220,
        0
      ]
    },
    {
      "id": "f5d57159-4ecc-422f-a7c2-74c96c921d6a",
      "name": "Email & Mobile Format Checker",
      "type": "n8n-nodes-base.code",
      "position": [
        440,
        -100
      ]
    },
    {
      "id": "51a32d91-3d6a-4a3d-922d-28a681579b02",
      "name": "Email & Mobile Validator",
      "type": "n8n-nodes-base.if",
      "position": [
        660,
        -100
      ]
    },
    {
      "id": "b7d48ba7-6b06-495d-be50-ecc6bf2ef0fb",
      "name": "Email/Mobile Error Mail Trigger",
      "type": "n8n-nodes-base.gmail",
      "position": [
        440,
        120
      ]
    },
    {
      "id": "188e5335-f3cf-4044-bd7a-804c393e53df",
      "name": "Mobile Formatter",
      "type": "n8n-nodes-base.code",
      "position": [
        1120,
        -140
      ]
    },
    {
      "id": "9a91c0ae-dddb-4a56-b956-50c357c1a279",
      "name": "Contact Creation Failure Mail Trigger",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1160,
        120
      ]
    },
    {
      "id": "319837cb-0799-4b3b-a528-80ede79b2a90",
      "name": "Contact Creation Validator",
      "type": "n8n-nodes-base.if",
      "position": [
        1560,
        -140
      ]
    },
    {
      "id": "9fd8b8c5-d9bb-4cf6-a38f-7dc9e5ff366b",
      "name": "Get Created Time",
      "type": "n8n-nodes-base.code",
      "position": [
        1780,
        -160
      ]
    },
    {
      "id": "87d9c064-ade5-451a-9290-8acfc62f123c",
      "name": "Update Sheet Contact Creation",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1800,
        120
      ]
    }
  ],
  "connections": {
    "LEDGERS": {
      "main": [
        [
          {
            "node": "Contact Creation Validator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Replace Me": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Mobile Formatter",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Replace Me",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Created Time": {
      "main": [
        [
          {
            "node": "Update Sheet Contact Creation",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Mobile Formatter": {
      "main": [
        [
          {
            "node": "LEDGERS",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Trigger": {
      "main": [
        [
          {
            "node": "Contact Name Validation",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Contact Name Validation": {
      "main": [
        [
          {
            "node": "Email & Mobile Format Checker",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Contact Name Error Mail Trigger",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Email & Mobile Validator": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Email/Mobile Error Mail Trigger",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Contact Creation Validator": {
      "main": [
        [
          {
            "node": "Get Created Time",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Contact Creation Failure Mail Trigger",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Email & Mobile Format Checker": {
      "main": [
        [
          {
            "node": "Email & Mobile Validator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}