{
  "name": "Automate ESG compliance routing and reporting with GPT-4o, Slack and Google Sheets",
  "nodes": [
    {
      "id": "930cbe9c-6b2e-44ff-a679-2d9bd1458a04",
      "name": "Periodic Sustainability Monitoring",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        256,
        400
      ]
    },
    {
      "id": "327b9cd8-b505-4e18-9284-166cd4e77819",
      "name": "External ESG Platform Events",
      "type": "n8n-nodes-base.webhook",
      "position": [
        256,
        592
      ]
    },
    {
      "id": "e7e61ba9-02f6-48ec-8063-fe286dab79c4",
      "name": "Normalize Sustainability Input",
      "type": "n8n-nodes-base.set",
      "position": [
        480,
        496
      ]
    },
    {
      "id": "57303e02-afd8-4ca6-9557-38cb990f36e8",
      "name": "Green Governance Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1104,
        496
      ]
    },
    {
      "id": "bd259f2a-111c-4084-babc-844cc730094d",
      "name": "Governance Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        912,
        688
      ]
    },
    {
      "id": "54039690-1b8f-4095-b400-c36b08c038ca",
      "name": "ESG Compliance Output Schema",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1520,
        1008
      ]
    },
    {
      "id": "4a4aaaf0-438b-49eb-a015-f97104ca093d",
      "name": "Sustainability Oversight Agent Tool",
      "type": "@n8n/n8n-nodes-langchain.agentTool",
      "position": [
        912,
        992
      ]
    },
    {
      "id": "94042d83-f340-466d-926d-8c84619ea0a9",
      "name": "Oversight Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        912,
        1264
      ]
    },
    {
      "id": "55e957f5-b65e-48ca-9c77-eb3415c79bce",
      "name": "Sustainability Metrics Calculator",
      "type": "@n8n/n8n-nodes-langchain.toolCalculator",
      "position": [
        1104,
        1264
      ]
    },
    {
      "id": "ca938994-5b99-4384-b398-3968142b8e2a",
      "name": "ESG Scoring Engine",
      "type": "@n8n/n8n-nodes-langchain.toolCode",
      "position": [
        1312,
        1264
      ]
    },
    {
      "id": "34d69e6f-ed46-495b-9b7b-9382e85d0364",
      "name": "Multi-Cloud Sustainability API",
      "type": "n8n-nodes-base.httpRequestTool",
      "position": [
        1456,
        1264
      ]
    },
    {
      "id": "1bb3ec8c-a62c-49d0-804e-c59ab05ace97",
      "name": "ESG Reporting Sheets Tool",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        1600,
        1264
      ]
    },
    {
      "id": "88cc074d-ada0-4c87-9124-89156bf713d7",
      "name": "Governance Alerts Tool",
      "type": "n8n-nodes-base.slackTool",
      "position": [
        1200,
        992
      ]
    },
    {
      "id": "c4dd16b3-a657-422e-9070-976f5374d939",
      "name": "Compliance Documentation Tool",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        1344,
        992
      ]
    },
    {
      "id": "10d7e8cc-fc39-46b2-8b2e-c82bdfecdff9",
      "name": "Route by Approval Status",
      "type": "n8n-nodes-base.switch",
      "position": [
        1632,
        480
      ]
    },
    {
      "id": "bebfb315-df07-4c7b-b7e1-2e873b091204",
      "name": "Store Approved Sustainability Records",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        2080,
        688
      ]
    },
    {
      "id": "1a19f88e-4a28-4c8f-aba7-f70b83fadd63",
      "name": "Send Review Request",
      "type": "n8n-nodes-base.slack",
      "position": [
        1856,
        496
      ]
    },
    {
      "id": "5efe9d06-82bc-421d-812c-ec1088733f85",
      "name": "Log Rejected Items",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        2080,
        304
      ]
    },
    {
      "id": "e7762aa8-602a-4c22-b87d-ef2012fb54fa",
      "name": "Prepare Approved Record",
      "type": "n8n-nodes-base.set",
      "position": [
        1856,
        688
      ]
    },
    {
      "id": "70659d96-bdca-45ce-9329-c5878ed852b4",
      "name": "Update ESG Dashboard",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2752,
        1136
      ]
    },
    {
      "id": "82da3a03-132e-478a-ba3a-579313e77d67",
      "name": "Send Compliance Report",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2304,
        400
      ]
    },
    {
      "id": "95438d6f-c47a-4133-b30a-ac4fc18ba674",
      "name": "Sync to Enterprise ESG Platform",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2304,
        592
      ]
    },
    {
      "id": "2f835735-3732-4aa2-b690-0bcd26da8698",
      "name": "Track Environmental Impact Lineage",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        2528,
        880
      ]
    },
    {
      "id": "875a5f40-ba89-468f-b5f0-b19b277efa4e",
      "name": "Prepare Lineage Record",
      "type": "n8n-nodes-base.set",
      "position": [
        2304,
        880
      ]
    },
    {
      "id": "d3c3fd61-a5d4-4d4b-8254-7b8af71560e7",
      "name": "Log API Sync Errors",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        2752,
        496
      ]
    },
    {
      "id": "a77e2769-28e8-495a-a91f-93a882b591dd",
      "name": "Alert on Sync Failure",
      "type": "n8n-nodes-base.slack",
      "position": [
        2752,
        688
      ]
    },
    {
      "id": "b5cdbc7d-7614-41ac-9f57-3d954c620240",
      "name": "Track Green KPI Performance",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        2976,
        880
      ]
    },
    {
      "id": "970a4bbb-0c72-45ad-9898-56a4f42e0281",
      "name": "Prepare KPI Record",
      "type": "n8n-nodes-base.set",
      "position": [
        2752,
        880
      ]
    },
    {
      "id": "1e30e816-a932-4b55-8fb0-fd1acafb7f49",
      "name": "Prepare Rejected Record",
      "type": "n8n-nodes-base.set",
      "position": [
        1856,
        304
      ]
    },
    {
      "id": "310d2246-9824-4110-a123-f11f717d6384",
      "name": "Prepare Error Record",
      "type": "n8n-nodes-base.set",
      "position": [
        2528,
        592
      ]
    },
    {
      "id": "c2f1c7cc-15c4-4f21-a2f7-f1f9ef591a2f",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        880
      ],
      "parameters": {
        "width": 1504,
        "height": 576,
        "content": "## Sustainability Oversight Sub-Agent & ESG Scoring Engine\n**Why** — Applies governance rules and quantitative scoring to surface non-compliant records early."
      }
    },
    {
      "id": "58c07aa9-e7b7-415a-9b22-f30510ff0a93",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2256,
        160
      ],
      "parameters": {
        "width": 432,
        "height": 1024,
        "content": "##  Synchronise, Track Environmental Impact Lineage & Green KPI Performance\n**Why** — Maintains auditable data lineage and performance records required for regulatory reporting."
      }
    },
    {
      "id": "282086bb-1abe-436b-ae42-6f0d6f8b017b",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1552,
        208
      ],
      "parameters": {
        "width": 656,
        "height": 640,
        "content": "## Route by Approval Status\n**Why** — Rules-based routing separates rejected, under-review, and approved records for appropriate handling.\n "
      }
    },
    {
      "id": "eeffd6e1-8f7a-4580-a4cf-c932b071b494",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        672,
        320
      ],
      "parameters": {
        "width": 784,
        "height": 512,
        "content": "## Green Governance Agent\n**Why** — Orchestrates ESG scoring, compliance checks, and documentation generation in one coordinated pass."
      }
    },
    {
      "id": "79ce4150-78e0-439d-adc5-4c5356e39a47",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        64,
        320
      ],
      "parameters": {
        "width": 592,
        "height": 416,
        "content": "## Normalise Sustainability Input\n**Why** — Standardises heterogeneous ESG data before AI processing to prevent scoring errors."
      }
    },
    {
      "id": "962eb213-14d0-4dac-a365-f75b0a599ef7",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1296,
        -208
      ],
      "parameters": {
        "width": 416,
        "height": 416,
        "content": "## Prerequisites\n- OpenAI API key (or compatible LLM)\n- Slack workspace with bot credentials\n- Google Sheets with ESG log tabs pre-created\n- Enterprise ESG platform API endpoint access\n## Use Cases\n- "
      }
    },
    {
      "id": "aeae0570-6324-47d8-9354-f1c85c994a7b",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        -112
      ],
      "parameters": {
        "width": 368,
        "height": 320,
        "content": "## Setup Steps\n1. Import workflow and configure the periodic trigger interval and ESG platform webhook URL.\n2. Add AI model credentials to the Green Governance Agent and Sustainability Oversight Sub-A"
      }
    },
    {
      "id": "1d1700ea-59fc-4dc2-ad49-0eb628b8f767",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        224,
        -112
      ],
      "parameters": {
        "width": 624,
        "height": 336,
        "content": "## How It Works\nThis workflow automates end-to-end ESG (Environmental, Social, and Governance) sustainability reporting for enterprise sustainability teams, compliance officers, and green governance l"
      }
    },
    {
      "id": "8727416c-1db9-4b1b-b092-24b292041bcc",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2704,
        352
      ],
      "parameters": {
        "width": 480,
        "height": 944,
        "content": "## Update ESG Dashboard\n**Why** — Keeps the Google Sheets dashboard current for real-time stakeholder visibility."
      }
    }
  ],
  "connections": {
    "Oversight Model": {
      "ai_languageModel": [
        [
          {
            "node": "Sustainability Oversight Agent Tool",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Governance Model": {
      "ai_languageModel": [
        [
          {
            "node": "Green Governance Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "ESG Scoring Engine": {
      "ai_tool": [
        [
          {
            "node": "Sustainability Oversight Agent Tool",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Prepare KPI Record": {
      "main": [
        [
          {
            "node": "Track Green KPI Performance",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Error Record": {
      "main": [
        [
          {
            "node": "Log API Sync Errors",
            "type": "main",
            "index": 0
          },
          {
            "node": "Alert on Sync Failure",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Governance Alerts Tool": {
      "ai_tool": [
        [
          {
            "node": "Green Governance Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Green Governance Agent": {
      "main": [
        [
          {
            "node": "Route by Approval Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Lineage Record": {
      "main": [
        [
          {
            "node": "Track Environmental Impact Lineage",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Approved Record": {
      "main": [
        [
          {
            "node": "Store Approved Sustainability Records",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Rejected Record": {
      "main": [
        [
          {
            "node": "Log Rejected Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Route by Approval Status": {
      "main": [
        [
          {
            "node": "Prepare Approved Record",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Review Request",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Prepare Rejected Record",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ESG Reporting Sheets Tool": {
      "ai_tool": [
        [
          {
            "node": "Sustainability Oversight Agent Tool",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "ESG Compliance Output Schema": {
      "ai_outputParser": [
        [
          {
            "node": "Green Governance Agent",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "External ESG Platform Events": {
      "main": [
        [
          {
            "node": "Normalize Sustainability Input",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Compliance Documentation Tool": {
      "ai_tool": [
        [
          {
            "node": "Green Governance Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Multi-Cloud Sustainability API": {
      "ai_tool": [
        [
          {
            "node": "Sustainability Oversight Agent Tool",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Normalize Sustainability Input": {
      "main": [
        [
          {
            "node": "Green Governance Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sync to Enterprise ESG Platform": {
      "main": [
        [],
        [
          {
            "node": "Prepare Error Record",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sustainability Metrics Calculator": {
      "ai_tool": [
        [
          {
            "node": "Sustainability Oversight Agent Tool",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Periodic Sustainability Monitoring": {
      "main": [
        [
          {
            "node": "Normalize Sustainability Input",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Track Environmental Impact Lineage": {
      "main": [
        [
          {
            "node": "Prepare KPI Record",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sustainability Oversight Agent Tool": {
      "ai_tool": [
        [
          {
            "node": "Green Governance Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Store Approved Sustainability Records": {
      "main": [
        [
          {
            "node": "Update ESG Dashboard",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send Compliance Report",
            "type": "main",
            "index": 0
          },
          {
            "node": "Sync to Enterprise ESG Platform",
            "type": "main",
            "index": 0
          },
          {
            "node": "Prepare Lineage Record",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}