Automate ESG carbon monitoring and strategy execution with GPT-4o, Slack and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 30 nodes and runs on a schedule (every 6 hours). Along the way it connects OpenAI Chat Model, Postgres, Google Sheets and Slack Hitl and 1 more.
How it runs
Trigger: On a schedule (every 6 hours).
- Carbon Supervisor Agent (AI Agent): runs an AI agent, with model: Supervisor Model; 4 tools (ESG Reporting Agent, Carbon Monitoring Agent, Policy Enforcement Agent, Carbon Optimization Agent); output parser: Supervisor Output Parser
- Route by Action Type (Switch): routes items into 4 branches
- Store Carbon Metrics (Postgres): uses Postgres
- Prepare Optimization Data (Edit Fields (Set)): sets 4 fields: optimization_summary, carbon_savings, priority…
- Send Policy Alert (Slack): uses Slack
- Update ESG Report (Google Sheets): append
- Consolidate All Actions (Merge): merges the data from its input branches
- Check Approval Required (If): checks a condition and branches into true / false
- Send ESG Report Email (Send Email): sends an email over SMTP
- Send Summary Notification (Slack): uses Slack
…plus 4 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 (18)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - 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 - Code Tool
@n8n/n8n-nodes-langchain.toolCode - Calculator
@n8n/n8n-nodes-langchain.toolCalculator - Postgres Tool
n8n-nodes-base.postgresTool - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Slack Hitl Tool
n8n-nodes-base.slackHitlTool - Switch
n8n-nodes-base.switch - Postgres
n8n-nodes-base.postgres - Edit Fields (Set)
n8n-nodes-base.set - Slack
n8n-nodes-base.slack - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Send Email
n8n-nodes-base.emailSend - Merge
n8n-nodes-base.merge
From the author
How It Works This workflow automates end-to-end carbon emissions monitoring, strategy optimisation, and ESG reporting using a multi-agent AI supervisor architecture in n8n. Designed for sustainability managers, ESG teams, and operations leads, it eliminates…