{
  "name": "Escalate negative Facebook Page reviews to Slack and Supabase tickets",
  "nodes": [
    {
      "id": "f3c71ec3-e349-4b1f-86c8-6e834ae0cc74",
      "name": "Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -256,
        -16
      ],
      "parameters": {
        "width": 520,
        "height": 540,
        "content": "## Facebook Page Negative Review Watchdog\n\n### How it works\nThis workflow receives Facebook Page reviews through a webhook and normalizes the incoming payload to extract key fields such as rating, rev"
      }
    },
    {
      "id": "8a17909d-50e7-4025-8769-f13c0a81d26d",
      "name": "Trigger & Filter",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        304,
        80
      ],
      "parameters": {
        "width": 548,
        "height": 408,
        "content": "## 1. Review Intake & Configuration\n\nReceives Facebook Page review data through a webhook and prepares the incoming payload by mapping and standardizing required fields.\n\nThis step acts as the central"
      }
    },
    {
      "id": "0edeec79-ec85-4b0a-9a31-9087b755b544",
      "name": "Alert & Storage",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        80
      ],
      "parameters": {
        "width": 596,
        "height": 408,
        "content": "## 2. Negative Review Detection & Alert\n\nChecks the review rating and continues only when the rating is 2 stars or below.\n\nFor negative reviews, an immediate Slack alert is sent to notify the support "
      }
    },
    {
      "id": "4dd9a219-65b2-4253-a541-02a2c6a48036",
      "name": "Error Handling",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1504,
        80
      ],
      "parameters": {
        "width": 724,
        "height": 408,
        "content": "## 3. Case Creation & Error Handling\n\nCreates a support record in Supabase for negative reviews.\n\nIf case creation fails, a fallback Slack alert is sent with review details to ensure visibility.\n"
      }
    },
    {
      "id": "2d549d47-4fe0-4b32-8bf1-4490eb0f5b12",
      "name": "Facebook Page Review Trigger",
      "type": "n8n-nodes-base.webhook",
      "position": [
        368,
        304
      ]
    },
    {
      "id": "2a127b69-3dfe-49f1-b4ea-9ae4aad2e5d9",
      "name": "Check Negative Review (≤ 2 Stars)",
      "type": "n8n-nodes-base.if",
      "position": [
        1008,
        304
      ]
    },
    {
      "id": "1d3f7fa5-a3af-496c-bdb2-6902c8d7e144",
      "name": "Slack – New Negative Review Alert",
      "type": "n8n-nodes-base.slack",
      "position": [
        1248,
        288
      ]
    },
    {
      "id": "03817e9d-9764-4281-b866-f26bc57cab9e",
      "name": "Create Support Case (Supabase)",
      "type": "n8n-nodes-base.supabase",
      "position": [
        1552,
        288
      ]
    },
    {
      "id": "9e952bd6-e364-4bed-9e45-1de5da095125",
      "name": "Check Case Creation Failure",
      "type": "n8n-nodes-base.if",
      "position": [
        1776,
        288
      ]
    },
    {
      "id": "39eb3b9d-b888-479f-82c6-f3477cbf14b5",
      "name": "Slack – Case Creation Failed Alert",
      "type": "n8n-nodes-base.slack",
      "position": [
        2032,
        272
      ]
    },
    {
      "id": "07173ffe-7992-429c-af22-cfc7b0875994",
      "name": "Global Configuration",
      "type": "n8n-nodes-base.set",
      "position": [
        640,
        304
      ]
    }
  ],
  "connections": {
    "Global Configuration": {
      "main": [
        [
          {
            "node": "Check Negative Review (≤ 2 Stars)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Case Creation Failure": {
      "main": [
        [
          {
            "node": "Slack – Case Creation Failed Alert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Facebook Page Review Trigger": {
      "main": [
        [
          {
            "node": "Global Configuration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Support Case (Supabase)": {
      "main": [
        [
          {
            "node": "Check Case Creation Failure",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Negative Review (≤ 2 Stars)": {
      "main": [
        [
          {
            "node": "Slack – New Negative Review Alert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Slack – New Negative Review Alert": {
      "main": [
        [
          {
            "node": "Create Support Case (Supabase)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}