{
  "name": "Pharmacy inventory alerts for low stock & expiring medicine with Google Sheets",
  "nodes": [
    {
      "id": "2697ea1c-7dcd-44eb-bf86-b3889ed5025d",
      "name": "Daily Stock Check",
      "type": "n8n-nodes-base.cron",
      "position": [
        -1000,
        440
      ]
    },
    {
      "id": "93f65b9b-ee7f-4343-bea2-afcae41cc399",
      "name": "Fetch Stock Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -780,
        440
      ]
    },
    {
      "id": "a71b7215-8278-49e1-8b32-74385c65b77c",
      "name": "Update Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -120,
        440
      ]
    },
    {
      "id": "5697579e-94b6-4fbb-8c66-b009cb7e7aaa",
      "name": "Send Email Alert",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        100,
        440
      ]
    },
    {
      "id": "1d189b60-955c-4f26-ab16-8055166e8415",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1000,
        -40
      ],
      "parameters": {
        "width": 1020,
        "height": 280,
        "content": "## 📌 Automated Pharmacy Inventory Monitoring Workflow\n\n**Daily Operations Overview:**\n- **Daily Stock Check (9 AM)**: Automated trigger to monitor inventory levels\n- **Fetch Stock Data**: Retrieves cu"
      }
    },
    {
      "id": "e062c1ab-c264-4eaa-9a9f-91354cc2bd30",
      "name": "Wait For All Data",
      "type": "n8n-nodes-base.wait",
      "position": [
        -560,
        440
      ]
    },
    {
      "id": "10f4705c-3f93-4190-bb9b-86151ee49834",
      "name": "Check Expiry Date and Low Stock",
      "type": "n8n-nodes-base.code",
      "position": [
        -340,
        440
      ]
    }
  ],
  "connections": {
    "Fetch Stock Data": {
      "main": [
        [
          {
            "node": "Wait For All Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Stock Check": {
      "main": [
        [
          {
            "node": "Fetch Stock Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait For All Data": {
      "main": [
        [
          {
            "node": "Check Expiry Date and Low Stock",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Google Sheet": {
      "main": [
        [
          {
            "node": "Send Email Alert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Expiry Date and Low Stock": {
      "main": [
        [
          {
            "node": "Update Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}