Templates / Monitor IoT sustainability compliance and ESG reports with OpenAI, Airtable, Slack and Gmail

Monitor IoT sustainability compliance and ESG reports with OpenAI, Airtable, Slack and Gmail

Ready for 3.0

by Cheng Siong Chin ✓ · 164 views · created 2025-12-27 · Engineering, AI Summarization

Ready 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 17 nodes and runs on a schedule (every 15 minutes). Along the way it connects OpenAI Chat Model, Slack, Airtable and Gmail.

How it runs

Trigger: On a schedule (every 15 minutes).

  1. Workflow Configuration (Edit Fields (Set)): sets 7 fields: iotApiUrl, complianceThresholdEnergy, complianceThresholdWater…
  2. Get IoT Data (Airtable): uses Airtable
  3. Parse and Structure IoT Data (Code): runs custom JavaScript code
  4. Compliance Monitor Agent (AI Agent): runs an AI agent, with model: OpenAI Model - Compliance; output parser: Compliance Output Parser
  5. Anomaly Detection Agent (AI Agent): runs an AI agent, with model: OpenAI Model - Anomaly; output parser: Anomaly Output Parser
  6. Check for Issues (If): checks a condition and branches into true / false
  7. Prepare Alert Data (Edit Fields (Set)): sets 9 fields: alertType, location, timestamp…
  8. Aggregate: combines items into one
  9. Send Slack Alert (Slack): uses Slack
  10. ESG Report Generator (AI Agent): runs an AI agent, with model: OpenAI Model - ESG Report

…plus 1 more step. See the full node list below.

Services it uses

OpenAI Chat ModelSlackAirtableGmail

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 (11)

From the author

How It Works This workflow automates IoT device compliance monitoring and anomaly detection for industrial operations. Designed for facility managers, quality assurance teams, and regulatory compliance officers, it solves the challenge of continuously…

Excerpt from Cheng Siong Chin's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.