{
  "name": "Invoice creator with Google Sheets & automated email payment reminder system",
  "nodes": [
    {
      "id": "d75d7591-4afa-427c-b436-ada9d8eb90dc",
      "name": "Monthly Invoice Trigger",
      "type": "n8n-nodes-base.cron",
      "position": [
        -180,
        -180
      ]
    },
    {
      "id": "442fcd9c-dcff-4b5f-8d3e-17823048e40a",
      "name": "Daily Payment Reminder Check",
      "type": "n8n-nodes-base.cron",
      "position": [
        -180,
        380
      ]
    },
    {
      "id": "e291b555-c948-48c4-b5a8-0e39b4c16e0b",
      "name": "Get Clients for Invoicing",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        40,
        -180
      ]
    },
    {
      "id": "d17d13ca-cf7b-42a2-8c0a-c41858b936ec",
      "name": "Get Overdue Invoices",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        40,
        380
      ]
    },
    {
      "id": "b7838069-c5ef-4a6b-8003-f976f5952c55",
      "name": "Filter Active Clients",
      "type": "n8n-nodes-base.code",
      "position": [
        260,
        -180
      ]
    },
    {
      "id": "66d888dd-020c-4d3b-845b-f93cd867e6a8",
      "name": "Filter Overdue Invoices",
      "type": "n8n-nodes-base.code",
      "position": [
        260,
        380
      ]
    },
    {
      "id": "0253a4de-ca69-4dd0-9c75-7bb686d296be",
      "name": "Generate Invoice Data",
      "type": "n8n-nodes-base.code",
      "position": [
        480,
        -180
      ]
    },
    {
      "id": "b2bebed5-0a36-4d7f-9ae1-ce5aeb17803d",
      "name": "Save Invoice to Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        700,
        -180
      ]
    },
    {
      "id": "d22a9ad6-41a6-4601-9fe4-6bb194854fbd",
      "name": "Send Invoice Email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        920,
        -180
      ]
    },
    {
      "id": "bb3d4b79-3a7e-4d7a-914a-4dbd85a8bca3",
      "name": "Calculate Reminder Type",
      "type": "n8n-nodes-base.code",
      "position": [
        480,
        380
      ]
    },
    {
      "id": "8eacfac6-b3f0-41f8-9d45-6587f3f59333",
      "name": "Switch Reminder Type",
      "type": "n8n-nodes-base.switch",
      "position": [
        700,
        359
      ]
    },
    {
      "id": "aa11ccd1-090e-4544-8c89-1957368268ff",
      "name": "Send Gentle Reminder",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        920,
        80
      ]
    },
    {
      "id": "aa04fbde-36fc-4c9d-bc0e-ef3725de3879",
      "name": "Send Follow-up Reminder",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        920,
        280
      ]
    },
    {
      "id": "da991ec5-fa55-4cbb-8fe2-d9ee1f231ca1",
      "name": "Send Urgent Reminder",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        920,
        480
      ]
    },
    {
      "id": "03806211-8278-4e6e-9aa3-9511ae7b2d6a",
      "name": "Send Final Notice",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        920,
        680
      ]
    },
    {
      "id": "b8d9735c-cf50-4b4e-b913-f21093e68dc2",
      "name": "Update Reminder Log",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1140,
        380
      ]
    },
    {
      "id": "11ef4edf-e5d2-4f0a-874c-af270b75b338",
      "name": "Log Invoice Creation",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1140,
        -180
      ]
    },
    {
      "id": "b41db4f5-4b6a-481a-b7ef-60028e651eff",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        100,
        -620
      ],
      "parameters": {
        "width": 760,
        "height": 340,
        "content": "## Invoice Creation Flow\n\n\n**Monthly Invoice Trigger** – Triggers workflow on a set monthly schedule.\n\n**Get Clients for Invoicing** – Reads client data from Google Sheet.\n\n**Filter Active Clients** –"
      }
    },
    {
      "id": "e50bfca0-4cc7-4837-a480-a29ef3d675e6",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -280,
        80
      ],
      "parameters": {
        "width": 980,
        "height": 220,
        "content": "## **Reminder Flow**\n\n**Daily Payment Reminder Check** – Triggers workflow daily to check overdue invoices.\n**Get Overdue Invoices** – Reads overdue invoices from Google Sheet.\n**Filter Overdue Invoic"
      }
    }
  ],
  "connections": {
    "Send Final Notice": {
      "main": [
        [
          {
            "node": "Update Reminder Log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Invoice Email": {
      "main": [
        [
          {
            "node": "Log Invoice Creation",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Overdue Invoices": {
      "main": [
        [
          {
            "node": "Filter Overdue Invoices",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Gentle Reminder": {
      "main": [
        [
          {
            "node": "Update Reminder Log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Urgent Reminder": {
      "main": [
        [
          {
            "node": "Update Reminder Log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch Reminder Type": {
      "main": [
        [
          {
            "node": "Send Gentle Reminder",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Follow-up Reminder",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Urgent Reminder",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Final Notice",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Active Clients": {
      "main": [
        [
          {
            "node": "Generate Invoice Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Invoice Data": {
      "main": [
        [
          {
            "node": "Save Invoice to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Reminder Type": {
      "main": [
        [
          {
            "node": "Switch Reminder Type",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Overdue Invoices": {
      "main": [
        [
          {
            "node": "Calculate Reminder Type",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Monthly Invoice Trigger": {
      "main": [
        [
          {
            "node": "Get Clients for Invoicing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Follow-up Reminder": {
      "main": [
        [
          {
            "node": "Update Reminder Log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Clients for Invoicing": {
      "main": [
        [
          {
            "node": "Filter Active Clients",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Payment Reminder Check": {
      "main": [
        [
          {
            "node": "Get Overdue Invoices",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save Invoice to Google Sheets": {
      "main": [
        [
          {
            "node": "Send Invoice Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}