{
  "name": "Send weekly invoice summaries and overdue alerts from Google Sheets via Gmail and Slack",
  "nodes": [
    {
      "id": "ae624b0a-0d31-441c-a32f-64849ef4dcf1",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        544,
        288
      ],
      "parameters": {
        "width": 440,
        "height": 676,
        "content": "### Send weekly invoice summary with overdue alerts from Google Sheets\n\nIf you track invoices in a spreadsheet but nobody checks it until cash flow gets tight, this gives you an automatic weekly repor"
      }
    },
    {
      "id": "83283740-b51e-4ab5-a0fb-7407b5d1792d",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1072,
        384
      ],
      "parameters": {
        "width": null,
        "height": 140,
        "content": "## 1. Weekly trigger\nFires every Monday at 9 AM. Edit the schedule if you want it daily or biweekly."
      }
    },
    {
      "id": "9161ddb9-6f51-41d7-94d3-b45eae72658a",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1360,
        704
      ],
      "parameters": {
        "width": 260,
        "height": 140,
        "content": "## 2. Your settings\nSheet ID, recipient email, Slack channel, business name. Change these and you're good to go."
      }
    },
    {
      "id": "1b548090-3d80-477e-9627-dd271b3469f4",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1664,
        368
      ],
      "parameters": {
        "width": 280,
        "height": 140,
        "content": "## 3. Pull the data\nGrabs every row from your invoice spreadsheet."
      }
    },
    {
      "id": "c12fcbb2-3f81-4c8e-96c7-19e1eff60036",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1936,
        736
      ],
      "parameters": {
        "width": 300,
        "height": 140,
        "content": "## 4. Crunch the numbers\nAdds up paid, unpaid, and overdue totals. Builds the email HTML with a table of overdue invoices and how many days late each one is."
      }
    },
    {
      "id": "79add24c-176c-442b-b251-884e594022bb",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2240,
        320
      ],
      "parameters": {
        "width": 412,
        "height": 140,
        "content": "## 5. Email report + Slack alert\nThe full summary gets emailed. If any invoices are overdue, Slack gets a separate alert with the specifics."
      }
    },
    {
      "id": "d02ca829-e017-4b1e-b130-3454322a0793",
      "name": "Every Monday 9 AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        1152,
        544
      ]
    },
    {
      "id": "e06c3942-d62e-4101-bee7-f9b5a8340d88",
      "name": "Configure Settings",
      "type": "n8n-nodes-base.set",
      "position": [
        1424,
        544
      ]
    },
    {
      "id": "0bd76ab3-5fed-4d5f-b768-723cbb0c50db",
      "name": "Read All Invoices",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1728,
        544
      ]
    },
    {
      "id": "996b70f4-8cf3-439d-9a0c-ef9147fe991e",
      "name": "Calculate Totals and Find Overdue",
      "type": "n8n-nodes-base.code",
      "position": [
        2048,
        544
      ]
    },
    {
      "id": "5a21a430-64d1-4699-9c35-73d6b6046e1a",
      "name": "Email Weekly Summary",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2384,
        512
      ]
    },
    {
      "id": "ab40f58c-20ac-4e3b-a58c-296cf4db84ae",
      "name": "Any Overdue?",
      "type": "n8n-nodes-base.if",
      "position": [
        2384,
        704
      ]
    },
    {
      "id": "f336716c-b603-4b83-8535-801e0567b0e6",
      "name": "Alert Overdue to Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        2624,
        688
      ]
    }
  ],
  "connections": {
    "Any Overdue?": {
      "main": [
        [
          {
            "node": "Alert Overdue to Slack",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Every Monday 9 AM": {
      "main": [
        [
          {
            "node": "Configure Settings",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read All Invoices": {
      "main": [
        [
          {
            "node": "Calculate Totals and Find Overdue",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Configure Settings": {
      "main": [
        [
          {
            "node": "Read All Invoices",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Totals and Find Overdue": {
      "main": [
        [
          {
            "node": "Email Weekly Summary",
            "type": "main",
            "index": 0
          },
          {
            "node": "Any Overdue?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}