{
  "name": "Send school fee reminders with payment links via email & WhatsApp",
  "nodes": [
    {
      "id": "a4054030-d07a-4d6c-831a-ab4feb752d28",
      "name": "Daily Fee Check - 8 AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        40,
        340
      ]
    },
    {
      "id": "4f2d2d48-1816-47ea-a5e3-763a47fb5153",
      "name": "Read Pending Fees",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        260,
        340
      ]
    },
    {
      "id": "abdbf0e0-202e-4a77-bade-0923c269bd47",
      "name": "Process Fee Reminders",
      "type": "n8n-nodes-base.code",
      "position": [
        480,
        340
      ]
    },
    {
      "id": "4d9a3063-7660-4f5e-bae3-43264b93d500",
      "name": "Prepare Email Reminder",
      "type": "n8n-nodes-base.code",
      "position": [
        700,
        240
      ]
    },
    {
      "id": "00e52e34-38e0-449c-aeb7-ebd7abad5d19",
      "name": "Prepare WhatsApp Reminder",
      "type": "n8n-nodes-base.code",
      "position": [
        700,
        440
      ]
    },
    {
      "id": "feb3bb1d-09c8-4f3d-93d7-5f8a290610e0",
      "name": "Send Email Reminder",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1140,
        240
      ]
    },
    {
      "id": "5ba21990-c355-4c14-b9a8-30289b096b33",
      "name": "Update Reminder Status",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        1360,
        340
      ]
    },
    {
      "id": "d8213541-6f43-4550-b8f8-c3ff32a5892a",
      "name": "Workflow Info",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -40,
        -240
      ],
      "parameters": {
        "width": 540,
        "height": 400,
        "content": "### **Fee Reminder Workflow**\n\n**⏰ Daily Check:** Runs at 8 AM\n\n**🔍 Process:**\n1. Read pending fees from Excel\n2. Filter fees due in 3 days\n3. Generate payment links\n4. Send email & WhatsApp reminders"
      }
    },
    {
      "id": "8f415190-7c68-43fe-b9ac-8259fe14bce8",
      "name": "Wait For Prepare Reminder",
      "type": "n8n-nodes-base.wait",
      "position": [
        920,
        240
      ]
    },
    {
      "id": "08cea390-d569-4399-b1de-f84d9397c218",
      "name": "Wait For Prepare Reminder for WhatsApp",
      "type": "n8n-nodes-base.wait",
      "position": [
        920,
        440
      ]
    },
    {
      "id": "0c791c6b-f9c1-47ce-8dd2-a5f84afa51dd",
      "name": "Send message",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        1140,
        440
      ]
    }
  ],
  "connections": {
    "Send message": {
      "main": [
        [
          {
            "node": "Update Reminder Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Pending Fees": {
      "main": [
        [
          {
            "node": "Process Fee Reminders",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Email Reminder": {
      "main": [
        [
          {
            "node": "Update Reminder Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process Fee Reminders": {
      "main": [
        [
          {
            "node": "Prepare Email Reminder",
            "type": "main",
            "index": 0
          },
          {
            "node": "Prepare WhatsApp Reminder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Fee Check - 8 AM": {
      "main": [
        [
          {
            "node": "Read Pending Fees",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Email Reminder": {
      "main": [
        [
          {
            "node": "Wait For Prepare Reminder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare WhatsApp Reminder": {
      "main": [
        [
          {
            "node": "Wait For Prepare Reminder for WhatsApp",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait For Prepare Reminder": {
      "main": [
        [
          {
            "node": "Send Email Reminder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait For Prepare Reminder for WhatsApp": {
      "main": [
        [
          {
            "node": "Send message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}