Manage construction work permits with GPT-4o, Google Sheets and Gmail
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 23 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects Slack, Google Sheets, Gmail and OpenAI.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).
- Log Permit Submission to Sheet (Google Sheets): append
- Fetch Approved Permits from Register (Google Sheets): uses Google Sheets
- Slack: uses Slack
- Fetch Active Permits for Conflict Check (Google Sheets): uses Google Sheets
- Evaluate Permit Expiry Status (Code): runs custom JavaScript code
- Aggregate: combines items into one
- Route on Expiry or 30-min Reminder (If): checks a condition and branches into true / false
- GPT-4o Permit Conflict Check (OpenAI): uses OpenAI
- Send Permit Expiry Notification (Gmail): uses Gmail
- Send 30-min Expiry Reminder (Gmail): uses Gmail
…plus 10 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 (10)
- Error Trigger
n8n-nodes-base.errorTrigger - Slack
n8n-nodes-base.slack - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Webhook
n8n-nodes-base.webhook - Aggregate
n8n-nodes-base.aggregate - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
Quick Overview This workflow accepts construction work permit requests via webhook, logs them to Google Sheets, uses OpenAI (gpt-4o-mini) to detect conflicts against active permits, routes the request to a supervisor for approval via Gmail, then emails an…