n8n Workflow: Generate CO2e Emission Reports w/ GPT-4.1 & Slack

Generate CO2e emission reports from real consumption data—then share them to Slack

This n8n workflow ingests electricity and fuel consumption (via webhook, schedule, or manual run), calculates CO2e using a live grid carbon-intensity API with a safe fallback, creates a structured sustainability report with GPT-4.1, and sends only approved results to your ESG dashboard and Slack.

What this workflow does

• Starts from your inputs: Triggers using a POST webhook, a monthly schedule, or a manual test run, then loads reporting configuration and consumption data.
• Fetches live grid carbon intensity: Calls api.carbonintensity.org.uk for current grid carbon-intensity. If the request fails, it applies a static emissions factor fallback.
• Calculates and classifies CO2e: Computes electricity, fuel, and total CO2e, then categorizes the outcome into low, medium, high, or critical using configurable thresholds.
• Human review gate: Pauses for a reviewer to validate the data. The workflow continues only when the run is resumed and marked as approved.
• Generates an OpenAI sustainability report: Uses OpenAI (Chat Model) with GPT-4.1 to produce a structured report from the calculated emissions, then parses the JSON payload with a safe fallback.
• Approves or discards outputs: If approved, pushes the report to an ESG dashboard API endpoint and posts a formatted summary to a Slack channel. If not approved, it marks the run as discarded.

Use cases

• Automate monthly CO2e reporting for SaaS operations using energy and fuel data.
• Create an auditable review-and-approval workflow before emissions data reaches your ESG tooling.
• Notify stakeholders in Slack with concise emissions summaries after approval.

Technical details

• n8n nodes: if, set, code, wait, slack, switch
• Integrations: api.carbonintensity.org.uk (grid carbon intensity), OpenAI (GPT-4.1 sustainability report), Slack (chat:write), ESG dashboard API
• Setup: add OpenAI credentials, add Slack credentials with permission to post (chat:write), and configure the target Slack channel and thresholds.