{
  "name": "Automated inventory management with Airtable PO creation & supplier emails",
  "nodes": [
    {
      "id": "fe401179-5a8b-4232-b148-9bf4d96ceb9b",
      "name": "Get Products with low stock",
      "type": "n8n-nodes-base.airtable",
      "position": [
        -2340,
        -540
      ]
    },
    {
      "id": "46bfdc76-b244-41a9-a686-09c8eb140968",
      "name": "Get supplier Details for those low stock products",
      "type": "n8n-nodes-base.airtable",
      "position": [
        -2120,
        -540
      ]
    },
    {
      "id": "836a5efb-0cad-4508-8703-911241f0b847",
      "name": "Calculate Dynamic Re-order Quantity",
      "type": "n8n-nodes-base.code",
      "position": [
        -1900,
        -540
      ]
    },
    {
      "id": "7d04d71d-3d40-4575-b567-6e6bb8712e3a",
      "name": "Run Every Mid Night",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -2520,
        -540
      ]
    },
    {
      "id": "50c4223b-83d7-4204-a2ad-75b390b9298b",
      "name": "Create purchase records in table",
      "type": "n8n-nodes-base.airtable",
      "position": [
        -2160,
        -280
      ]
    },
    {
      "id": "87965ea3-6e2a-495d-a040-fcf15ba8bb2a",
      "name": "Search records",
      "type": "n8n-nodes-base.airtable",
      "position": [
        -2500,
        -280
      ]
    },
    {
      "id": "18390f14-6622-4f6c-8c24-ec123c4a807e",
      "name": "Remove Duplicate Product Orders",
      "type": "n8n-nodes-base.code",
      "position": [
        -2340,
        -280
      ]
    },
    {
      "id": "cc7b13bc-d8f8-4c26-b503-5d9a8fcfd010",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2600,
        -980
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "790b9e2e-63fb-4d15-b0e9-47d1ab6dfdd2",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1360,
        -520
      ]
    },
    {
      "id": "93b3ea8a-5b0a-41b6-863c-1c78bc6ec59d",
      "name": "Get Purchase Orders which are pending",
      "type": "n8n-nodes-base.airtable",
      "position": [
        -1120,
        -520
      ]
    },
    {
      "id": "4ba6d12d-cbe6-418e-a9bb-102f54451b03",
      "name": "Group products with suppliers",
      "type": "n8n-nodes-base.code",
      "position": [
        -900,
        -520
      ]
    },
    {
      "id": "ce853473-aa77-4215-a7e2-4b584f6b5986",
      "name": "Get the record id's of PO",
      "type": "n8n-nodes-base.code",
      "position": [
        -720,
        -400
      ]
    },
    {
      "id": "275e3674-127b-4acf-92cd-c554b61239f9",
      "name": "Update the PO status to sent",
      "type": "n8n-nodes-base.airtable",
      "position": [
        -500,
        -540
      ]
    },
    {
      "id": "fd03a9df-1892-465b-9dc5-6c13cb2c1f16",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1420,
        -980
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "e725f7f0-85a1-4cec-af79-fee429ff2667",
      "name": "Send PO to suppliers via Email",
      "type": "n8n-nodes-base.sendInBlue",
      "position": [
        -700,
        -700
      ]
    }
  ],
  "connections": {
    "Search records": {
      "main": [
        [
          {
            "node": "Remove Duplicate Product Orders",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get Purchase Orders which are pending",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run Every Mid Night": {
      "main": [
        [
          {
            "node": "Get Products with low stock",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get the record id's of PO": {
      "main": [
        [
          {
            "node": "Update the PO status to sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Products with low stock": {
      "main": [
        [
          {
            "node": "Get supplier Details for those low stock products",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Group products with suppliers": {
      "main": [
        [
          {
            "node": "Send PO to suppliers via Email",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get the record id's of PO",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send PO to suppliers via Email": {
      "main": [
        []
      ]
    },
    "Remove Duplicate Product Orders": {
      "main": [
        [
          {
            "node": "Create purchase records in table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create purchase records in table": {
      "main": [
        []
      ]
    },
    "Calculate Dynamic Re-order Quantity": {
      "main": [
        [
          {
            "node": "Search records",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Purchase Orders which are pending": {
      "main": [
        [
          {
            "node": "Group products with suppliers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get supplier Details for those low stock products": {
      "main": [
        [
          {
            "node": "Calculate Dynamic Re-order Quantity",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}