{
  "name": "Automated tour payment reminders via WhatsApp & email with payment links",
  "nodes": [
    {
      "id": "33b5aa5a-20c2-4394-8136-427abc8fb678",
      "name": "Prepare WhatsApp Reminder",
      "type": "n8n-nodes-base.code",
      "position": [
        720,
        336
      ]
    },
    {
      "id": "a8e0a132-88d4-4f04-9fe9-f2d2efe8cb89",
      "name": "Update Reminder Status",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        1168,
        336
      ]
    },
    {
      "id": "030b1fe5-b3e6-4243-8902-35f7c2b77c93",
      "name": "Read Pending Travel Payment",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        272,
        336
      ]
    },
    {
      "id": "2e32c9a2-2415-4efd-913f-c050c70e68d0",
      "name": "Daily Payment Check - 7 AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        48,
        336
      ]
    },
    {
      "id": "dd933644-7cb7-4f7a-a46e-c607f53373ba",
      "name": "Process Payment Reminders",
      "type": "n8n-nodes-base.code",
      "position": [
        496,
        336
      ]
    },
    {
      "id": "64d6d6f9-e19c-4d13-a13f-301f3d22aadc",
      "name": "Send Email Reminder",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        944,
        560
      ]
    },
    {
      "id": "d32a00bb-ce08-46b8-9f99-74a85c1b21de",
      "name": "Daily Payment Check - 7 PM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        48,
        560
      ]
    },
    {
      "id": "5fe702d0-d962-4079-8a34-db870a2dc713",
      "name": "Check Pending Payment",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        272,
        560
      ]
    },
    {
      "id": "e9624483-19b9-4008-88b7-281545886494",
      "name": "Create Payment Reminders",
      "type": "n8n-nodes-base.code",
      "position": [
        496,
        560
      ]
    },
    {
      "id": "2a2c09fa-9d44-43e9-96cc-cad33f8fb39f",
      "name": "Make Reminder For Email",
      "type": "n8n-nodes-base.code",
      "position": [
        720,
        560
      ]
    },
    {
      "id": "fae21a72-36cf-478d-9906-4d97d0e4469c",
      "name": "Send Message",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        944,
        336
      ]
    },
    {
      "id": "e4b973e6-1cb5-4fe0-91a6-72ae9d262747",
      "name": "Update Status Of Reminder",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        1168,
        560
      ]
    },
    {
      "id": "80be7c99-ff21-4c7a-9576-0d03ba231628",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        -176
      ],
      "parameters": {
        "width": 608,
        "height": 192,
        "content": "## 🚀 Key Features\n- ⏰ Scheduled Daily Execution – Fully automated at 7 AM and 7 PM  \n- 🧮 Due-Date Filtering – Only targets payments due in the next 3 days  \n- 💬 Multi-Channel Notifications – Sends rem"
      }
    },
    {
      "id": "5411a3c8-b897-46f5-a71d-3d154738ceb1",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        -400
      ],
      "parameters": {
        "width": 608,
        "height": 192,
        "content": "## Description:\n\nThis workflow automatically notifies travelers about their pending trip payments and provides secure payment links through Email and WhatsApp. It runs twice daily (at 7 AM and 7 PM) t"
      }
    },
    {
      "id": "cb85e01a-051c-4d26-b6f7-d2fb8bf43708",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1072,
        -336
      ],
      "parameters": {
        "width": 608,
        "height": 288,
        "content": "## Purpose:\n\nThis workflow ensures automated, accurate, and timely payment reminders, helping travel agencies:\n\n- Maintain smooth cash flow\n\n- Minimize overdue payments\n\n- Provide a professional and a"
      }
    },
    {
      "id": "7dd63f3c-14bd-4a6c-b4f5-0c5be5a57546",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -448,
        32
      ],
      "parameters": {
        "width": 784,
        "height": 432,
        "content": "## Morning Flow (7 AM)\n\n- Daily Payment Check – 7 AM:\nScheduled trigger initiates the process.\n\n- Read Pending Travel Payment:\nReads all pending payment records from the Google Sheet.\n\n- Process Payme"
      }
    },
    {
      "id": "8a167f62-bc36-4940-9a14-fcedb0696c64",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -448,
        544
      ],
      "parameters": {
        "width": 784,
        "height": 432,
        "content": "## Evening Flow (7 PM)\n\n- Daily Payment Check – 7 PM:\nScheduled trigger for the evening run.\n\n- Check Pending Payment:\nReads pending payment data again to catch newly added records.\n\n- Create Payment "
      }
    }
  ],
  "connections": {
    "Send Message": {
      "main": [
        [
          {
            "node": "Update Reminder Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Email Reminder": {
      "main": [
        [
          {
            "node": "Update Status Of Reminder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Pending Payment": {
      "main": [
        [
          {
            "node": "Create Payment Reminders",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Make Reminder For Email": {
      "main": [
        [
          {
            "node": "Send Email Reminder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Payment Reminders": {
      "main": [
        [
          {
            "node": "Make Reminder For Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare WhatsApp Reminder": {
      "main": [
        [
          {
            "node": "Send Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process Payment Reminders": {
      "main": [
        [
          {
            "node": "Prepare WhatsApp Reminder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Payment Check - 7 AM": {
      "main": [
        [
          {
            "node": "Read Pending Travel Payment",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Payment Check - 7 PM": {
      "main": [
        [
          {
            "node": "Check Pending Payment",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Pending Travel Payment": {
      "main": [
        [
          {
            "node": "Process Payment Reminders",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}