{
  "name": "Daily ad spend monitoring with Google Sheets and Slack threshold alerts",
  "nodes": [
    {
      "id": "2bb6ff51-68a4-469f-be3a-73ff1886f071",
      "name": "Schedule Workflow",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1824,
        1824
      ]
    },
    {
      "id": "92feb1f7-fc98-43a5-98ed-35298b341043",
      "name": "Get Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1536,
        1712
      ]
    },
    {
      "id": "bd899d8c-dcf1-4894-a747-9b2b4ccef312",
      "name": "Sum spend by Day",
      "type": "n8n-nodes-base.summarize",
      "position": [
        -1200,
        1632
      ]
    },
    {
      "id": "d9a73468-2205-4ca6-b11e-474a4110b4d3",
      "name": "Sort Dates Descending",
      "type": "n8n-nodes-base.code",
      "position": [
        -1008,
        1824
      ]
    },
    {
      "id": "d373bb01-22d8-44d4-981e-1e2a922ef230",
      "name": "Keep only Last Day",
      "type": "n8n-nodes-base.set",
      "position": [
        -864,
        1616
      ]
    },
    {
      "id": "b1c165e8-1f43-4305-8922-fcd9edc5df5b",
      "name": "Check if Spend over $100",
      "type": "n8n-nodes-base.if",
      "position": [
        -560,
        1808
      ]
    },
    {
      "id": "3a95cc4a-58c5-4e41-a6e7-da56cd32175d",
      "name": "Send Slack Message",
      "type": "n8n-nodes-base.slack",
      "position": [
        -320,
        1728
      ]
    },
    {
      "id": "058c5690-3644-4458-990b-173a52b418ae",
      "name": "Do Nothign. Under 100",
      "type": "n8n-nodes-base.noOp",
      "position": [
        -288,
        1936
      ]
    },
    {
      "id": "1c2a3061-8010-42ad-9885-244f19e71e77",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1888,
        1024
      ],
      "parameters": {
        "width": 560,
        "height": 1000,
        "content": "#### 1️⃣ Schedule or Manual Trigger\n- **Node**: `Schedule Workflow` or `Test Workflow`\n- **Purpose**: Either run daily via a cron-like rule or manually trigger the flow.\n\n#### 2️⃣ Get Google Sheet Dat"
      }
    },
    {
      "id": "990dbac5-b790-43ee-9504-823629fc7877",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1280,
        1024
      ],
      "parameters": {
        "width": 600,
        "height": 1000,
        "content": "#### 3️⃣ Summarize Spend by Day\n- **Node**: `Sum spend by Day`\n- **What it does**: Groups the dataset by `Date` and sums the `Spend ($)` column\n- **Requirements**:\n  - Your sheet must have a header ro"
      }
    },
    {
      "id": "549bdcf3-d62a-479f-b8be-f1aea9bd8220",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -640,
        1024
      ],
      "parameters": {
        "width": 540,
        "height": 1000,
        "content": "#### 6️⃣ Check Spend Threshold\n- **Node**: `Check if Spend over $100`\n- **What it does**: Uses an IF node to compare `sum_Spend_($)` against a 100 threshold\n- **Logic**:\n```json\nsum_Spend_($) > 100\n``"
      }
    },
    {
      "id": "cd548826-5af7-4685-b5b3-3af4c24790bb",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1888,
        864
      ],
      "parameters": {
        "width": 1780,
        "height": 120,
        "content": "### 👤 Need more help?\n**Robert Breen**  \nAutomation Consultant | AI Workflow Designer | n8n Expert  \n📧 [rbreen@ynteractive.com](mailto:rbreen@ynteractive.com)  \n🔗 [LinkedIn](https://www.linkedin.com/i"
      }
    }
  ],
  "connections": {
    "Get Data": {
      "main": [
        [
          {
            "node": "Sum spend by Day",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sum spend by Day": {
      "main": [
        [
          {
            "node": "Sort Dates Descending",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Workflow": {
      "main": [
        [
          {
            "node": "Get Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Keep only Last Day": {
      "main": [
        [
          {
            "node": "Check if Spend over $100",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sort Dates Descending": {
      "main": [
        [
          {
            "node": "Keep only Last Day",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check if Spend over $100": {
      "main": [
        [
          {
            "node": "Send Slack Message",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Do Nothign. Under 100",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}