n8n Workflow: Carbon Emissions Reports with OpenAI, Slack & ESG Dashboard

Generate management-ready carbon emissions reports—automatically

This n8n workflow turns electricity and fuel usage into estimated CO2e using a live grid-intensity API, generates a structured OpenAI sustainability report, and then delivers the approved results to your ESG dashboard and notifies stakeholders in Slack.

What this workflow does

• Starts a reporting cycle via a webhook intake, a monthly schedule, or a manual test run.
• Fetches live grid carbon intensity from api.carbonintensity.org.uk, with a fallback factor if the request fails.
• Calculates emissions (electricity, fuel, and total CO2e) and classifies outcomes into low, medium, high, or critical based on configured thresholds.
• Pauses for human data review using a resume webhook, then continues only when the review payload indicates approval.
• Uses OpenAI to generate a structured JSON sustainability report, parsing it into a normalized report payload (with a safe fallback if parsing fails).
• Pauses for report approval via another human approval webhook.
• Upon approval, posts the report to an ESG dashboard API and sends a notification to Slack; otherwise, it marks the run as discarded.

Use cases

• Automate monthly sustainability reporting for SaaS operations and facilities by pulling consumption inputs and producing CO2e summaries.
• Implement a controlled review workflow where humans validate data and approve final sustainability outputs before publishing to an ESG dashboard.
• Create an auditable emissions workflow for internal management updates delivered via Slack.

Technical details

• Trigger options: webhook intake, monthly schedule, and manual test run.
• Core nodes: if, set, code, wait, slack, switch.
• External integrations: api.carbonintensity.org.uk (live grid intensity), OpenAI (JSON sustainability report), Slack (chat:write), and an ESG dashboard API for posting approved reports.

Setup highlights: add OpenAI credentials, configure Slack with chat:write scope and a target channel name, then update emission factors and threshold values in the workflow configuration.