Automate ESG compliance routing and reporting with GPT-4o, Slack and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 30 nodes and runs on a schedule (every 6 hours) (plus 1 other trigger). Along the way it connects OpenAI Chat Model, HTTP Request, Google Sheets and Slack and 2 more.
How it runs
Trigger: On a schedule (every 6 hours) (plus 1 other trigger).
- Normalize Sustainability Input (Edit Fields (Set)): sets 7 fields: eventType, carbonFootprint, energyConsumption…
- Green Governance Agent (AI Agent): runs an AI agent, with model: Governance Model; 3 tools (Governance Alerts Tool, Compliance Documentation Tool, Sustainability Oversight Agent Tool); output parser: ESG Compliance Output Schema
- Route by Approval Status (Switch): routes items into 3 branches
- Prepare Approved Record (Edit Fields (Set)): sets 12 fields: approvalStatus, complianceScore, carbonFootprint…
- Send Review Request (Slack): uses Slack
- Prepare Rejected Record (Edit Fields (Set)): sets 7 fields: approvalStatus, complianceScore, carbonFootprint…
- Store Approved Sustainability Records (Data table): uses Data table
- Log Rejected Items (Data table): uses Data table
- Update ESG Dashboard (Google Sheets): append
- Send Compliance Report (Gmail): uses Gmail
…plus 8 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (19)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - AI Agent Tool
@n8n/n8n-nodes-langchain.agentTool - Calculator
@n8n/n8n-nodes-langchain.toolCalculator - Code Tool
@n8n/n8n-nodes-langchain.toolCode - Http Request Tool
n8n-nodes-base.httpRequestTool - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Slack Tool
n8n-nodes-base.slackTool - Airtable Tool
n8n-nodes-base.airtableTool - Switch
n8n-nodes-base.switch - Data table
n8n-nodes-base.dataTable - Slack
n8n-nodes-base.slack - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - HTTP Request
n8n-nodes-base.httpRequest
From the author
How It Works This workflow automates end-to-end ESG (Environmental, Social, and Governance) sustainability reporting for enterprise sustainability teams, compliance officers, and green governance leads. It solves the challenge of manually aggregating…