{
  "name": "Accounting Deadline Alerts Automations",
  "nodes": [
    {
      "id": "6fafe18a-6fd9-4371-8832-3344c0c04b81",
      "name": "Webhook - Receive Confirmation Update",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -16,
        1040
      ]
    },
    {
      "id": "ad9fbc87-7e24-4fd1-bf87-48b800c258f2",
      "name": "Read Company Database",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        112,
        496
      ]
    },
    {
      "id": "33c526d5-7b2e-4fe5-83a6-9573aa6b82cf",
      "name": "Build Interactive Email",
      "type": "n8n-nodes-base.code",
      "position": [
        784,
        496
      ]
    },
    {
      "id": "b903b697-226e-4724-9338-d23a4bff9d48",
      "name": "Process Webhook Data",
      "type": "n8n-nodes-base.code",
      "position": [
        208,
        1040
      ]
    },
    {
      "id": "7a603855-5722-456a-8f8a-b0a644d44369",
      "name": "Update Google Sheet Database",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        432,
        1040
      ]
    },
    {
      "id": "42a5efc8-53ea-4fe5-832a-c24a476052cb",
      "name": "Send Confirmation Page",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        656,
        1040
      ]
    },
    {
      "id": "ab9d01ab-c4bd-4481-a7bb-731aecedb828",
      "name": "Schedule Trigger1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -112,
        496
      ]
    },
    {
      "id": "08a752c6-2e29-48f5-b760-d1a349e37c57",
      "name": "Send via Gmail1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1008,
        496
      ]
    },
    {
      "id": "0d8ad3eb-adce-46bf-81ea-e1bff8f77195",
      "name": "Get Company Data",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        336,
        496
      ]
    },
    {
      "id": "0e591128-9b31-43d1-9777-2d2f8de4dbdf",
      "name": "Update Due Dates in Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        560,
        496
      ]
    },
    {
      "id": "a69802b1-4de6-4cfc-ae8d-3c6c47634c54",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -672,
        240
      ],
      "parameters": {
        "width": 448,
        "height": 416,
        "content": "## 🎯 Accounting Alerts Automation\n\n**Purpose:** Automatically track Companies House filing deadlines for UK accounting firms and prevent costly penalties (£150-£1,500 per missed deadline).\n\n**How it w"
      }
    },
    {
      "id": "e6b4486d-e96f-40ea-b420-faf3a198f9c6",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -176,
        80
      ],
      "parameters": {
        "width": 1424,
        "height": 592,
        "content": "## ## ⚙️ Daily Deadline Check & Alert System\n\n**Runs:** Every weekday at 5 PM (Mon-Fri)\n\n**What happens:**\n1. **Read Company Database** - Fetches all tracked companies from Google Sheets\n2. **Get Comp"
      }
    },
    {
      "id": "711fd3ee-397d-4a16-ad82-fe18003b00aa",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -176,
        688
      ],
      "parameters": {
        "width": 1472,
        "height": 544,
        "content": "## ## ✅ Email Response Handler (Webhook Flow)\n\n**Triggered when:** Recipient clicks \"Yes\" or \"No\" button in the alert email\n\n**What happens:**\n1. **Webhook** - Receives confirmation status (company_nu"
      }
    },
    {
      "id": "7ba61a8e-f6d3-4611-93ce-20c0421b76b4",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -672,
        704
      ],
      "parameters": {
        "width": 464,
        "height": 528,
        "content": "## ## 📋 Setup Requirements\n\n**Google Sheets Database Structure:**\nCreate a sheet with these columns:\n- company_number (manually entered)\n- company_name (manually entered)  \n- accounts_due (auto-update"
      }
    }
  ],
  "connections": {
    "Get Company Data": {
      "main": [
        [
          {
            "node": "Update Due Dates in Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger1": {
      "main": [
        [
          {
            "node": "Read Company Database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process Webhook Data": {
      "main": [
        [
          {
            "node": "Update Google Sheet Database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Company Database": {
      "main": [
        [
          {
            "node": "Get Company Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Interactive Email": {
      "main": [
        [
          {
            "node": "Send via Gmail1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Due Dates in Sheet": {
      "main": [
        [
          {
            "node": "Build Interactive Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Google Sheet Database": {
      "main": [
        [
          {
            "node": "Send Confirmation Page",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook - Receive Confirmation Update": {
      "main": [
        [
          {
            "node": "Process Webhook Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}