{
  "name": "Generate consulting KPI summaries with GPT-4o-mini, Slack and Google Sheets",
  "nodes": [
    {
      "id": "a278412b-15a6-4682-9406-3e7edac18deb",
      "name": "Daily KPI Report Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        320,
        288
      ]
    },
    {
      "id": "fb46685c-d5d9-4cef-a2b4-848e258df807",
      "name": "Workflow Configuration",
      "type": "n8n-nodes-base.set",
      "position": [
        544,
        288
      ]
    },
    {
      "id": "25175165-9700-4099-bb40-2ce9b791d0f2",
      "name": "Fetch Client Dashboard 1 KPIs",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        784,
        192
      ]
    },
    {
      "id": "1e6781fa-99d8-4a90-8774-c300de51c64b",
      "name": "Fetch Client Dashboard 2 KPIs",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        816,
        400
      ]
    },
    {
      "id": "314f8de5-8ab1-48f5-a703-c4c0328e6abe",
      "name": "Structure KPI Data",
      "type": "n8n-nodes-base.set",
      "position": [
        992,
        288
      ]
    },
    {
      "id": "6e2833e5-1a77-47a4-9629-f3a8a580be90",
      "name": "Log KPIs to Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1216,
        288
      ]
    },
    {
      "id": "45c2d4d9-8ac6-4db9-8c66-cc49fa08f127",
      "name": "Generate KPI Summary and Insights",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1440,
        288
      ]
    },
    {
      "id": "2f82d728-5384-4561-8f75-0dafb6869153",
      "name": "OpenAI GPT-4o-mini",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1512,
        512
      ]
    },
    {
      "id": "f9b70c3b-e3e7-4c3c-b5fa-bac24099642e",
      "name": "Check Critical KPI Thresholds",
      "type": "n8n-nodes-base.switch",
      "position": [
        1792,
        288
      ]
    },
    {
      "id": "70cc1443-d4c1-418e-a3f4-6bfcc9c02127",
      "name": "Post Summary to Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        2016,
        0
      ]
    },
    {
      "id": "1b8f72cd-0f14-4341-bbe4-1b207df5839e",
      "name": "Send Critical Alert to Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        2016,
        384
      ]
    },
    {
      "id": "d01ee5ac-efd4-4cd9-b3a9-67096820681a",
      "name": "Email Full Report",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2016,
        192
      ]
    },
    {
      "id": "f10488e7-79ed-4611-aa1e-4cb937486cb4",
      "name": "Email Critical Alert",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2016,
        576
      ]
    },
    {
      "id": "60c0fdd5-c09e-4ef0-b2f4-7f42539c83fe",
      "name": "Consolidate All Branches",
      "type": "n8n-nodes-base.merge",
      "position": [
        2240,
        96
      ]
    },
    {
      "id": "e676aef8-b238-41dd-a28d-979106f12604",
      "name": "Schedule Follow-up Meeting",
      "type": "n8n-nodes-base.googleCalendar",
      "position": [
        2464,
        96
      ]
    },
    {
      "id": "1595b0ac-331f-47ac-b31a-dee65d81ee52",
      "name": "Final Logging and Formatting",
      "type": "n8n-nodes-base.set",
      "position": [
        2688,
        96
      ]
    },
    {
      "id": "805a921f-b198-4f8e-a9de-5da33c8318b6",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        272,
        48
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "c6af6197-1463-4e0c-ab7a-b100178940d7",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        768,
        48
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "2ba62c31-50f6-4802-b79e-2f2643300e6e",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1424,
        48
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "995453d5-2180-4031-ad77-053edf23d2dd",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1968,
        -80
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "d636a991-6460-4709-8133-66014c587f1f",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2400,
        -80
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "9067383b-2cbe-48c6-92fa-af90aabbb9bc",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        48
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    }
  ],
  "connections": {
    "Email Full Report": {
      "main": [
        [
          {
            "node": "Consolidate All Branches",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "OpenAI GPT-4o-mini": {
      "ai_languageModel": [
        [
          {
            "node": "Generate KPI Summary and Insights",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Structure KPI Data": {
      "main": [
        [
          {
            "node": "Log KPIs to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Post Summary to Slack": {
      "main": [
        [
          {
            "node": "Consolidate All Branches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Workflow Configuration": {
      "main": [
        [
          {
            "node": "Fetch Client Dashboard 1 KPIs",
            "type": "main",
            "index": 0
          },
          {
            "node": "Fetch Client Dashboard 2 KPIs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Consolidate All Branches": {
      "main": [
        [
          {
            "node": "Schedule Follow-up Meeting",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily KPI Report Trigger": {
      "main": [
        [
          {
            "node": "Workflow Configuration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log KPIs to Google Sheets": {
      "main": [
        [
          {
            "node": "Generate KPI Summary and Insights",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Follow-up Meeting": {
      "main": [
        [
          {
            "node": "Final Logging and Formatting",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Critical KPI Thresholds": {
      "main": [
        [
          {
            "node": "Send Critical Alert to Slack",
            "type": "main",
            "index": 0
          },
          {
            "node": "Email Critical Alert",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Post Summary to Slack",
            "type": "main",
            "index": 0
          },
          {
            "node": "Email Full Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Client Dashboard 1 KPIs": {
      "main": [
        [
          {
            "node": "Structure KPI Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Client Dashboard 2 KPIs": {
      "main": [
        [
          {
            "node": "Structure KPI Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate KPI Summary and Insights": {
      "main": [
        [
          {
            "node": "Check Critical KPI Thresholds",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}